Excel Audit Tools: How to Enable and Use Them

How-to basics · Updated November 20, 2026

To enable Excel’s formula-auditing tools in Microsoft 365 for Windows, show the Formulas tab on the ribbon: go to File > Options > Customize Ribbon and select Formulas under Main Tabs. Then use the Formula Auditing group to trace cell relationships, check errors, and inspect how a formula is calculated. The tools are built into Excel; you do not need to install an add-in.

These commands are useful when a result looks wrong, when a formula depends on data elsewhere in a workbook, or when you need to review a file before sharing it. The steps below explain how to restore the ribbon controls and use the main auditing features. Menu names can vary slightly between Excel releases.

What You’ll Need

  • Excel for Microsoft 365 desktop on Windows, with a workbook open. The instructions also note where Mac and web versions differ.
  • A workbook containing formulas to inspect. For a blank workbook, you can still check that the tab is visible, but tracing and evaluating formulas requires cells with formulas or references.
  • Permission to change Excel’s ribbon settings if the Formulas tab has been hidden. This setting is usually local to your Excel interface, not a change to the workbook’s formulas.

Step-by-Step

  1. Check whether the tab is hidden or the ribbon is collapsed. Look across the ribbon for Formulas. If the tab is present but its commands are not showing, click Formulas. If you see only tab names and no command groups, expand the ribbon using the Ribbon Display Options button near the upper-right corner of Excel and choose Show Tabs and Commands. A collapsed ribbon can make the tools seem unavailable even though they are enabled.
  2. Turn on the Formulas tab if it is missing. In Windows, select File > Options > Customize Ribbon. In the right-hand list under Main Tabs, select the checkbox beside Formulas, then click OK. Return to the workbook and open Formulas. The Formula Auditing group should contain commands such as Trace Precedents, Trace Dependents, Remove Arrows, Show Formulas, Error Checking, and Evaluate Formula. If the tab is already checked but still looks incomplete, continue to the next step.
  3. Restore the default tab commands if needed. A customized ribbon may have had a group removed. In File > Options > Customize Ribbon, select Formulas in the Main Tabs list. Choose Reset, then Reset only selected Ribbon tab, and confirm. This restores the default commands on that tab; it can also remove your customizations to Formulas. Avoid Reset all customizations unless you intend to reset other ribbon and toolbar changes too. Select OK and check the tab again.
  4. Trace where a formula gets its inputs. Select a cell containing a formula, then choose Formulas > Trace Precedents. Excel adds arrows from cells that feed into the selected formula. Select Trace Precedents again to follow another level of references, if available. To see which formulas rely on the selected cell, choose Trace Dependents instead. These arrows are visual aids; they do not change values or formulas. Use Remove Arrows in the same group when you have finished reviewing them.
  5. Inspect formulas and calculation steps. Select a formula cell and choose Formulas > Evaluate Formula. In the dialog, click Evaluate repeatedly to see how Excel resolves parts of the expression. This is helpful for nested formulas or unexpected results. To display formulas across the worksheet instead of their calculated results, choose Formulas > Show Formulas. Choose Show Formulas again to return to the normal results view. Widen columns if the displayed formulas are cut off.
  6. Run an error check and review warnings. Choose Formulas > Error Checking to open Excel’s error-checking dialog when it detects a possible issue. Read the explanation and inspect the suggested action before accepting it; Excel’s warning is not always proof that a formula is wrong. For a cell-specific warning, select the cell and use the warning icon that appears beside it, if present. Options for which errors Excel flags are under File > Options > Formulas, in the Error Checking section.
  7. Keep important cells under observation. For a large workbook, select Formulas > Watch Window. In the Watch Window, choose Add Watch, select the cell or range, and confirm the selection. The window can show a watched cell’s workbook, sheet, address, value, and formula while you work elsewhere. Remove a watch when it is no longer useful. This is especially handy when related inputs and outputs are on different sheets.
  8. Clear temporary audit markings before you finish. Select Formulas > Remove Arrows to clear trace arrows. Turn off Show Formulas if you enabled it, and close the Watch Window if it is taking up space. Save the workbook if you changed its contents. Merely showing or hiding ribbon controls, trace arrows, or the Watch Window does not ordinarily edit the underlying formulas.

On Mac, the auditing commands are also on the Formulas tab in supported desktop versions. If the tab is hidden, open Excel > Preferences or Settings > Ribbon & Toolbar, depending on your release, and enable Formulas. The exact reset and customization controls can differ from Windows. Excel for the web has a more limited set of desktop auditing commands; if you cannot find a particular command, open the workbook in the desktop app.

