Microsoft Excel logo

Tired of scrolling to see formulas and results in cells that aren’t in view? With the Watch Window in Microsoft Excel, you can keep an eye on your formulas without constant spreadsheet scrolling.

Available for all desktop versions of Excel, the Watch Window is a handy tool for seeing your formulas with their locations and results. You can view cells in your current workbook or another that you have open, which gives you the flexibility you need to stay on top of things.

Add Cells to Your Watch Window

You can easily add cells to the Watch Window in your current spreadsheet, and you can select the particular cells containing formulas if you want to watch or view all the formulas in the sheet.

Watch Certain Cells with Formulas

To add specific cells, first, select them, and then open the Formulas tab. Now, click “Watch Window” in the Formula Auditing section of the ribbon.

Go to the Formulas tab and click Watch Window

Click “Add Watch” in the Watch Window toolbar.

Click Add Watch

Confirm the cells that you’ve selected in the Add Watch pop-up window and hit “Add.”

Confirm the cells and click Add

Watch All Cells with Formulas

If you prefer to add all cells containing formulas in your sheet, this is just as simple. With your sheet active, go to the Home tab.

Click the “Find & Select” drop-down box in the Editing section of the ribbon and select “Formulas.”

Go to the Home tab, click Find & Select, choose Formulas

This selects all cells containing formulas in your spreadsheet. From there, follow the same steps as those listed above to open the Watch Window and add those cells.

Use the Watch Window

After you add cells to the Watch Window, you can see the workbook name, sheet name, cell name, cell reference, value, and formula for each one.

Cells in the Watch Window

This is when the Watch Window becomes so valuable in large spreadsheets. If you need to see the result of a formula (value), you don’t have to scroll through your current sheet, move to a different one, or even pull another workbook into view. Just look at the Watch Window.

RELATED: How to Change the Cell Reference Style in Excel

Any cells that you add to the Watch Window will remain there until you remove them (as seen below). The exception is when you’re using multiple workbooks. For example, if you’re using Workbook A and have cells from Workbook B in the Watch Window, you must keep Workbook B open. If you close it, those cells will disappear from the Watch Window.

Move the Watch Window

The Watch Window can be moved or parked wherever you like in your Microsoft Excel workbook. Simply drag to move it or double-click its gray area to dock it above the formula bar.

Docked Watch Window in Excel

You can also close the Watch Window using the “X” in the upper-right corner or the button in the ribbon. When you reopen it, those same cells that you added will be there ready and waiting.

Remove Cells from Your Watch Window

To remove a cell from the Watch Window, select it in the window and click “Delete Watch.” You can use your Control key (Command on Mac) to select multiple cells in the window and then hit “Delete Watch.”

Click Delete Watch

Being able to see cells with formulas that aren’t in your immediate view is a great feature. So remember the Watch Window feature the next time you’re working with a lengthy Microsoft Excel spreadsheet.

Sandy Writtenhouse Sandy Writtenhouse
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage.
Read Full Bio »

The above article may contain affiliate links, which help support How-To Geek.