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-
Search JabSto ::




Custom Search