If you're having trouble viewing the images in this message,Hi fellow Excel Addict,
please go here to read the online version of this newsletter
Greetings from a cold and wet Newfoundland. What a difference a few days can make. On Sunday morning, I participated in a 10K 'fun run' at the beautiful Manuel's River in my hometown of Conception Bay South. The weather at that time was exceptionally warm and humid, especially for an early morning in late October in Newfoundland. Today is a far cry from warm and humid. With rain and 4°C (39°F), it's not such a great day for running.
In today's 'Excel in Minutes' tip I want to show you 'How to Monitor Changes in Key Cells Throughout a Workbook'. I hope this will help make things easier for you when working with your large, complex workbooks.
If you missed my 'Excel in Seconds' newsletter on Tuesday, I showed you why 'It's Easier to Concatenate without CONCATENATE'. You can read that tip here.
I hope you have a great week and 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.
How to Monitor Changes in Key Cells Throughout a Workbook
When you change the value of a cell in one worksheet, that often affects values in other cells throughout your workbook. If you are working in one worksheet and need to monitor how your changes affect specific cells in other sheets, switching back and forth is very time consuming and not very efficient.
Thankfully, Excel has a feature called the Watch Window that makes it simple and convenient to keep track of any cells you want to monitor throughout your workbook.
The Watch Window is a small window that displays certain properties about each cell you add to it: workbook name, sheet name, defined name, cell address, current value, and formula.
To add cells to the Watch Window...
1) From the Formulas tab, click Watch Window in the Formula Auditing group. The Watch Window appears;
2) Select the cell (or multiple cells) you want to watch, click Add Watch..., then click Add.
The Watch Window now displays the information about all the cells you have added.
And since the window stays on top, this information is always in view as you move around a worksheet or among worksheets. As you make changes, you'll see 'live updates' for your 'watched cells'.
Additional Notes about Excel's Watch Window:
|"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