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.

Error Checking

Button

Formulas with Errors

Are Flagged

•

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

worksheet.

•

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.

Figure 4-4

Use its flag to correct a formula’s error.

4.
Fix the error.

Tip

5.
Repeat Steps 1–4 to fix other errors in the

worksheet.

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.