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

select Page Setup" />

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

with Fit to selected" />

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

select Page Setup" />

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

with Fit to selected" />

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

select Page Setup" />

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

Page Setup box, with Adjust to selected" />

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%.