Microsoft Office Tutorials and References
In Depth Information
Figure 22-11: Excel can check your formulas for potential errors.
When error checking is turned on, Excel continually evaluates your worksheet, including its formulas. If a po-
tential error is identified, Excel places a small triangle in the upper-left corner of the cell. When the cell is activ-
ated, an icon appears. Clicking this icon provides you with options. Figure 22-12 shows the options that appear
when you click the icon in a cell that contains a #DIV/0! error. The options vary, depending on the type of error.
In many cases, you will choose to ignore an error by selecting the Ignore Error option. Selecting this option
eliminates the cell from subsequent error checks. However, all previously ignored errors can be reset so that
they appear again. (Use the Reset Ignored Errors button in the Formulas tab of the Excel Options dialog box.)
You can choose Formulas ⇒ Formula Auditing ⇒ Error Checking to display a dialog box that describes each po-
tential error cell in sequence, much like using a spell-checking command. This command is available even if
you disable background error checking. Figure 22-13 shows the Error Checking dialog box. Note that this dia-
log box is modeless, so you can still access your worksheet when the Error Checking dialog box is displayed.