"Discover the Excel 2007 Watch Window Feature and How to Add Cell to It!"

Maybe you did not realise that Excel 2007 come with this useful feature called Watch Window!

If you are working on a large spreadsheet, it seems to be simple scrolling up and down to check on the values of certain cells as they change. But if you keep doing it over and over again, finding the cell value here and there...how do you feel?

Luckily Excel 2007 come with a feature called Watch Window. With this, you can monitor different cells in a small window that is always visible or even not on the screen or in a different workbook. This way you can immediately see the values as they change.

To add a cell to the Watch Window

• Select the cells you want to watch.
• On the Formulas tab, in the Formula Auditing group, click Watch Window.

• Click Add Watch icon to specify the cell you wish to monitor.
• From the Add Watch dialog box displayed, click the Add button.

You will see the window appear (monitor the value of the selected cell) and it will remain on top as you work on any portion of the spreadsheet.

You can reposition the window by dragging and dropping the window to its new location. You can also double-click on the cell in the Watch Window to quickly go to that cell.

Related Topics:

Customizing and Adding Commands to the Quick Access Toolbar in Excel 2007

How to Install and Uninstall Add-ins in Excel 2007?

Guide to Highlight and Remove Duplicates Values in Excel 2007

How to View Multiple Worksheets at the Same Time in Excel 2007?

How To Protect Excel Worksheet or Workbook with the Password?

How to Create Excel 2007 Drop Down List? - The Simple Way

How to Create the Excel 2007 Data Validation Rules?

Can't find what you're looking for? Try Google Search!

Custom Search

Back to Top

You're viewing the Excel watch window info page, click here to go back to the Home Page

Add To Your Social Bookmarks: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb