How to Audit a Spreadsheet in 10 Minutes (2026)

A consolidated P&L understated a division by 38% for an entire quarter. The math was right. The formula was right. The cell the formula pointed to was wrong - one source had a trailing space in the entity code, so the SUMIFS skipped the row silently. The number the CFO had been signing for three months was missing roughly a third of one entity's revenue. It cost a week of retrospectives, a board-level apology, and a review of every report the team produced. None of it would have happened if the workbook had been through a ten-minute audit before it was sent.

That story is not unusual. It is the kind of error that sits in a workbook for months and surfaces only when someone compares the report to a number from a different system. The fix is not a better analyst. The fix is a ten-minute audit, run on every workbook before the report goes out the door.

Short on time? The free Workbook X-ray runs the mechanical part of this checklist on your whole file in seconds: broken references, typed-over formulas, links to other files and approximate lookups, with cell addresses. It runs in your browser, so the file is never uploaded. Then use the checklist below for the judgement calls.

How to audit a spreadsheet - the 10-minute checklist

Seven checks, run in order. If a check fails, stop and fix the workbook before sending the report. These spreadsheet auditing steps are in order of cost - start at the top; the bottom of the list is the catch-all.

1. 1

   Open the formula bar - no hard-coded totals

   Click every total on the summary page. Every total should be =SUM or =SUBTOTAL of a range, not a typed number. A hard-coded total in a refreshable workbook is a number that silently rots.

2. 2

   Check for hidden rows in SUM ranges

   Filter the source range to a known value. Does the total change? If it does, the SUM range is including hidden rows. SUBTOTAL ignores them; SUM does not. This is the single most common error we find on inherited workbooks.

3. 3

   Trace precedents on the headline number

   Click the headline number, then Formulas > Trace Precedents. Follow the arrows. Does the chain end at a source Table, or does it end at a typed-in number on a hidden tab? If the latter, the headline is a guess, not a calculation.

4. 4

   Look for hard-coded assumptions in formulas

   1.18 for GST, 0.05 for commission, 1.05 for an FX rate - these should never live inside formulas. They should be named cells on a hidden tab. Press Ctrl+F for the magic numbers and see how many formulas contain them.

5. 5

   Verify the data types of every key column

   Click a cell in the amount column. The status bar bottom-right shows Sum and Average. If Average is missing, the column is text. SUMIFS skips text silently. This is the error that understates your revenue by 14 invoices and never warns you.

6. 6

   Reconcile the total back to the source

   Sum the detail. The total must match the headline, every time, every refresh. If they do not match, the architecture has a leak. A 1% gap is not rounding; it is a missing row, a hidden filter, or a hard-coded assumption that drifted.

7. 7

   Run the report as a stranger would

   Hand the file to a colleague who has not seen it. Time how long it takes them to answer the headline question. Under ten seconds, the design is doing its job. Over thirty seconds, the report is broken even if the numbers are right.

Excel formula auditing tricks that catch the three most common errors

In inherited workbooks, three errors account for the overwhelming majority of the gaps. These formula auditing tips will catch most problems before they become incidents.

1. 1

   Hidden rows in the SUM range

   The user filtered to one region, hit a total, then unfiltered. The filter hid rows but the SUM still counted them. The report now shows a number that includes the rows the user thought they had excluded. A common error in inherited workbooks.

2. 2

   Hard-coded assumptions inside formulas

   GST, FX, commission, discount, headcount - the magic numbers live inside formulas. When the rate changes, the report still shows the old number because no one updated the formula. The fix is named cells on an Assumptions tab; the change is one cell.

3. 3

   Text stored as numbers (or vice versa)

   An import from a CSV or a portal pastes amounts as text. SUMIFS skips them silently - no error, no warning. The total understates the source by exactly the rows that were text. The fix is =VALUE(TRIM(B2)) on the import, or Data > Text to Columns.

Make the audit structural, not heroic

