It's about time to learn macros in Microsoft Excel 2007 2010 2013 2016 365

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
June 16, 2016

Greetings from The Excel Addict
Hi fellow Excel Addict,

Francis Hayes ( 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)
Email:  fhayes[AT]

If you missed my last newsletter, you can click here to view it online. Quote of the Day

"Sometimes your joy is the source of your smile,
but sometimes your smile can be the source of your joy."

-- Thich Nhat Hanh

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

Today's Microsoft Excel Tip

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.

When your worksheet Doesn't Fit Your Screen
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.

Fit To Selection Zoom in Microsoft Excel 2007 2010 2013 2016 365

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.

Drag Zoom Slider in Microsoft Excel 2007 2010 2013 2016 365
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.

It's about time to learn macros in Microsoft Excel 2007 2010 2013 2016 365

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
Copyright Francis J. Hayes All Rights Reserved.

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