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 share it with your friends |
|
Would you believe me if I told
you that
you can DOUBLE your productivity in Excel? How about TRIPLE it ? or QUADRUPLE it ? or MORE ? If I showed you a tip where you could do a task in Excel in five seconds that would typically take you 20 minutes to an hour or more, what would you call that? Productivity on steroids? ...and that's just ONE tip! "Give me 10 or 15 minutes each week and I will show you how learning a few of my time-saving 'Spreadsheet Tips From An Excel Addict' on a regular basis will seem almost effortless BUT will quickly help you BOOST your productivity in Excel beyond your imagination" - Francis Hayes, The Excel Addict Get my FREE Twice-Weekly
Newsletter
"Spreadsheet Tips From An Excel Addict" Now being read by more than 37,000+ Excel Addicts all over the world |
Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.