Hi fellow Excel Addict,
Do you know what a 'blocking high' is?
No, it has nothing to do with Excel. Apparently a blocking high is a weather term for an area of high pressure (i.e. nice weather) that has stalled and is preventing an area of low pressure (i.e. not so nice weather) from moving. For more than a week there has been an area of low pressure stalled right over Newfoundland. That means lots of rain and not much sun here lately.
But I'm taking Ryan, our weatherman, at his word. He is promising lots of sun and warm temperatures starting on Sunday.
Excel Macros for Beginners Course: Just a quick reminder that the Early Bird discount on Allen Wyatt's 'Excel Macros for Beginners' online video course ends tonight (June 16, 8PM Pacific Time). If you've ever wanted to learn macros, you really should check this out.
If you missed my 'Excel in Seconds' newsletter on Tuesday, I showed you how to 'Quickly Clean Up Inconsistent Phone Number Formats'. As many of you discovered, this tip is not just for phone numbers. I received many emails from readers who realized other areas they could apply this same tip. You can read the tip here.
Wishing you another great day of 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.
Making Your Spreadsheets Fit Your Screen
You put a lot of preparation into designing your spreadsheets exactly the way you want them. But sometimes you'll find that your spreadsheet may be just a little wider than will fit in the visible area of your screen. Maybe you have several spreadsheets like this now, where the last column or two are just out of view on the right side.
The problem is that not only do you have to scroll up and down to navigate your spreadsheet but you also have to scroll left and right.
I've seen people try to make these last couple of columns fit by using smaller font sizes, narrowing their column widths, and abbreviating data in some columns. Maybe you've tried some of these too.
For those spreadsheets where just a column or two are off to the right side of your screen, you can adjust the zoom percentage a little to make them visible. However, if your worksheet is really wide, adjusting the zoom percentage may make your worksheet data too small to read.
Here is a simple and easy way to fit your spreadsheet to your screen...
1) Select a range of cells from column A to the right-most column in your worksheet. It doesn't matter how many rows. One or two will do;
2) Click the percentage value (e.g. 100%) on bottom right corner of your Status Bar. Then, from the Zoom dialog, choose 'Fit selection' and click OK. If you use the Ribbon instead, the command is on the View tab and is called 'Zoom to Selection'. Excel automatically adjusts the zoom percentage so that the cells you have selected will fit perfectly into the visible area of your screen.
Alternatively, you could try dragging the Zoom slider on the bottom right of your Excel window to make things fit but you may find that it's difficult to get the perfect zoom percentage.
If your mouse has a scroll wheel, holding down the CTRL key while turning the wheel will allow you to quickly zoom in and out. However, this method allows you to scroll only in larger % increments. The % depends on your settings. On my mouse it's 5%.
Note that when you adjust the Zoom percentage to make your worksheet fit, is won't be maintained automatically. If you subsequently add columns or adjust current columns widths, you may need to your Zoom percentage again.
|"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