Watch Window in Excel 2010

In this article I am going to explain about Watch window in Excel 2010.
  • 3258

Watch window in Excel 2010

In Excel Watch window use to contain few cell information from large number of data. Its contain document name, sheet name, cell name, cell value and contain formula.  Its update information according to change information.

To Define Watch window we have to follow following steps.

Step 1

Open work sheet and select cell for which we want to create Watch window.

SelectedCellExcel2010.jpg

Step 2

In Formula Tab click on Watch Window.

WatchWindowExcel2010.jpg

Step 3

Watch window dialog box will be appear where we click Add Watch. Then a Add watch window will be open.

WatchWindowDialogboxExcel2010.jpg

Step 4

In Add watch window we define cell number and click Add.

AddWatchExcel2010.jpg

Step 5

Again Watch window will be appear where we can see the cell detail.

WatchWindowResultExcel2010.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.