Microsoft Office Tutorials and References
In Depth Information
Using the Excel Error-Checking Features
Using the Excel Error-Checking Features
If your worksheets use a lot of formulas, you might find it helpful to take advantage of the
automatic error-checking feature. You enable this feature on the Formulas tab of the Excel Options
dialog box (see Figure 195-1). To display this dialog box, choose File
Options.
You turn error checking on or off by using the Enable Background Error Checking check box. In
addition, you can specify which types of errors to check by selecting check boxes in the Error
Checking Rules section.
Figure 195-1: Excel can check your formulas for potential errors.
When error checking is turned on, Excel continually evaluates your worksheet, including its
formulas. If a potential error is identified, Excel places a small triangle in the upper left corner of the
cell. When the cell is activated, a Smart Tag appears. Clicking it provides you with some options.
Figure 195-2 shows the options that appear when you click the Smart Tag in a cell that contains a
#DIV/0! error. The options vary, depending on the type of error.
In many cases, you choose to ignore an error by choosing the Ignore Error option, which
eliminates the cell from subsequent error checks. However, all previously ignored errors can be reset
so that they appear again. (Click the Reset Ignored Errors button in the Excel Options dialog
box.)
 
Search JabSto ::




Custom Search