The Watch Window (new in Excel 2002 & Excel 2003) holds important information, such as Book name, Sheet name, defined Name, Value, and Formula. Specific cells can be added so that their information can be viewed at any time, even when located outside the viewing area.
To add cells to the Watch Window:
1. Select a cell, press Shift+F10 or right-click, and select Add Watch from the shortcut menu.
2. In Watch Window dialog box, click the Add Watch button, and then press F3 to paste a Name defined for a cell, or select a cell in any sheet in the active workbook or in any open workbook.
To view information about a cell added to the Watch Window:
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.