March 23, 2017
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)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
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.
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.
The Watch Window displays following properties for each cell you add to it:
• workbook name
• sheet name
• defined name (if any)
• cell address
• cell value
Open the Watch Window
To open the Watch Window, from the Formulas tab, click Watch Window in the Formula Auditing group.
Always on Top
You 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 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.
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.
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.
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.
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.
|"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