Microsoft Office Tutorials and References
In Depth Information
2. ChooseFormulas ➝ FormulaAuditing ➝ ErrorChecking.
If Excel doesn’t find any errors in your worksheet, it displays a message
indicating that its work’s complete. Otherwise, you see the Error Checking dialog box,
as shown in Figure 18-7, which indicates the offending cell and formula. This
box also provides a number of options.
Excel’s error checker helps you scan through
a worksheet and quickly jump to the cells that
contain errors. You can click the Trace Error
button to quickly jump to the Evaluate Formula
dialog box and start analyzing the problem.
The Error Checking dialog box contains the following options:
• Next and Previous . Use these buttons to move from one error to the next.
• Help on this Error . Click this button to jump to Excel’s online help, which
lists common causes of specific errors. It may give you some insight into your
• Trace Error . Use this button to open the Evaluate Formula dialog box, where
you can move one step at a time through the evaluation of the formula.
• Ignore Error . Click this button to skip the error, and ignore the cell from this
point onward. If you want the error checker to pay attention to a cell you’ve
previously decided to ignore, click the Options button, and then click Reset
• Edit in Formula Bar . Use this button to start editing the formula. This choice
doesn’t close the error checker—instead, you can click Resume to get back to
checking other errors once you’ve made your change.
• Options . Click this button to open the Excel Options dialog box, with the
Formulas section selected. The Formulas section includes a small set of error-checking
options under the headings “Error checking” and “Error checking rules”.
Ordinarily, you don’t need to change any of these error checking options, as the
factory settings are stringent enough to ensure that Excel catches all problems.