Search Not Just Numbers

Loading...

Tuesday, 27 January 2015

Excel Tip: Keep an eye on multiple cells

Do you ever have those situations when you are trying different scenarios and constantly checking to see what effect your twiddling is having on your results?

Wouldn't it be great if you could keep an eye on all of the cells you were interested in, without having to scroll all over the place?

Well, Excel has a nice simple tool to allow you to do exactly that.

The Watch Window tool is accessed from the Formulas ribbon, over to the right hand side of the ribbon.

When you click on the tool, it opens the Watch Window which hovers over the spreadsheet like any other toolbar.

Once the Watch Window is open you can add the cells that you want to keep your eye on by clicking Add Watch... and selecting the cells, either one by one or by selecting a whole range of cells. If you do this, all of the individual selected cells will be listed in the Watch Window. These cells can be on different worksheets and even in different workbooks.

For each cell, the Watch Window lists the Workbook, Worksheet, Name (if you have given the cell a name range), Cell reference, Value and Formula.

As you update the spreadsheet, the Watch Window will provide a live update of the effect on those cells. No more scrolling around!

Before I go, don't forget that Mynda Treacy's Excel Dashboards course is closing on Thursday, so get over there now if you don't want to miss out.

Excel Dasboard Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".

4 comments:

  1. Glen
    Thanks for this tip and all the others. I just love how we can keep on learning more Excel skills. Keep up the good work.
    Regards

    ReplyDelete
  2. Thank you for sharing. Excel is my favorite work tool (flexible, fast and easy)

    ReplyDelete
  3. With a sea of options to accept from, this chanel replica cast gives you all the abandon to put all your preferences to taste. Abundant colors accomplish it easier for any analogous with altered accoutrements colors that you which to combine. With anniversary of prada replica the designs fatigued up to accommodated altered purposes, one has the options to accept a shoe for a purpose. The assorted shoes can be acclimated for official louis vuitton replica tours or aces on the added airy designs aimed at alfresco activities and gucci replica antic depending on your specific preferences.

    ReplyDelete
  4. There's no doubting can mirror the wearers’ classiness and great flavour. The unrivaled design mixing with lovely skillfullness helps make the Breitling Replica watches besides chic and exquisite and chic, and also the simple and suitable for various functions. Just about every Rolex Replica watch is embodying the creating concept of pursuing the coexistence of visual design and efficiency. If you have a Cartier watch on your hand, you are unable to only go through the incredible design as well as Replica Watches design and style, but additionally experience various anywhere and anytime. Cartier different watches are truly value proudly owning each fashionable man or woman. Nevertheless, Cartier’s classiness and nobleness are likewise mirrored within the steep selling prices. Maybe you should Jackson from retailer on http://www.ulster-junior-open.org.uk/home.asp ?

    ReplyDelete