Microsoft Office Tutorials and References
In Depth Information
Checking for Errors Automatically One at a Time
You can selectively clear the arrows from
the screen by clicking the arrow on the
Remove Arrows button on the Formulas
tab, and selecting either Remove
Precedent Arrows or Remove Dependent
Arrows from the menu that appears.
Both of these options remove precedent/
dependent arrows one level at a time—so
repeat the command to remove the next
level and so on. By the way, if you select
Remove Arrows from this menu, all
arrows are removed instantly.
Arrows point to precedent cell(s) of an error cell.
Tracing an Error
When a formula contains an error that Excel
recognizes, it often displays an error message in the
result cell, such as #NULL! Once you know that
a formula contains a recognizable error, you can
quickly trace its precedents to see where the error
value may be coming from. Follow these steps:
You can also click the Error Checking
button that appears when you click in the
error cell, and select Trace Error from
the menu that appears, in order to quickly
trace the formula’s precedents.
1. Click the cell that contains an error message
you want to trace.
2. Click the arrow on the Error Checking button
on the Formulas tab. Blue arrow(s) point
from the selected cell to any cells referenced
by the formula in that cell, as shown in