Microsoft Office Tutorials and References
In Depth Information
Telling Excel to Flag Result Cells with an Error
Once cells are flagged, you can use the flag to
help you fix them. Follow these steps:
2. Click the Error Checking button. A menu of
options to correct the error appears.
1. Click a flagged cell. An Error Checking button
appears to the left, as shown in Figure 4-4.
If you move the mouse pointer over this
button, a description of the type of error
appears in a ScreenTip.
3. Select an option from the menu. These options
vary, but here’s a brief description of some of
the common options:
Help on this Error: Displays the Help
page related to this particular formula
error, so you can get additional help
with resolving it.
Formulas with Errors
Trace Error: Displays arrows that point
to the cells referred to in the formula.
To learn more about tracing a formula,
see the section “Identifying Formula
Precedents and Dependents.”
Ignore Error: Removes the flag from the
result cell, and ignores the error in any
future searches unless you reset the
Edit in Formula Bar: Moves the cursor
to the Formula bar so you can edit the
formula and correct it.
Error Checking Options: Displays the
Excel Options dialog box so you can
change Excel’s error checking options.
Use its flag to correct a formula’s error.
4. Fix the error.
5. Repeat Steps 1–4 to fix other errors in the
To reset a worksheet so that previously
ignored errors are no longer ignored,
click the File tab to display Backstage
and select Options from the list on the
left. The Excel Options dialog box appears.
Click Formulas from the list on the left to
display the Formula options. In the Error
Checking section, click the Reset Ignored
Errors button and click OK.