The Watch Window in Microsoft Excel is a feature that allows you to monitor the values of cells while you work in a different part of the workbook. The Watch Window is particularly useful when you are working with large, complex spreadsheets, and you need to keep an eye on the values of specific cells. With the Watch Window, you can track the values of cells without having to scroll back and forth between different parts of the worksheet.
Here is how to use Watch Window in Excel.
Adding a Watch Window
Select the cells you want to watch. On the Formula tab, in the Formula Auditing group, click on Watch Window.
Click Add Watch.
Click Add.
Note: You can move the Watch Window toolbar to the top, bottom, right or left side.
To display the cell that an entry in Watch Window toolbar refer to, double click the entry.
Removing cells from the Watch Window
Select cell that you like to remove. To select multiple cell, press CTRL and then click the cells.
Click Delete Watch.
Monitor cell values
As you work in different parts of the worksheet, the values of the cells in the Watch Window will be updated in real-time. You can see the current value of each cell, and you can also see the formulas and values of any cells that are used to calculate the value of the cells in the Watch Window.
Keep the Watch Window visible
If you want to keep the Watch Window visible while you work in other parts of the worksheet, simply click and drag the Watch Window to a location on your screen where it will not be obscured by other windows.
Close the Watch Window
To close the Watch Window, simply click the "X" in the upper-right corner of the window.
In conclusion, the Watch Window in Excel is a powerful tool that can help you work more efficiently by allowing you to monitor the values of specific cells while you work in a different part of the worksheet. With the Watch Window, you can keep an eye on critical values, track the results of complex calculations, and make sure that your worksheet is functioning as expected.
Further reading: Formula auditing How to count cells with a specific content in a range? Dynamic chart title from the cell