Ever have one of those spreadsheets that do not quite fit on one page, no matter what you do! There is a simple way to make it fit. When you have your spreadsheet open click on the Page Layout tab and go to the Scale to Fit group. If your spreadsheet is too long then change the Height field from Automatic to 1 Page. If your spreadsheet is too wide change the Width field from Automatic to 1 Page. Do either one or both.
Notice the Scale box directly below that field, the percentage changes from 100% to whatever Excel needs to shrink the spreadsheet so it will fit on one page. Example: from 100% it could go to 94%, meaning your spreadsheet is 6% smaller to enable it to fit on one page.
This method is simple and fast. Hope it helps!
Call Software Savvy to schedule your next Excel class and learn many more of these ‘productivity increasing’ features!
Get Excel savvy!