Excel 2007 "Watch Window" application

For example, sometimes we need to view a number of table areas at the same time, in the form of payroll, we have to look at the attendance, penalties, overtime and other worksheets, such as accounting costs, according to the changes in the data to control the parameters. You can use the "Watch Window" of Excel 2007 if you find it very troublesome to repeat the lookup every time.

You use the Watch window in Excel 2007 by simply selecting the cell, switching to the Formulas tab, finding Formula auditing, and clicking the Watch window, which stays at the top level of the worksheet. Click the "Add Watch" option to add this cell to the Watch window. So no matter where you look at the workbook, the Watch window will appear on the screen. If you don't want to continue monitoring for a cell, just select the cell in the Watch window, and then click the Remove Watch button. Also, if you want to move quickly between multiple areas, you can use the Watch window to double-click the selected options added to the Watch window.