How to fix #REF! in Excel and Google Sheets
What you see
- #REF! in the cell
- Formula worked before you deleted columns or rows
Common causes
- A referenced cell or range was deleted
- A sheet name in the formula is wrong
How to fix it
- Click the cell and read the formula in the formula bar
- Find the broken reference (often highlighted)
- Point the formula at the correct cells or sheet