How to open the formula management window in Excel

This is the Watch Window tool in Excel, which has the ability to manage Excel formulas in 1 window, along with the displayed results for us to know immediately. Thus users will be more flexible in managing Excel data tables. The following article will guide you to use the Excel formula tracking window.

Instructions for using the formula window in Excel

Step 1:

First highlight the entire data table. At the interface in Excel we click on the Formulas item in the Ribbon and then look down at the group below, click on Watch Window .

How to open the formula management window in Excel Picture 1

Step 2:

Display the window interface, we click the Add Watch button .

How to open the formula management window in Excel Picture 2

Immediately then display the data area that we highlighted earlier, click the Add button to agree.

How to open the formula management window in Excel Picture 3

Step 3:

As a result, we will see all the data in the table put into the monitoring window as shown below. Each data is divided into different columns, depending on what type of data it is. Here you can view the formula through the Formula cell and the result of the formula right next to it.

How to open the formula management window in Excel Picture 4

The interface of this window will continuously display on the data sheet. You can attach this management window to the formula bar by double-clicking the gray area in the management window.

To return to the minimized interface, move the window out of the formula bar.

How to open the formula management window in Excel Picture 5

Step 4:

In this interface you can also delete data by clicking on it and pressing Delete Watch. To turn off the window interface, click Watch Window again or always click on the X icon and you're done.

How to open the formula management window in Excel Picture 6

Kareem Winters

Update 26 May 2021