- Select the cells that you want to watch.
To select all cells on a worksheet with formulas, on the Home tab, in the Editing group, click Find & Replace, click Go To Special, and then click Formulas.
- On the Formulas tab, in the Formula Auditing group, click Watch Window.
- Click Add Watch .
- Click Add.
- Move the Watch Window toolbar to the top, bottom, left, or right side of the window.
- To change the width of a column, drag the boundary on the right side of the column heading.
- To display the cell that an entry in Watch Window toolbar refers to, double-click the entry.
Note Cells that have external references (external reference: A reference to a cell or range on a sheet in another Excel workbook, or a reference to a defined name in another workbook.) to other workbooks are displayed in the Watch Window toolbar only when the other workbook is open.