Microsoft Office Tutorials and References
In Depth Information
Audit a Formula to Locate Errors
Chapter 4: Getting More Out of Formulas
1 Click the cell containing
the error you want to
2 Click the Formulas tab.
3 Click Remove Arrows.
Note: You must first remove any
existing arrows before you can trace
4 Click here to display
the Error Checking
5 Click Trace Error.
Excel selects the cells that
contain the original error.
Excel displays tracer
arrows showing the
selected cells’ precedents
A red tracer arrow
indicates an error.
If you have a large spreadsheet, you can use the Error Checking feature to look for and
trace errors. Click the Formulas tab, and then click Error Checking ( ) in the Formula
Auditing group. Excel displays the Error Checking dialog box, which displays the first
error, if any. You have the following choices:
● Trace Error: You see this button if the error is caused by an error in another cell. Click
this button to display tracer arrows for the formula’s precedents and dependents.
● Show Calculation Steps: You see this button if the error is caused by the cell’s
formula. Click this button to launch the Evaluate Formula feature, as described in the
section, “Troubleshoot a Formula by Stepping Through Each Part.”
● Ignore Error: Click this button to bypass the error.
Use the Previous and Next buttons to navigate the worksheet errors.