The steps in this article are going to show you where to find the button that opens the Watch Window in Microsoft Excel. We cover these steps briefly at the beginning of the article, then go more in depth below.
- Open Excel.
- Click the Formulas tab at the top of the window.
- Click the Watch Window button.
When you use a lot of formulas in a Microsoft Excel spreadsheet, it’s likely that some of those formula values will change as you edit the data in your spreadsheet. When there are only a couple of formulas or a small amount of data, this can be easy to monitor, but it becomes more difficult as you have more data.
One way that you can keep an eye on important data is with the Watch Window. This is something that you can keep open in Excel and add certain cells to it so that you can quickly view the values in those cells to ensure that they remain correct.
How to Show the Watch Window in Excel
The steps in this article were performed in the Microsoft Excel for Office 365 version of the application.
Step 1: Open Microsoft Excel.
Step 2: Choose the Formulas tab at the top of the window.
Step 3: Click the Watch Window button.
This will open a window that looks like the one shown below.
If you click a cell while this window is open, then click the Add Watch button, you will be able to add that cell to the Watch Window.
Would you like to be able to show a formula result in a text box? Find out how to accomplish this if you need to use a text box with a formula.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office and many other popular applications and devices.