Watch window in Excel

While working with a huge excel sheet with hundreds of rows and columns, there might be a need to ascertain the values of certain cells very often.

For example, if the sheet contains a lot of formula and varous cells are dependent on those formulae, to make sure the correct value in those cells, one has to scroll often.

Considering a large worksheet, scrolling and checking is a tedious task and there is also a possibility of human error, which might affect the whole calculation.

But with the help of watch window feature in excel, this task of checking is made simpler.

The�Watch Window�makes it convenient to inspect, audit, or confirm formula calculations and results in large worksheets.

By using the�Watch Window, the user need not repeatedly scroll or go to different parts of the worksheet.

The following example shows how to use the watch window.

1.Select the cells that you want to watch. To select all cells on a worksheet with formulas, on the Home tab, in the Editing group, click Find & Replace, click Go To Special, and then click Formulas.

2.On the Formulas tab, in the Formula Auditing group, click Watch Window.

excel watch window

3.Click "Watch Window".

The following window appears.

excel watch window

4.Click Add Watch

5.Now the watch window toolbar appears which can be docked to any position within the worksheet as required by the user.

Now whenever a calculation is done, the watch window shows the coresponding value of the selected cells in the toolbar itself, without any need to scroll the worksheet.

 

You can find similar Excel Questions and Answer hereunder

1) I have entered lot of comments in my WorkSheet - how do I have them show up when printed?

2) How to use the name manager in Excel to have a good overview of the various variables and their names in Excel

3) How can I delete all shapes in a WorkSheet?

4) String split in vba in Excel

5) Vba clear the contents of an entire sheet in Excel

6) Here the different chart types in Excel.

7) How can I display fractions as it is in a cell (instead of displaying as a decimal)?

8) I have to determine bonus for my staff based on ratings (for each rating, specific bonus amount). In Excel, how can I set up my Bonus Table?

9) How can I get the most frequently occurring text in a range?

10) I have a complex voluminous workbook with lot of formulas. Every time I make an update, the processing is slow. Any workarounds available?

 

Here the previous and next chapter