Microsoft Office Tutorials and References
In Depth Information
Watching the Watch Window
Watching the Watch Window
The Watch Window lets you watch the calculated results of a formula but
without the limitation of having the cell be in the viewing area of Excel. This
feature is helpful when you’re working on correcting formulas that use
precedents that are scattered about the worksheet or workbook.
First, to set up a watch, follow these steps:
1. Click the Watch Window button on the Formulas tab on the Ribbon.
2. In the Watch Window, click the Add Watch button.
The Add Watch dialog box opens.
3.UsetheRefEditcontrol(thesquarebuttontotherightoftheentry
box)tospecifythecell(s),ortypeinthecelladdressorrange.
4.ClicktheAddbuttonintheAddWatchdialogboxtocompletesetting
up the watch.
Figure 4-16 shows the Watch Window with a watch already in place. Cell C6
on the Costs worksheet is being watched. The formula uses precedents from
both the Orders and Shipping worksheets. The Watch Window sits on top of
the workbook and stays visible regardless of which worksheet is active.
This means, for example, that you could try different values on the Orders
worksheet and see the result in the calculation in Costs!C6, but without
having to bounce around the worksheets to see how new values alter the
calculated result.
Figure 4-16:
Using the
Watch
Window to
keep an eye
on a
formula’s result.
The Watch Window also lets you delete a watch. That’s a good thing;
otherwise you would end up with a bunch of watches you no longer need! To
delete a watch, perform these steps:
1. Select a watch from the list of watches in the Watch Window.
2. Click the Delete Watch window.
Search JabSto ::




Custom Search