Excel #REF! error: fix broken cell references

Why formulas suddenly show #REF! after deleting or moving data, and how to repair them.

The message you see
#REF!
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Compare against an older version →

Why this happens

How to fix it

  1. 1Press Ctrl+Z right away if you just deleted something.
  2. 2Use Find (Ctrl+F) for “#REF!” to locate every broken formula.
  3. 3Rewrite the reference to the correct range, or use names / XLOOKUP so inserts don't break it.
  4. 4Check Data → Edit Links for broken external links.

Related guides

Still stuck? Ask SheetFix Support