Scale the sheet size for printing

You can reduce or enlarge the sheet size for printing to fit the page width, or on a specified number of pages.

Print a sheet to fit the page width

1. On the Page Layout tab, select Page Setup.

On the Page tab, select the Fit To check box.

Note: Excel ignores manual page breaks when you use the Fit To option.

Print a sheet on a specified number of pages

1. On the Page Layout tab, select Page Setup.

On the Page tab, select the Fit To check box.

Note: Excel ignores manual page breaks when you use the Fit to option.

Reduce or enlarge a sheet to fit the page

1. On the Page Layout tab, select Page Setup.

On the Page tab, select the Adjust to check box, and select the percentage to reduce or enlarge the sheet.

Note: Printed data never exceeds 100%.