Formula -> Trace Dependencies/Precedents is also super handy! I have a short VBA loop that applies it to all selected cells. It makes it very easy to visually spot one cell reference that's wrong, because 20 cells connect to corresponding cells with parallel lines, then one isn't parallel.

Ctrl+Tilda toggles show/hide formulas, which helps identify input cells when you inherit a messy spreadsheet.