Blogs

2014/09/29

When working large worksheet or a collection of related worksheets) the data may frequently change. The Watch Window allows you to save time by monitoring the results of selected cells in a separate window.

1. [Navigate] to the Formulas tab. 
2. [Click] Watch Window.
3. In the Watch Window display, [click] Add Watch.
4. In the Add Watch dialog box, indicate the cells that you want to watch. You can either type the cell references directly into the dialog box, or you can select the cells with your mouse.
   
   Note: you can select more than one contiguous cell. You can even select cells on another worksheet.
   
   
5. [Click] Add.
6. The Watch Window has started monitoring the selected cells. It indicates the workbook and worksheet where the cell(s) reside, the name of the cell (if you named it), the cell you are monitoring, the current value, and the formula you used to create that value.
   
   Note: the size the window can be adjusted and can be moved to more convenient location on your screen if needed.
   
   To delete a watch, highlight the item in the Watch Window you no longer need and select Delete Watch

Submitted by Kisha Minor