• Go Ask Debbie

Excel Watch Window

If you're like many Excel fanatics, you probably deal with large spreadsheets and multiple cells containing formulas.

Excel 2007 has a great new feature that lets you "watch" cell contents as they change. If numbers are added, subtracted, and changed, these specific cells are probably something you'd have to remember to review in previous versions of Excel.

To turn on the "Watch Window," follow these steps.

Highlight the cells you want to "Watch."

Click on the "Formula" tab and select the "Watch Window" button in the "Formula Auditing" group.

Click on the "Add Watch" button.

Since the cells were highlighted, simply click on the "OK" button and the cells will be added to the "Watch Window."

Now when you make changes to the spreadsheet, the "Watch Window" shows you the changes to the cells you added to the list.

If you accidentally close the "Watch Window," simply click on the "Formula" tab and then the "Watch Window" button to open it again.


Recent Posts

See All