February 28, 2017
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.
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)
If you missed my last newsletter, you can click here to view it online.
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).
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.
If you've found this tip helpful, please click here to share it.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630