Page Layout: Scale to Fit

You can print the spreadsheet smaller if you wish. You can force the printout to fit 1-9 pages wide or tall. You can also scale the printout by percentage.

 

1. Try This: Scale to Fit Options

Go to Page Layout->Scale to Fit

 

What Do You See? There are combo boxes for the Width and the Height. You can choose a percent for Scale or type your own.

 

2. Try This, Too: More Page Options

When you click on the Option arrow in the bottom right corner of the Scale to Fit group you will return to the Page tab in the Page Setup Window.

 

Memo to Self: The text and numbers on a spreadsheet may get very small if you select Fit to 1 page to make it all print on one sheet.

About half of the population (including your boss) wears bifocals and cannot see the type! Who is your audience! Can they read it?

graphic1

Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.5 Configure Worksheets and Workbooks to Print or Save: Set Print Scaling

 

Page Layout -> Scale to Fit

graphic2
graphic3