Excel 2007 Watch Windows easily monitor data changes

In some of the more complex Excel2007 datasheets, we might want to be aware of the data changes in some of the cells in Excel 2007 at any time. For example, see changes in the total number of sales in different regions, or at the same time to see the distribution of different worksheets in the attendance, overtime, bonuses and other data. If it's a hassle to repeat the lookup every time, we use Excel2007 's "Watch Window" to easily monitor the data.

There are three worksheets in the Excel2007 file below, and we define a summation formula that contains three worksheet-specific cells in the B12 cell of Sheet1. Now we need to be able to see the changes in the rollup data when we modify any cell data in three worksheets.

Now click on the "Formulas" tab and click on the "Watch Window" button.

Now we see the Watch window.

Select the Sheet1 B12 cell that we need to monitor in real time, and click "Add Watch" in the Watch window.