Microsoft Office Tutorials and References
In Depth Information
Checking for Errors Automatically One at a Time
Checking for Errors
Excel ﬂags most errors with a message
such as #NULL! Or #NA, and if you like, it can
even add a small triangle to the upper corner of
an error cell. You can then go hunting through a
worksheet looking for these messages and little
flags (if shown) and correct formula errors one
Select an Option to Fix the Error
Another way in which you can check a
worksheet for errors (whether or not you display
error flags) is to have Excel point the errors out
to you, one at a time, like a spelling checker.
Follow these steps:
1. Click the Error Checking button on the
Formulas tab. The Error Checking dialog
box highlights the first cell with an error, as
shown in Figure 4-5.
Cells referenced in a formula are surrounded
by a colored box that matches the cell
address in the formula itself.
2. On the left side of the Error Checking dialog
box, the address of the cell with the error
is listed, along with its formula. Just below
that is a description of the error. Click one
of the buttons on the right side of the Error
Checking dialog box. The buttons change
a bit, depending on the type of error, but
here’s a list of the ones you’ll most likely see:
Help on this Error: Display the Help
page related to this particular formula
error so you can get additional help
with resolving it.
Ignore Error: Removes the flag from the
result cell and ignores the error in any
future searches unless you reset the
Trace Error: Displays arrows that point
to the cells referred to in the formula.
To learn more about tracing a formula,
see the section “Identifying Formula
Precedents and Dependents.”
Edit in Formula Bar: Moves the cursor
to the Formula bar so you can edit the
formula and correct it.