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

by one.

Error Cell

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.

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

worksheet.

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.