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. Notice the Scale box directly below that field. The percentage changes from 100% to whatever Excel needed 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.
Call Software Savvy to schedule your next Excel class and learn many more of these ‘productivity increasing’ features! Get Excel savvy!