Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Watch Cell Information at a Distance




The Watch Window (new in Excel 2002 & Excel 2003) holds important information, such as Book name, Sheet name, defined Name, Value, and Formula. Specific cells can be added so that their information can be viewed at any time, even when located outside the viewing area.

To add cells to the Watch Window:

1. Select a cell, press Shift+F10 or right-click, and select Add Watch from the shortcut menu.
2. In Watch Window dialog box, click the Add Watch button, and then press F3 to paste a Name defined for a cell, or select a cell in any sheet in the active workbook or in any open workbook.

To view information about a cell added to the Watch Window:

1. Select a cell, press Shift+F10 or right-click, and select Add Watch from the shortcut menu.
2. Double-click the cell address in the Watch Window.
Screenshot // Watch Cell Information at a Distance

Watch Cell Information at a Distance
Rate this tip
12 34 5
  RATING: 4.33
  VIEWS: 12160
  No comments have been submitted.


REGISTERED USERS click here to post comments


GUESTSclick here to Register
Name
Comment Title
Comments


Terms and Conditions of use
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Copyright © 2003 ExcelTip.com
Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation