If you use Excel regularly, you may have worked on some very large worksheets that span hundreds or even thousands of rows. It could be useful if some of the cells you need to monitor often could be displayed in a separate window so that you could see the current value and formula at a glance. Microsoft created the Excel Watch Window for that exact purpose. ..
Using the Excel Watch Window
You can use the Watch Window to pull out important cells into a separate window and keep track of them there, which saves you from having to scroll all over your worksheet.
The example below is a small subset of a much larger data set. The goal is to monitor cells that change often. In the example below, we are looking at a small subset of a much larger data set in order to monitor cells that change often. ..
When you click on the Watch Window button, Excel displays a dialog box that allows you to specify the range of cells that you want to monitor for changes. ..
This will open the Watch Window dialog box. The box, of course, is empty since we haven’t added any cells yet to monitor.
Now, enter the time you want the watch to start at in the Time box and click on the OK button. The watch window should now look like this: To stop the watch, click on the Stop Watch link located at the top of the dialog box. ..
To monitor cells by reference, in the Add Watch dialogue box, type the cell reference. To monitor cells with your mouse, select the cells you want to monitor with your mouse and then click OK. ..
To add cells to the Watch Window, click and drag your mouse to select a series of cells. When you are done, click on the Add button.
Secondly, the Watch Window will now show the current time in your local time zone. If you’re in a different time zone, the Watch Window will still show your local time, but it will be in a different UTC offset.
The Watch Window also provides other important information about cells, such as the workbook and worksheet in which the cells reside and the name of the cell, if you gave it one. ..
If you prefer, you can drag the Watch Window to one of the sides of Excel so that it doesn’t take up valuable space on the worksheet floating around.
You can add cells from other worksheets within the same Excel workbook, but you can’t add cells from another workbook. Each workbook has its own separate Watch Window. If you work with large spreadsheets, Watch Window is a real time saver and is likely to increase your productivity by allowing you to spend more time on your work and less time clicking around in Excel. If you have any questions, feel free to comment. Enjoy!
In this article, I will show you how to use Excel to track data and make changes. Additionally, I will show you how to open multiple Excel instances and how to track changes in data. Finally, I will give you an example of how to subtract dates in Excel.
