Microsoft Office Tutorials and References
In Depth Information
Checking for Errors Automatically One at a Time
When you find an error in a formula, one
way in which you might need to correct it
is to change the cell(s) that the formula
references. For example, you might need
to change the formula =SUM(D2:D10) so
that it reads =SUM(D2:D12). When you
click a cell with a formula, and then click
in the Formula bar, the cells referenced
by the formula are outlined with colored
borders. You can drag these colored
borders and drop them on different cells, in
order to change the cells used in the
formula. You can also resize a colored
border to make the formula reference more
or fewer cells in that range.
After you click Ignore Error, that error is
ignored by Excel from now on, regardless
of the method you use to check the
worksheet. You can reset a worksheet so that
previously ignored errors are no longer
ignored, by clicking the File tab to display
Backstage, selecting Options from the list
on the left, selecting Formulas from the
list on the left, and clicking the Reset
Ignored Errors button. Click OK to close
the dialog box.
Show Calculation Steps: For complex
formulas, Excel offers this option, which
displays the Evaluate Formula dialog
box. See the section “Evaluating a
Formula” for help.
Using the Watch Window
If you are trying to find a problem with formulas
in a large worksheet, using the Watch Window
may help. With the Watch Window, you can watch
as values change in selected cells—whether or
not those cells are currently displayed onscreen.
So with the Watch Window, you’re not stuck
scrolling up and down in a large worksheet, or
jumping back and forth between sheets as you
check values and fix problems—the Watch
Window can display critical cells for you so you
can see how your edits affect them.
Options: The Options button appears on
the left in the Error Checking dialog box.
Click it to display the Excel Options
dialog box so you can change Excel’s
error checking options.
3. Fix the error with the formula.
4. Click Next to display the next error. Click
Previous at any time to display a previous
5. Repeat Steps 3 and 4 to find and repair all
errors in the worksheet.
Using the Watch Window
The Watch Window allows you to view cells
located in the current worksheet, other
sheets in the current workbook, or in a
different workbook that’s currently open.