HomeApplicationOffice information

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

5 ★ | 1 Vote

You should read it

May be interested

  • How to lock formulas in ExcelHow to lock formulas in Excel
    when sharing an excel file, you don't want other people to edit the formulas, see the formulas, then lock the formulas again.
  • Guidelines for importing Chemistry formulas in ExcelGuidelines for importing Chemistry formulas in Excel
    entering chemistry formulas in excel spreadsheets helps us to handle formulas more easily, especially for those who often have to work with chemistry or with math when they have the above index, the index below.
  • How to open the CS 1.1 command windowHow to open the CS 1.1 command window
    opening the cs 1.1 command window will give the player the necessary commands when playing, and you should not use them to cheat with other gamers.
  • The square root formula in Excel - The square root function in ExcelThe square root formula in Excel - The square root function in Excel
    the square root formula in excel - the square root function in excel. excel is a spreadsheet to help you with tasks such as calculations or statistics. excel has many types of functions that make it easier to calculate, including the square root function sq
  • 5 ways to quickly open System windows in Windows 105 ways to quickly open System windows in Windows 10
    starting with the windows 10 october 2020 update, microsoft removed the system window from control panel. however, this information does not disappear forever. it is currently located in settings (about page). here are 5 ways to quickly open the system window on your pc.
  • How to delete quick recipe on ExcelHow to delete quick recipe on Excel
    in addition to locking excel formulas, we can delete formulas and retain results, or delete all cells with formulas and results.
  • 9 ways to open Disk Management in Windows 109 ways to open Disk Management in Windows 10
    the following article will show you 9 methods to open disk management on windows 10 computer to choose from. alternatively, you can learn how to create a shortcut to disk management.
  • How to create an Excel formula in Notepad ++How to create an Excel formula in Notepad ++
    when entering excel formulas in notepad ++, there will be additional features highlighting, highlighting, and suggestion. the following article will guide you how to set up an excel input formula in notepad ++.
  • How to enter formulas in ExcelHow to enter formulas in Excel
    how to enter formulas in excel. to enter a formula in excel, you must start with the equal sign or excel will interpret it as a string. to enter the formula do the following: step 1: type the equal sign at the position of the cell to calculate according to the formula. step 2: enter the clutch
  • How to Multiply in ExcelHow to Multiply in Excel
    this wikihow teaches you how to multiply numbers in excel. you can multiply two or more numbers within one excel cell, or you can multiply two or more excel cells against one another. open excel. it's a green app with a white 'x' on it.

Office information