Monitoring cells with a Watch Window

Some time you may want to monitor a value obtained from a formula in a cell.  As you work, you move around the worksheet and the cell value to be monitored disappear from view. To solve this issue/problem, a feature known as watch window comes to rescue. It makes the value always visible in a pop up window on top of worksheet.

To activate this watch window, select Formulas > Formula Auditing > Watch Window.  In order to add a cell to watch, click Add Watch and specify the cell that you want to watch. The Watch Window displays the value in that cell. You can add as many cells to the Watch Window, and you can also move the window anywhere in worksheet. Image below shows the Watch Window monitoring two cells.


No comments:

Post a Comment