Microsoft Office Tutorials and References

In Depth Information

**Evaluate a Formula in Slow Motion**

Figure 9.30.

Figure 9.30.
Adding a watch to the Watch Window screen.

Adding a watch to the Watch Window screen.

Tip

To jump to a watched cell quickly, you can double-click the cell in

the Watch Window screen. You can resize the watch window and resize

the columns as necessary.

In theory, this feature can be used to watch a value in a far-off section of

the worksheet.

Evaluate a Formula in Slow Motion

Evaluate a Formula in Slow Motion

Most of the time, Excel calculates formulas in an instant. It can help your

understanding of the formula to watch it being calculated in slow motion.

If you need to see exactly how a formula is being calculated, follow these

steps:

11. Select the cell that contains the formula in which you are interested.

22. On the Formulas tab, in the Formula Auditing group, select Evaluate

Formula. The Evaluate Formula dialog appears, showing the for-