How to Open the Formula Management Window in Excel

This practical guide walks through how to open the formula management window in Excel, explains the main requirements, and highlights common issues that may appear along the way.

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 .

Step 2:

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

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

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.

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.

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.