## Using the Watch Window

The Watch Window, shown below, is a new and exciting feature in Excel 2002 and higher versions. The Watch Window enables you to view cell location, formula, value or data in any cell in any open workbook, in either an active or inactive workbook, as well as the ability to move between cells added to the window. You can watch the result calculations, formulas, links and the name defined for the cell.

Figure 8-3: Watch Window

Chapter 8

^ To open the Watch Window:

♦ From the Tools menu, select Formula Auditing, and then Show Watch Window,

Press <Shift+F10>,

^ To add a cell to the Watch Window:

♦ With the Watch Window open, select the cell in the worksheet that you want to add and click Add Watch on the top left of the Watch Window.

^ To move between cells:

♦ Double-click any row in the Watch Window to select the cell.

^ To toggle between the toolbars:

♦ Double-click the caption bar of the Watch Window (where the text Watch Window isj. The Watch Window moves between the toolbars and the formula bar, as shown.

D:\FinanaciaI Statements - Financial Statements

File Edit Financial Statements View Insert Format Tools Data

 Verdana 10 T 1 Normal X 9 i a m Watch Window Add Watch... Ki Delete Watch Book Sheet ] Name Cell Value 1 Formula Financ al Statements.xls 41 Income Statement Netlncome C39 229,168 =C37-C38 Financ al Statements.xls 31 Balance Sheet TotalAssets C31 3,571 j 695 =C 16+C24+C29 Financ al Statements.xls 31 Balance Sheet TotalLiabilities C56 3,571 j 695 =C54+C49 Financ al Statements.xls 31 Balance Sheet RetainedEarnings C53 1,172,482 =SUMIF(TB DB Level3j A53, OFFSETfTB DB Le Financ al Statements.xls 41 Income Statement TotalRevenue C12 3,875,307 =SUM(C10:C11) 41 TotalCOG C19 1.815,127 =5UMiC15:C18) <1 December 31,2003 XYZ Corporation Inc. BALANCE SHEET December 31
0 0