HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Use the Watch Window to Monitor Cells

Excel 2007: Use the Watch Window to Monitor Cells

Monitoring the values of certain cells can be a real headache if you are dealing with a large spreadsheet. Fortunately, Excel has a feature that makes things much easier. The Watch Window can display the value of any cell or cells in a window that can be moved to any location on your screen. To use the Watch Window…


1. Go to the Ribbon and select the Formulas tab.

2. In the Formula Auditing section, select Watch Window.

3. The Watch Window will appear.

4. Click the Add Watch button to specify the cell you wish to monitor.

You can now monitor the value of the selected cell while continuing to work on any portion of the spreadsheet. You can also double-click on the cell in the Watch Window to quickly go to that cell.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android