How to easily navigate large worksheets with the Watch Window

When cells are not visible on a worksheet, you can watch those cells and their formulas in the Watch Window. The Watch Window makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets. By using the Watch Window, you don’t need to repeatedly scroll or go to different parts of your worksheet.

This toolbar can be moved like any other toolbar. For example, you can dock it on the bottom of the window. The toolbar keeps track of the following properties of a cell: workbook, sheet, name, cell, value, and formula.
Note: You can have only one watch window per cell.

Applies To: MS Excel 2007, 2010 and 2013

1. Select the cells that you want to watch.
• To select all cells on a worksheet with formulas Press F5
• Select Special








  • Then select Formulas and OK as shown below.










2. To add the Watch Window, select the Formulas tab and then Watch Window as shown below.





3. Click Add.

4. Move the Watch Window toolbar to the top, bottom, left, or right side of the window.

5. To change the width of a column, drag the boundary on the right side of the column heading.

6. To display the cell that an entry in Watch Window toolbar refers to, double-click the entry.

Note: Cells that have external references to other workbooks are displayed in the Watch Window toolbar only when the other workbooks are open.