Catching spreadsheet errors before they ship

The errors that hide in plain sight

The dangerous mistakes are the plausible ones: a number that is the right shape but the wrong value, a formula copied down that quietly stopped covering the rows it should, a reference pointing one column off. Nothing is flagged, because nothing is malformed — it is simply wrong.

These survive precisely because a spreadsheet looks orderly. The order is what you learn to read against: the odd cell is the one that breaks the pattern of the column around it.

Scan a column for the value that breaks the pattern

Read a column for its shape before its contents — the rough magnitude, the number of decimals, the sign, the format. An outlier usually shows up as a break in that shape faster than by checking each figure, which is what makes a fast scan more reliable than a slow read.

This is a trainable eye. Spot the Odd Cell puts one wrong value in a field of plausible ones and asks you to find it, which is the same move as proofreading a real sheet with the stakes removed.

Audit formulas for the wrong range

Totals are the classic trap: a sum that looks complete but omits the last row added, or a range that starts one cell too low. The output is a believable number, so it passes a glance. Read the range a formula actually covers against the range it should, rather than trusting the result.

Formula Audit is exactly this drill — a column of formulas with one whose range or reference is wrong, to find by reading the logic rather than the answer.

Build the habit

Give a sheet one deliberate pass before it leaves you, separate from building it — making and checking are different modes, and doing both at once does neither well. A minute of scanning against the pattern catches most of what a fresh reader would have caught first, and by then it would already be in a report.