How to The Watch Window in Excel
The Watch Window allows you to keep an eye on the value in a cell that's out of view, either in the same sheet, another sheet in the same workbook, or an entirely different workbook.
The Watch Window appears. Here you can add cells you want to track.
If you started with a cell selected, the cell reference in the Add Watch dialog box will already be populated.
Now that it's added, you see which cell you're watching, the current value, and the formula that's used in that cell.
The cell value in the Watch Window updates instantaneously if a dependent cell has been modified.
If you no longer want to track a certain cell, select it in the Watch Window and click the Delete Watch button.
When you’re done working with the Watch Window, close it to once again view your worksheet in full screen.
Free to distribute with our compliments; we hope you will consider our paid training.