Microsoft Office Tutorials and References
In Depth Information
Add a Watch Window
Working with Formulas and Functions
The Add Watch dialog box
4 Select the cell or range that
you want to watch.
5 Click Add .
Note: You can add multiple cells
to the watch window.
A Excel adds the cells to the watch
window, including any values or
formulas within the cells.
B If you scroll away from the cells
included in the watch window, the
watch window continues to display
their contents. You can make
changes and the watch window
displays the updated value. In this
example, Rows 4 and 7 changed,
and so did the value in the watch
Note: To select the original cell, you
can double-click anywhere on the line
in the watch window.
6 Click the Close button (
close the watch window.
How do I remove and add cells in the watch window?
To remove a cell from the watch window, click anywhere
on the line for the cell in the watch window and then
click the Delete Watch button. To add more cells, click
the Add Watch button and select the cell that you
want to add.
How can I move and resize the watch window?
To move the watch window, click and drag the
window’s title bar. To resize the columns within
the watch window, position the mouse pointer
over a column (
), and drag to
resize the column.