Microsoft Office Tutorials and References
In Depth Information
Tip 47: Using the Background Error-Checking Features
Using the Background Error-Checking
If your worksheets use a lot of formulas, you may 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 47-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 47-1: Excel can check your formulas for potential errors.
When error checking is turned on, Excel continually checks your formulas. If a potential error is
identified, Excel places an error indicator (a small triangle) in the upper-left corner of the cell. When the cell
is activated, an error-checking button appears. Clicking this buttons provides you with a list of
options. Figure 47-2 shows the options that appear when you click the error-checking button for a
cell that contains a #DIV/0! error. The options vary, depending on the type of error.
Search JabSto ::

Custom Search