HomeMicrosoft OfficeExcelWatch Window in Microsoft Excel 2016

Watch Window in Microsoft Excel 2016

You would have come across Watch Window in Visual Studio IDE , similarly Microsoft Excel 2016 too provides the Watch Window that lets the users to monitor the value of a cell when you are working on the excel sheet.

What is the use of Watch window in Microsoft Excel 2016 ?

The watch window shows the value of the cell in it. It is a kind of task pane which you can dock it. This is useful especially when you are working a large sheet where you need to view a particular cell value without scrolling through the worksheet.

How to add the cell to the Watch Window in Microsoft Excel 2016?

To add the cell to the watch window , follow the below steps.

1. Open the Excel worksheet and navigate to Formulas -> Formula Auditing and click the Watch window.

image

2. Click the Add watch button in the Watch Window dialog and then specify the cell which you want to monitor. Now , the Watch window will start displaying the value of the cell in it.

image

    1 Comment

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021