Common Mistakes

  • Looking for an add-in to install. Formula Auditing is a built-in ribbon group. The usual fix is to show the Formulas tab or restore its default commands, not to download an auditing add-in.
  • Selecting a cell with a value instead of a formula. Trace Precedents and Evaluate Formula are most useful when the selected cell contains a formula. If the cell is a typed number or text, there may be no calculation steps or useful arrows to show.
  • Assuming every arrow points to a problem. Arrows show relationships between cells, not whether a formula is correct. A valid formula can have many precedents, and an incorrect formula can still have a neat-looking chain of references.
  • Changing a formula just to clear a warning. Some green-triangle warnings flag intentional choices, such as a number stored as text or a formula that differs from nearby formulas. Review the context and the formula before choosing an error-checking action.
  • Forgetting that Show Formulas changes the worksheet display. It does not replace the results, but it can make the sheet look dramatically different. Toggle it off when you are done, especially before presenting or printing the workbook.
  • Resetting more than the intended ribbon tab. Resetting all ribbon customizations can remove personal changes across Excel. Choose the option to reset only the selected tab when you only need to restore Formula Auditing.

Tips

  • Start by checking one formula cell and tracing just one level of precedents. Expand the chain only as needed; a complex workbook can produce a crowded set of arrows that is harder to interpret than the formulas themselves.
  • Use Trace Dependents when you are considering changing or deleting an input. It can reveal formulas that rely on that cell, including downstream calculations that may not be visible on the current sheet.
  • When a formula is long, use Evaluate Formula to isolate the part returning an unexpected value. Compare each evaluated step with the expected input, rather than changing several parts of the formula at once.
  • Keep the original workbook unchanged while investigating a high-impact model. Save a separate review copy before making edits, and record which cells you checked if another person needs to follow your audit.
  • For workbook-wide review, combine formula auditing with a visual scan of the relevant sheets. The arrows follow formula references, but they do not explain the business meaning of a number or confirm that the source data is appropriate.

Troubleshooting

Formulas is not listed in Customize Ribbon: Make sure you are looking under Main Tabs, not the Commands list on the left. If you are using Excel for the web, its ribbon customization options are not the same as desktop Excel. Open the workbook in the Windows or Mac desktop app for the full set of commands.

The tab is visible, but Formula Auditing is missing: Reopen File > Options > Customize Ribbon, select Formulas in the Main Tabs list, and use Reset > Reset only selected Ribbon tab. If your organization manages Office settings, some customization options may be restricted; contact your administrator if the reset is unavailable.

Trace commands are dimmed or do not draw arrows: Select a cell that contains a formula and try again. Check that the sheet is not protected in a way that restricts the action, and confirm the referenced cells are in the workbook. Some links to external workbooks or complex references may not display as a simple on-sheet arrow. You can still inspect the formula in the formula bar or use Evaluate Formula where supported.

Error Checking does not flag the issue you expected: Excel checks for particular patterns, not every possible logic error. Review File > Options > Formulas to see whether relevant error-checking rules are enabled. A formula can return a plausible but incorrect answer without triggering a warning, so compare its references and calculation steps with the intended logic.

Show Formulas appears to do nothing or the sheet becomes unreadable: Check whether the command is toggled on; columns may need widening to display full formulas. Click Show Formulas again to return to results. If you are using a keyboard shortcut, verify your device’s keyboard layout and use the ribbon command to avoid confusion.

Frequently Asked Questions

Do I have to enable Formula Auditing separately?
No. The tools are built into desktop Excel. You may need to show the Formulas tab or restore its default ribbon group, but there is no separate Formula Auditing add-in required.

Does enabling the tools change my formulas?
No. Showing the tab and opening the auditing commands do not change calculations. Trace arrows and the Watch Window are review aids. Formula edits, error-checking choices that alter a cell, and other workbook edits can change content, so inspect prompts before accepting them.

Can I audit formulas in Excel for the web?
You can inspect and edit formulas in the web app, but the desktop ribbon offers a fuller and more consistent set of auditing tools. Use Open in Desktop App when a command such as Evaluate Formula or a particular trace option is unavailable online.

Why can’t I trace a formula to another workbook?
References to external workbooks may not produce the same clear arrows as cells within the current workbook. Check the formula bar for the external reference, confirm the source workbook path, and open the source workbook if you need to inspect its inputs.

How do I remove the arrows after tracing?
Choose Formulas > Remove Arrows. If you have also turned on Show Formulas, select that command again to return to the normal worksheet display. Removing arrows does not remove or alter cell formulas.

Are Excel’s error warnings a complete audit?
No. Error Checking can identify common suspicious patterns, but it cannot verify that a workbook’s assumptions, source data, or intended business logic are correct. Review formulas and inputs against the purpose of the workbook.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.