Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

February 28, 2017

Greetings from The Excel Addict

Hi fellow Excel Addict,

In today's 'Excel in Seconds' tip, I'm going to show you how to 'Make Your Spreadsheet Fit Your Screen'.

If you missed my last 'Excel in Minutes' tip, 'Create a Linked Picture of a Range of Cells', you can read it here now.

I'm happy to say good bye to February. Looking forward to it warming up a little for some good running weather. Today was brutally cold.

Francis Hayes (TheExcelAddict.com)

Please feel free to share my newsletter with your Excel friends — they will thank you for it.

Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)

TheExcelAddict.com Quote of the Day

"People will forget what you said, people will forget what you did,
but people will never forget how you made them feel."

-- Maya Angelou --

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

Excel in Seconds with TheExcelAddict.com

Make Your Spreadsheet Fit Your Screen

You put a lot of preparation into ceating your spreadsheets exactly the way you want them. But sometimes you'll find that by the time you've added all the columns and data, your spreadsheet is just a little too wide to fit your screen and then you have to scroll sideways
to see the last column(s).

Make Excel Worksheet Fit Screen in Microsoft Excel 2007 2010 2013 2016 365

Some people resort to make their columns narrower to make them fit within the viewable area of your screen. But there's no need for that.

Here a much easier solution...

1) Select a range of cells from the left-most cell (usually column A) to the right-most cell in your sheet. It doesn't matter how many rows. One or two will do;

2) From the View tab, in the Zoom group, click Zoom to Selection. Excel will automatically adjust to the correct zoom percentage needed to fit the columns into the visible area of your screen.

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

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

Click here to get more tips like this every week

Thanks for supporting this newsletter and website

Earnings 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 for a few dollars. 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 I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630