Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

When cells are not visible on a worksheet, you can watch those cells and their formulas in the Watch Window toolbar. 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 or docked 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 only have one watch per cell.

Add cells to the Watch Window

Important: On a Mac, perform step 2 of this procedure before you perform step 1; that is, click Watch Window and then select the cells to watch.

  1. 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.

  2. On the Formulas tab, in the Formula Auditing group, click Watch Window.

    Select Watch Window

  3. Click Add Watch Button image.

  4. Click Add.

    Watch Window toolbar

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

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

  7. 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 workbook is open.

Top of Page

Remove cells from the Watch Window

  1. If the Watch Windowtoolbar is not displayed, on the Formulas tab, in the Formula Auditing group, click Watch Window.

  2. Select the cells that you want to remove.

    Delete Watch

    To select multiple cells, press Ctrl and then click the cells.

  3. Click Delete Watch Button image.

Top of Page

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!