Microsoft Office Tutorials and References
In Depth Information
Audit a Formula to Locate Errors
Chapter 4: Getting More Out of Formulas
Trace Errors
1 Click the cell containing
the error you want to
trace.
2 Click the Formulas tab.
3 Click Remove Arrows.
Note: You must first remove any
existing arrows before you can trace
an error.
4 Click here to display
the Error Checking
drop-down list.
5 Click Trace Error.
2
4
3
5
1
Excel selects the cells that
contain the original error.
Excel displays tracer
arrows showing the
selected cells’ precedents
and dependents.
A red tracer arrow
indicates an error.
More Options!
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.
 
Search JabSto ::




Custom Search