A hero runs the audit on every workbook before it is sent. A good team builds the audit into the workbook, so it runs on every refresh. The architecture decisions that make a workbook auditable by construction are not complicated - three of them cover almost everything.

1. 1

   Tables for every source range

   Press Ctrl+T. A Table has a name, a growing range, and a single source of truth. The pivot, the SUMIFS, the dashboard - all of them point at the Table. New rows are picked up automatically. This is the single biggest reliability improvement you can make to a workbook.

2. 2

   Named cells for every assumption

   GST_Rate, FX_USD, Fiscal_Year_Start - one cell on a hidden tab, one name, one reference in every formula. A change to the rate is a change to one cell, and every report picks it up on refresh.

3. 3

   A Checks tab in the workbook itself

   Five rows, one column of TRUE/FALSE: sum of detail equals headline, no error values on Summary, row count of detail matches expected, every amount is a number, last refresh is fresh. If any cell is FALSE, do not send the report. The Checks tab is worth more than a quarterly review meeting.

Excel's built-in formula auditing tools

Most of the audit needs nothing beyond what Excel already ships with. These are the tools worth learning, roughly in the order you will use them:

• Trace Precedents and Trace Dependents - Formulas > Formula Auditing. Arrows show which cells feed a formula and which formulas use a cell. Ctrl+[ jumps straight to the precedents.
• Show Formulas (Ctrl+`) - Displays every formula instead of its result, so inconsistent formulas in a column stand out immediately.
• Evaluate Formula - Steps through a long formula one calculation at a time - the fastest way to find where a nested formula goes wrong.
• Error Checking - Finds #REF!, #N/A, #VALUE! and formulas that differ from their neighbours, and explains each one.
• Watch Window - Keeps key totals visible while you change inputs on other sheets, so you see the effect immediately.
• Go To Special - F5 > Special > Constants or Formulas selects every typed-in value or every formula, which exposes hard-coded numbers in a column of formulas.
• Inquire add-in - Workbook Analysis and Spreadsheet Compare list every formula, link and difference between two versions. Available in Microsoft 365 Apps for enterprise and Office Professional Plus.

Formula auditing best practices

• Keep inputs, calculations and outputs on separate sheets, with inputs clearly coloured.
• One formula per column: the same formula should run all the way down, with no one-off overrides.
• No typed-in numbers inside formulas - put rates and assumptions in named input cells.
• Use Tables and structured references so ranges grow with the data and never miss new rows.
• Reconcile every headline total back to its source system, in the workbook itself.
• Add a Checks tab of TRUE/FALSE tests that runs on every refresh.
• Write down what each sheet does in a short notes tab, so the next person can audit it too.

Audit tick marks and an audit trail in Excel

Accountants mark each number they have checked. In Excel, add a narrow “Checked” column next to the figures and put a tick in it with =UNICHAR(10003) (✓) once a value is verified, with a cell note saying what it was checked against. For the audit trail, keep the workbook on OneDrive or SharePoint and use Review > Show Changes and Version History to see who changed which cell and when, plus a short Change Log tab for decisions that need an explanation.

When to get an outside audit

If the workbook feeds a board pack, a bank covenant, a tax filing or a price list, a second pair of eyes is cheap insurance. Run the Workbook X-ray for an instant first pass, then ask for the free 7-check audit on one workbook. If it needs repairs, the spreadsheet audit and repair service fixes what fails and adds a Checks tab so the audit keeps running on every refresh.

Run it on Monday

Pick the most-sent workbook in your team this week - the one the CFO opens, the one the sales lead forwards, the one the auditor asks for. Run the ten-minute audit. You will find something. It will be a hidden row, a magic number, or a text-formatted amount. You will fix it in five minutes, and the next report that goes out the door will be the one the team trusts without anyone asking twice. The cost of the audit is ten minutes. The cost of the error you do not catch is a quarter of restatements.