Excel's error messages are consistent — the same symbol always means the same underlying problem. Once you know what each one is actually telling you, fixing it becomes mechanical rather than mysterious. Here's the full reference.
#### — column too narrow
Not technically an error, but treated like one. It means the cell's content (usually a number, date, or time) is too wide to display in the current column width.
Fix: widen the column by dragging its header border, or double-click the border to auto-fit the content.
#DIV/0! — division by zero
Appears when a formula divides by zero or by an empty cell, since Excel can't define that result.
Fix: check whether the denominator cell is genuinely supposed to be empty or zero. If it's a legitimate possibility in your data (not an error), wrap the formula in IFERROR() to show a custom message instead of the raw error: =IFERROR(A1/B1, "N/A").
#N/A — value not found
The most common error in lookup formulas (VLOOKUP, HLOOKUP, MATCH, INDEX). It means the value you're searching for doesn't exist in the range you're searching.
Fix: double-check for typos or extra spaces in either the lookup value or the source data — these are the most frequent causes. The TRIM() function removes invisible extra spaces that often cause this. If a missing value is expected sometimes, use IFNA() to show a friendlier message: =IFNA(VLOOKUP(...), "Not found").
#NAME? — Excel doesn't recognize something in the formula
Almost always a spelling mistake in a function name, or text in a formula that's missing its quotation marks.
Fix: carefully re-check the function name spelling, and confirm that any text values are wrapped in quotation marks.
Tip: Excel's autocomplete usually prevents this error for built-in functions, since it suggests the correct name as you type. #NAME? errors are more common when copying formulas between Excel versions that don't support the same function set, or when a function was renamed in a newer version.
#REF! — invalid cell reference
Happens when a formula refers to a cell that no longer exists, typically because rows, columns, or cells it depended on were deleted.
Fix: if you just made the deletion, pressing Ctrl+Z (or Cmd+Z on Mac) immediately undoes it and restores the reference. Otherwise, you'll need to manually correct the formula to point at the right cell again. Using named ranges instead of plain cell references makes formulas more resistant to this error going forward, since the name stays valid even if the underlying cells shift.
#VALUE! — wrong data type
Occurs when a formula encounters a type it can't work with, most often text where a number is expected.
Fix: check whether a cell that looks numeric is actually formatted as text (common when data is imported from another system). The VALUE() function converts text-formatted numbers into actual numbers Excel can calculate with. Hidden spaces or non-printable characters in a cell can also trigger this — TRIM() and CLEAN() help remove them.
#NULL! — incorrect range operator
The least common error most people encounter. It happens when a space character is mistakenly used where a colon or comma should be — Excel interprets space as the "range intersect" operator, so A2 B2 (with a space) is read completely differently from A2:B2 or A2,B2.
Fix: check your formula for an accidental space where a colon (range) or comma (combining references) belongs.
#SPILL! — blocked dynamic array
A newer error tied to dynamic array formulas (like modern FILTER or SORT functions) that need to output results across multiple cells. It appears when something already occupies a cell in that output range.
Fix: clear out whatever's blocking the output range, or move the formula to a location with enough empty cells below and to the right.
#CALC! — calculation error in an array function
Often appears when a function like FILTER has nothing to return, commonly due to a typo in the filter criteria that doesn't match anything in the data.
Fix: double-check the spelling and exact match criteria used in the filter or array formula against the actual data.
#NUM! — invalid numeric result
Shows up when a calculation produces a number outside what Excel can handle — extremely large or small numbers, or mathematically impossible operations like a negative number's square root.
Fix: check whether your formula is producing an unreasonably large or invalid result. For formulas like RATE, IRR, or XIRR that rely on iterative calculation, enabling iterative calculation under File > Options > Formulas sometimes resolves this by letting Excel attempt multiple solutions.
Circular reference warning
Not marked with a # symbol, but just as common. It happens when a formula refers back to its own cell, directly or through a chain of other cells, creating an infinite loop.
Fix: go to Formulas > Error Checking > Circular References to have Excel identify and select the problematic cell, then adjust the formula to remove the self-reference.
A faster way to catch these going forward
Excel's built-in error checking (File > Options > Formulas on Windows, or Excel > Preferences > Error Checking on Mac) flags many of these automatically as you work, rather than waiting for you to notice a broken cell later. Turning this on is worth it for any spreadsheet you're actively building rather than just reviewing.