How to locate every #ref! error caused by column or row deletion in excel
- Step 1Save the workbook after the column deletion — Do not undo yet — save and drop the .xlsx into the Error Locator to get the full error inventory first.
- Step 2Review the #REF! error list — Every broken cell is listed with its sheet, address, and the original formula showing the deleted reference.
- Step 3Repair formulas using the address list — Use the address list to navigate directly to each broken formula in Excel and update the reference.
Frequently asked questions
Can I undo the column deletion instead?+
If Ctrl+Z is still available, undoing is faster. The Error Locator is most useful when the error-producing change was saved or cannot be undone.
Does it show which deleted column the formula was referencing?+
#REF! replaces the deleted range in the formula string. For example =A2+#REF! shows the formula with the broken reference in place.
Can it fix the #REF! errors automatically?+
Locating only in the current version. Auto-repair of #REF! errors requires knowing the intended replacement column, which is context-specific.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.