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.