• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Function Fundamentals > Using the Watch Window

Using the Watch Window

The Watch Window helps evaluate formulas within workbooks or worksheets. It's a formula-management tool that shows you the formula and where it is. If you share workbooks with others, the Watch Window can help identify formulas and errors within formulas. To access the Watch Window, right-click over the toolbar and select Watch Window from the drop-down list. The Watch Window docks at the top of the workbook as shown in Figure 6.21. Also, the watch window creates a split screen effect when dragged to any side of the Excel window.

The Watch Window is really a throwback to Excel's old Info window. In versions prior to Excel 97, the Info window (Tools, Options, View Tab, Info Window check box) was used to analyze a cell's information, which included its value, formula, range names used, protection, formatting, dependents and precedents, and the note (now called comments). The old Info window was more robust; it showed more info about the cell, but it could analyze only one cell at a time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint