Next Live Training Date:

DBN 19-21 Sep, CT 12-14 Oct

Not sure which Excel course you should do? Try out our free Which Excel Course Should you do" questionnaire. 20 questions and you will know exactly what course you should do!

Excel Watch Window

Excel Watch Window
Watch this video

How to use the Excel watch window to see what is happening in key cells as you make changes to your spreadsheet.

  • 2:54
  • Skill Level:
  • What's my skill level
    Flying screens

    All of our videos are listed by user Excel Skill Level.

    To find out your personal skill level, download our quick assessment.

    Once you've completed the test, send it to us and we'll evaluate for you.

    Download Test

  • Watch this Video

Excel Watch Window for viewing cells

In this example we have a spreadsheet that has been built over two sheets. One sheet containing the inputs, and another sheet containing some calculations and the results. And on this sheet we have two cells which are very important to us, being this cell the IRR cell and this cell which is the Net Present Value cell.

We’d like to see what happens to these cells when changes are made to the input cells, but its always a bit tedious to jump between the sheet. So what you can use is the Excel WATCH WINDOW

So for example it tells you

Now when we go back to the input sheet you’ll see

If you want to add more cells to the WATCH WINDOW it’s simply a case of

If you want a name to appear here that describes the cell you’re looking at, it’s simply a case of naming the cells. So for example

It makes it a lot easier to understand what values we are looking at

Free Tips & Tricks Newsletter

Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!

Handy Tips & Tricks

The risks of Excel’s auto format feature

Everyone loves that way Excel can second guess what you mean when you type something into a cell and it (correctly) changes the format. Type 2 Sept and it will automatically format it as a date. But there are some … Continue reading

Slicer greyed out in Excel

If you have started using the slicer feature you may find that you get annoyed when the slicer is grayed out in Excel. This can happen when you receive a file from someone else, or if you download data from a source … Continue reading

....As an example, the training in VLOOKUP had applicability in differing ways for each employee and they learned then and there how to use it in their own work. They left the training with clear expectations on improvement in their areas of responsibility...

– Benefits of inhouse training- Health and Accident Underwriting Managers

Video Library & Tutorials //

View Entire Video Gallery ››

Making the same change to multiple worksheets in Excel

Making the same change to multiple worksheets in Excel

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Some of our Featured Clients