Home / Error Lookup / #REF!

#REF!

Excel #REF! Error Applies to: Windows 7, Windows 10, Windows 11

What it means

A formula is pointing to a cell that no longer exists — usually because a row, column, or sheet it referenced was deleted.

Also seen as: #REF!, REF error

Quick fix steps

  1. If you just deleted something, press Ctrl+Z to undo it before the reference breaks permanently.
  2. Click the cell showing #REF! and check exactly which part of the formula is broken.
  3. Rebuild the reference by retyping the correct cell or range.
For the full step-by-step walkthrough, see Understanding Excel Formula Errors (#REF!, #VALUE!, and More).

Frequently Asked Questions

Can I undo whatever caused a #REF! error?
Yes, if you catch it right away — pressing Ctrl+Z immediately after deleting the row, column, or cell that caused it can restore the reference before you make further changes.
Does #REF! mean my whole spreadsheet is broken?
No — it only affects the specific formula(s) that referenced the now-missing cell. The rest of your spreadsheet continues working normally.

Other error codes

#VALUE! — #VALUE! Error

The formula received the wrong type of data — commonly text where it expected a number.

#DIV/0! — #DIV/0! Error

The formula is dividing by zero or by an empty cell.

#N/A — #N/A Error

A lookup formula (VLOOKUP, MATCH, XLOOKUP, INDEX/MATCH) couldn't find a matching value.

#NAME? — #NAME? Error

Excel doesn't recognize text used in the formula — most often a misspelled function name or a missing quotation mark.