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

In addition, the Error Checking dialog box contains Next and Previous but- tons that you can click to have Excel select the cell with the next error value or return to the cell with the previously displayed error value.
Note that when you click the Next or Previous button when Excel has flagged the very first or last error value in the worksheet, the program displays an alert dialog box letting you know that the error check for the worksheet is complete. When you click the OK button, Excel closes both the alert dialog box and the Error Checking dialog box. Also note that clicking the Ignore Error button is the equivalent of clicking the Next button.
Changing the Error Checking options
When you choose Error Checking Options from the alert options drop-down menu attached to a cell with an error value or click the Options button in the Error Checking dialog box, Excel opens the Formulas tab of the Excel Options dialog box. This tab displays the Error Checking and Error Checking Rules options that are currently in effect in Excel. You can use these options on this Formulas tab to control when the worksheet is checked for errors and what cells are flagged:
✦ Enable Background Error Checking check box: Has Excel check your worksheets for errors when the computer is idle. When this check box
is selected, you can change the color of the error indicator that appears as a tiny triangle in the upper-left corner of the cell (normally this indica- tor is green) by clicking a new color on the Indicate Errors Using This Color’s drop-down palette.
✦ Reset Ignored Errors button: Restores the error indicator and alert options button to all cells that you previously told Excel to ignore by choosing the Ignore Error item from the alert options drop-down menu attached to the cell.
✦ Indicate Errors Using This Color drop-down button: Enables you to select a particular color for cells containing error values from the drop- down palette that appears when you click this button.
✦ Cells Containing Formulas That Result in an Error check box: Has Excel insert the error indicator and adds the alert options button to all cells that return error values.
✦ InconsistentCalculatedColumnFormulainTablescheckbox:HasExcel flag formulas in particular columns of cell ranges formatted as tables that vary in their computations from the other formulas in the column.
✦ Cells Containing Years Represented as 2 Digits check box: Has Excel flag all dates entered as text with just the last two digits of the year as errors by adding an error indicator and alert options button to their cells.
Formula Auditing 355
Book III Chapter 2
Logical Functions and Error Trapping