Office Expert

Watch Window

You can use watch window to keep track of data in a particular cell or range of cell even when the cells are no longer in view .This is especially useful when you want to keep your eye on a specific formula or cell you use to create a formula .You can also use a watch window to keep track of particular cell's data as you work with the rest of your work sheet.


Example :-


You are running a stationary shop and  entering the stock which you are planning for the next month .After entering each item you want to know the total amount of entire stock  .Here you can use watch window on the cell where we are calculating the sum of all stock.

Here you want to keep an eye on Total stock amount [E15 cell]after each item entry  .
[E15 cell is the sum of all stock amount]


Steps


Click Formula Tab  then Click On Watch Window

Click on the particular cell we want to watch ,here it is E15 

Select the cell or Cells you want to watch .You can also type the cell reference.


Click Add 


Then a new window will come which will show you the value of that particular cell along with the formula applied in that cell.

If we enter a new item or change the value of any item we can always see the total of all stocks in "Watch Window"


Note : You can add multiple cells to the watch window