Using the Excel 2002 Watch Window

Get the WebProNews Newsletter:

[ Business]

Excel’s new Watch Window feature lets you track cell properties including workbook, worksheet, name, cell, value, and formula, even when the cells are out of view.

Activating the Watch Window

1. Select the cell(s) you want to watch.

2. Choose Formula Auditing from the Tools menu.

3. Choose Show Watch Window from the Formula Auditing submenu. The Watch Window opens.

4. Click Add Watch. The Add Watch dialog box opens.

5. Confirm the location of the formula to be watched, and then click the Add button.

– The Watch Window can be moved anywhere on screen by dragging the title bar.

– Change the width of a column by dragging its boundary (to the right of the column heading).

– Double click an entry in the Watch Window to select that cell.

– Cells that contain links to other workbooks are displayed in the Watch Window only if the other workbook is open.

Beth Sunny and Karin Rex share their extensive knowledge in IT and training as freelance writers for http://www.SharperTraining.com. Don’t miss their training tips along with insights from other experienced trainers in SharperTraining.com’s “Focus On Training” newsletter. To subscribe, visit http://lb.bcentral.com/ex/manage/subscriberprefs.aspx?customerid=1468

Using the Excel 2002 Watch Window
Comments Off on Using the Excel 2002 Watch Window
Top Rated White Papers and Resources

Comments are closed.

  • Join for Access to Our Exclusive Web Tools
  • Sidebar Top
  • Sidebar Middle
  • Sign Up For The Free Newsletter
  • Sidebar Bottom