"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.
  • Excel 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: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.