The Excel Addict - Help with Excel 2013, 2010,
2007, 2003


March 23, 2017
 
Hi fellow Excel Addict,

Francis Hayes (TheExcelAddict.com)We're off to a typical spring in Newfoundland. 10 to 15 centimeters of snow one day, warm sunshine to melt it all away the next day, followed by another 10 to 15 centimeters of snow a day later.

On Tuesday, I used my snowblower to clear the heavy, wet snow from my driveway. Wednesday I ate lunch in the warm sunshine on my back deck. This morning I had to shovel another ten centimeters of snow off the deck. I guess I'll be having lunch inside today.


If you missed my 'Excel in Seconds' newsletter on Tuesday, I showed how to 'Add a Background Picture to a Cell Comment'. This post was a real hit with many of my readers. If you missed it you can read it here

In today's 'Excel in Minutes' tip, I'm going to show you how to 'Monitor Key Cells in Your Workbook'. Give this a try and see if this is a technique that will make life in Excel a little easier for you.

Wishing you
a great weekend and keep on Excelling,

Keep on
Excelling,
Francis Hayes (The Excel Addict)
Email:  fhayes[AT]TheExcelAddict.com



 


If you missed my last newsletter, you can click here to view it online.


 
Quote of the Day

"The world is more malleable than you think
and it’s waiting for you to hammer it into shape."

--Bono --
 
If you have a favourite quote, send it to me and I may post it in my newsletter.

Click here to get my 'Excel Addict' tips every week

Excel in Minutes with TheExcelAddict.com

Monitor Key Cells in Your Workbook

At times, when you make changes in one part of your worksheet, you will want to see how those changes affect the results in cells in other parts of your workbook or any open workbook for that matter. If this is you and you are annoyed by having to constantly switch back and forth, I've got good news for you.
 
Excel has an easy-to-use tool that can help you monitor multiple cells throughout your workbooks without having to scroll around or switch back and forth. The tool is called the Watch Window.

Watch Window Example in Microsoft Excel 2007 2010 2013 2016 365
The Watch Window displays information about specific cells in a separate small window that floats above your workbook.

The Watch Window is not saved as part of a workbook. It's part of the Excel application and behaves like a toolbar, so you can choose to show it or not.

T
he Watch Window displays following properties for each cell you add to it:

• workbook name
• sheet name
• defined name (if any)
• cell address
• cell value
• formula.


Open the Watch Window
To open the Watch Window, from the Formulas tab, click Watch Window in the Formula Auditing group.

Open Watch Window in Microsoft Excel 2007 2010 2013 2016 365

Always on Top
Y
ou can switch to any sheet in any open workbook and the "Watch Window" will always remain visible. Whenever you make any changes that affect any of the 'watch cells', the changes will immediately be reflected in the Watch Window.


Add a cell to the Watch Window
1) To add a cell that you want to watch, you can either select the cell first and click Add Watch... or you can click Add Watch... and then select the cell;
2) Click the Add button.

Add Cell To Watch Window List in Microsoft Excel 2007 2010 2013 2016 365

Add multiple cells to the Watch Window in one Step
You can add multiple cells to the Watch Window in one step. Hold down the CTRL key and select the cells. Then click Add Watch... and the Add button.

Naming cells used in Watch Window

It may be difficult to remember what each cell in the Watch Window is.

No Named Cells In Watch Window in Microsoft Excel 2007 2010 2013 2016 365
Giving each cell a descriptive name so that it too is shown in the Name column in the Watch Window will make things easier for you. To name a cell, select it, then click in the Name Box (that white space to the left of the Formula Bar) and type a name (no spaces allowed). The name will appear in name column in the Watch Window.

Named Cells In Watch Window in Microsoft Excel 2007 2010 2013 2016 365

Remove cells from the Watch Window
Remove one or more cells from the Watch Window by selecting them in the list and clicking Delete Watch.

Delete Multiple Cells From Watch Window in Microsoft Excel 2007 2010 2013 2016 365

Instantly Jump to a Watched Cell
Double-click any cell in the Watch Window and you will instantly be taken to that cell. When you're working with multiple watch cells, this can be a great time saver.

Controlling the Watch Window
Adjust Column Width: Click and drag between two column headings to adjust a column's width. Sort Column: To sort on a column, click on it's heading. Move Window: You can move the Watch Window around your screen or drag its header to 'dock it' below the Ribbon or to any edge of the Excel window. Resize Window: To resize the window, point to the edge of the window, click and drag. If the resizing cursor doesn't appear, click on the header first then try again.

Move Resize Resort Watch Window in Microsoft Excel 2007 2010 2013 2016 365

Closing/Hiding the Watch Window
When you are finished 'watching' your cells, you can close the Watch Window by clicking Watch Window in the Auditing Tool group on the Formulas tab. Any cells remaining on the list will be shown the next time you open the Watch Window and any of the workbooks on the watch list.




If you've found this tip helpful, please share it.



Click here to get my 'Excel Addict' tips every week


Thanks for supporting this newsletter and website



Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.

8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630