Microsoft Office Tutorials and References
In Depth Information
Checking for Errors Automatically One at a Time
The Watch Window shows
you the current value and
formula in each cell on
the Watch list
Follow these steps to use the Watch Window:
1. Click the Watch Window button on the
Formulas tab. The Watch Window task pane
appears, as shown in Figure 4-6.
You can dock the Watch task pane along
any side of the workbook window, or
float it in the middle. To dock the Watch
task pane, drag it by its title bar toward
the side of the workbook window, until it
automatically expands and locks in place.
To float the Watch window again, drag
it by its title bar away from its docked
position until the Watch Window snaps
back into its smaller window shape, as
shown in Figure 4-6. Drop the task pane
wherever you like in the Excel window.
Watch as values change as you edit your
worksheet formulas and data.
6. To close the Watch Window, click the Watch
Window button on the Formulas tab again,
or click its Close button.
2. Click the Add Watch button, located at the
top of the task pane. The Add Watch dialog
box appears (see Figure 4-6).
3. In the Add Watch box, type the address of the
cell or range you want to watch, or simply
select the cell/range in the worksheet.
Removing Cells from
the Watch List
The cells you are watching remain listed in
the Watch list, even after you close the Watch
Window. So if you click the Watch Window
button at a later time, you can reexamine the
values in those same cells. To remove a cell
from the Watch list, select it in the listing
and click the Delete Watch button, located
at the top of the Watch Window.
4. Click Add. The cell or range of cells you
selected is added to the Watch list. Notice in
the Watch Window, that the address of the
selected cell(s) is listed, along with their
corresponding values. If the cell(s) contains
a formula, it is listed as well.
5. Make changes to the worksheet. If your
changes affected any of the watched cells,
those new values appear in the Watch