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 Layout tab, select Page Setup

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

    Page Setup dialog box, with Fit to selected

  3. In the Page wide by box, enter 1 (for one-page wide).

  4. In the Tall box, enter 0 so that the number of pages tall is unspecified.

  5. On the File menu, click Print.

    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 Layout tab, select Page Setup

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

    Page Setup dialog box, with Fit to selected

  3. In the Pages wide by and Tall boxes, enter the number of pages on which you want to print the sheet.

  4. On the File menu, click Print.

    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 Layout tab, select Page Setup

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

    Page Setup box, with Adjust to selected

    Note: Printed data never exceeds 100%.

  3. On the File menu, click Print.

Print a sheet to page width

  1. On the Layout tab, under Print, select the Fit To check box.

    Layout tab, Print group

  2. In the page(s) wide box, enter 1 (for one-page wide).

  3. In the page(s) tall box, enter 0 so that the number of pages tall is unspecified.

  4. On the File menu, click Print.

    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 Layout tab, under Print, select the Fit To check box.

    Layout tab, Print group

  2. In the page(s) wide and page(s) tall boxes, enter the number of pages on which you want to print the sheet.

  3. On the File menu, click Print.

    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 Layout tab, under Print, in the Scale box, enter the percentage to reduce or enlarge the sheet.

    Layout tab, Print group

    Note: Printed data never exceeds 100%.

  2. On the File menu, click Print.

See Also

Set page margins

Change column width or row height

Fix data that is cut off in cells

Print with landscape orientation

Print headings or titles on every page

Insert, move, or delete page breaks in a sheet

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×