Microsoft Office Tutorials and References
In Depth Information
Tip 47: Using the Background Error-Checking Features
Figure 47-2: Clicking an error-checking button gives you a list of options.
In many cases, you choose to ignore an error by choosing the Ignore Error option, which eliminates
the cell from subsequent error checks. You can select a range of formulas, and then choose Ignore
Error to ignore them all. All previously ignored errors can be reset so that they appear again. (Click
the Reset Ignored Errors button in the Excel Options dialog box.)
Even if you don’t use the automatic error-checking option, you can choose the Formulas➜Formula
Auditing➜Error Checking command to open a dialog box that displays each potential error cell in
sequence, much like using a spell-checking feature. Figure 47-3 shows the Error Checking dialog box.
Note that because it’s a modeless dialog box, you can still access your worksheet when the Error
Checking dialog box is open.
Figure 47-3: Using the Error Checking dialog box to cycle through potential errors identified by Excel.
Understand that the error-checking feature isn’t perfect. In fact, it’s not even close to
perfect. In other words, you can’t assume that you have an error-free worksheet simply
because Excel doesn’t identify any potential errors! Also, be aware that this error-check-
ing feature doesn’t catch a common type of error — overwriting a formula cell with a