How to Open the Watch Window in Excel

To open the Watch Window in Excel for Microsoft 365, go to the Formulas tab and click Watch Window in the Formula Auditing group. Then click Add Watch, select the cells you want to keep an eye on, and click Add. The window shows each cell’s workbook, sheet, value and formula, and updates as you work anywhere in the workbook.

Quick Answer

Formulas > Watch Window > Add Watch > select cells > Add.

Steps to Use the Watch Window

1. Open the workbook and click the Formulas tab.
2. Click Watch Window in the Formula Auditing group.
3. Click Add Watch.
4. Select one or more cells, then click Add.
5. Move to another sheet and keep working. The watched values update as inputs change.

Tips

• Dock it: Drag the window to the top, bottom or side of Excel to dock it.
• Jump to a cell: Double-click an entry to go straight to that cell.
• Remove a watch: Select it and click Delete Watch.
• Sort: Click a column heading, such as Value, to sort the list.

What the Columns Show

Column	Meaning
Book	Workbook name
Sheet	Worksheet name
Name	Defined name, if the cell has one
Cell	Cell address
Value	Current result
Formula	The formula in the cell

Troubleshooting

• Watch Window button missing: Excel for the web doesn’t have the full Watch Window in all versions. Use the desktop app.
• Watches disappear: Cells in closed workbooks are removed from the list when the workbook closes.
• Need help writing formulas? See using Copilot to create a formula or counting a word in Excel.

Frequently Asked Questions

Is there a keyboard shortcut?

Press Alt, M, W in sequence to open it from the ribbon.

Does it work in older Excel versions?

Yes. It’s in the same place in Excel 2010 and later.

Can I watch cells in another workbook?

Yes, while that workbook is open.

Summary

1. Open Formulas > Watch Window.
2. Click Add Watch and pick cells.
3. Dock or move the window.
4. Double-click an entry to jump to it.