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.