This is where the Watch Window shines! This powerful tool is often overlooked by even the most experienced Excel users. The Watch Window can display the value of any cell or cells in a viewing pane that can be relocated (as with any toolbar) on your screen. This handy toolbar keeps track of the following assets of any cell you wish to keep tabs on:
Here is how you set it up:
- Select the Formulas tab on the ribbon
- Select Watch Window from the Formula Auditing section
- The Watch Window will appear
- Click the Add Watch button to specify the cell(s) you wish to monitor
Simple as that! What a great way to watch the critical areas of your data!
As Bob Dylan wrote, “All along the Watchtower, Princes kept the view…”