Most spreadsheet errors are discovered by the wrong person at the wrong time — a manager spots a wrong total, a client notices a formula error, or an audit flags inconsistent numbers. A proactive audit process catches these issues before they cause damage.
This checklist covers every category of Excel error worth checking, in the order that makes the most logical sense to work through them.
Before You Start: Save a Backup
Before auditing, save a copy of the original file with a date stamp in the name (e.g., budget_2025_original.xlsx). Some audit steps involve unhiding hidden content or tracing formulas, which could change the workbook state if you are not careful.
The 8-Step Excel Audit Checklist
Check for Formula Errors
Look for any cell displaying #REF!, #VALUE!, #DIV/0!, #N/A, #NAME?, or #NUM!. These are active failures that corrupt any downstream calculation that references them. Use Ctrl+G → Special → Errors to select all error cells at once.
Unhide All Hidden Sheets
Right-click any sheet tab and choose Unhide. If the option is greyed out, there are no regular hidden sheets. For Very Hidden sheets (xlSheetVeryHidden), open the VBA editor (Alt+F11) and check each sheet's Visible property. Hidden sheets often contain source data or sensitive calculations.
Reveal Hidden Rows and Columns
Select the entire sheet (Ctrl+A), then right-click any row header and choose Unhide Rows. Do the same for columns. Hidden rows and columns can contain data that influences totals and formulas without being visible during review.
Audit External Links
Go to Data → Edit Links. This shows all external file connections. For each link, verify the source file still exists and the data is up to date. Stale external links are one of the most common causes of silently wrong values — the formula shows a cached number from months ago.
Check for Inconsistent Formulas
Scan each column that contains formulas. Every cell in a data column should use the same formula pattern — if one cell breaks the pattern, it is either an intentional exception (which should be documented) or an accidental overwrite. This is the most common silent error in financial models.
Find Hardcoded Values
Look for cells in formula columns that contain plain numbers instead of formulas. Also look inside formulas for embedded constants like =A1*0.175 — that 17.5% tax rate should live in a named cell so it can be updated in one place.
Validate Totals and Cross-References
Every SUM or total should be independently verifiable. Add a cross-check row: =SUM(row_totals)-grand_total should equal zero. If it does not, there is a discrepancy somewhere. This technique is standard practice in financial modelling.
Check Number Formatting
Numbers stored as text are invisible to SUM and AVERAGE — they are simply ignored. Look for left-aligned numbers (real numbers are right-aligned by default) and cells with a small green triangle in the top corner. These are the most common cause of "my SUM is wrong" complaints.
How Long Should an Audit Take?
A manual audit of a 10-sheet workbook takes 30–60 minutes when done thoroughly. For complex financial models, it can take hours. The most time-consuming step is checking for inconsistent formulas and hardcoded values — these require reading every formula in every column.
Automated tools drastically reduce this time. The ExcelErrorFinder audit tool performs all eight checks above in seconds, scanning every cell and producing a report with cell-by-cell explanations and fix instructions. It runs entirely in your browser — your file never leaves your device.
Documenting What You Find
Good audit practice means documenting what you found and what you changed. For each issue you fix:
- Add a cell comment (Insert → Comment) explaining what was wrong and what you changed
- Keep a change log in a separate sheet or document
- If working in a team, use a shared issue tracker so others know what has been resolved
Building an Audit-Ready Spreadsheet
The best audit is one that finds nothing to fix. Spreadsheets designed with auditability in mind are much easier to verify:
- Separate inputs from calculations — put all input values on a dedicated "Parameters" sheet, and reference them from formula sheets
- Use structured tables (Ctrl+T) — formulas auto-fill and references don't break when data changes
- Name important cells —
=Revenue*TaxRateis auditable;=B7*0.21is not - Add cross-checks — every total should have an independent verification formula
- Document exceptions — if a cell intentionally breaks a column pattern, explain why in a comment
The Fastest Way to Audit: Use a Free Tool
If you need to audit a file quickly — before a meeting, before sending to a client, or before a deadline — the ExcelErrorFinder audit tool runs all eight checks in the list above automatically. Upload your file, select the checks to run, and get a full report with:
- Every error cell, with the error type and formula
- Every inconsistent formula, with the expected pattern and the deviation
- Every hidden sheet, row, and column
- Every external link and its source file
- Every hardcoded value and overwritten formula
The report can be downloaded as a PDF and shared with your team. No signup, no upload to any server — fully private.