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>,

Right-click a cell, and select Add Watch from the shortcut menu.

^ 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

Post a comment