Page 372 - Excel 2013 All-in-One For Dummies

354 Formula Auditing
Figure 2-8:
Flagging an error value in a worksheet in the Error Checking dialog box.
When you click the drop-down button, a menu appears, containing an item with the name of the error value followed by the following items:
✦ Help on This Error: Opens an Excel Help window with information on the type of error value in the active cell and how to correct it.
✦ Show Calculation Steps: Opens the Evaluate Formula dialog box where you can walk through each step in the calculation to see the result of each computation.
✦ Ignore Error: Bypasses error checking for this cell and removes the error alert and Error options button from it.
✦ Edit in Formula Bar: Activates Edit mode and puts the insertion point at the end of the formula on the Formula bar.
✦ Error Checking Options: Opens the Formulas tab of the Excel Options dialog box where you can modify the options used in checking the work- sheet for formula errors. (See “Changing the Error Checking options” section that immediately follows for details.)
If you’re dealing with a worksheet that contains many error values, you can use the Error Checking command button (the one with the check mark on top of a red alert exclamation mark) in the Formula Auditing group on the Ribbon’s Formulas tab to locate each error.
When you click the Error Checking command button, Excel selects the cell with the first error value and opens the Error Checking dialog box (see Figure 2-8) that identifies the nature of the error value in the current cell.
The command buttons in the Error Checking dialog box directly correspond to the menu options that appear when you click the cell’s alert options button (except that Error Checking Options on this drop-down menu is simply called the Options button in this dialog box).