Choosing an Error Action

When you select the cell, Excel displays a Smart Tag beside it. If you hover your mouse pointer over the icon, a pop-up message describes the error, as shown in Figure 5.4. The Smart Tag doubles as a drop-down list with the following actions:

• Help on this Error— Choose this option to get information on the error via the Excel Help system.

• Show Calculation Steps— Choose this option to run the Evaluate Formula feature. See “Evaluating Formulas,” later in this chapter.

• Ignore Error— Choose this option to leave the formula as is.

• Edit in Formula Bar— Choose this option to display the formula in Edit mode in the formula bar. This enables you to fix the problem by editing the formula.

• Error-Checking Options— Choose this option to display the Error Checking tab of the Options dialog box (discussed next).

• Show Formula Auditing Toolbar— Choose this option to display the Formula Auditing toolbar. See “Auditing a Worksheet,” later in this chapter.