Microsoft Office Tutorials and References
In Depth Information
Tip You can have the Error Checking tool ignore formulas that don’t use every cell in a region
(such as a row or column). If you clear the Formulas That Omit Cells In A Region check box,
you can create formulas that don’t add up every value in a row or column (or rectangle)
without Excel marking them as an error.
For times when you just want to display the results of each step of a formula and don’t need
the full power of the Error Checking tool, you can use the Evaluate Formula dialog box to
move through each element of the formula. To display the Evaluate Formula dialog box,
you display the Formulas tab and then, in the Formula Auditing group, click the Evaluate
Formula button. The Evaluate Formula dialog box is much more useful for examining
formulas that don’t produce an error but aren’t generating the result you expect.
Finally, you can monitor the value in a cell regardless of where in your workbook you are
by opening a Watch Window that displays the value in the cell. For example, if one of
your formulas uses values from cells in other worksheets or even other workbooks, you
can set a watch on the cell that contains the formula and then change the values in the
other cells. To set a watch, click the cell you want to monitor, and then on the Formulas
tab, in the Formula Auditing group, click Watch Window. Click Add Watch to have Excel
monitor the selected cell.
As soon as you type in the new value, the Watch Window displays the new result of the
formula. When you’re done watching the formula, select the watch, click Delete Watch,
and close the Watch Window.