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: