Print a sheet on just one page


To reduce the amount of paper needed to print a large amount of information.


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

    Layout tab, Print group .

  2. Type 1 in both the page(s) wide box and page(s) tall box.

    Layout tab, Print group .

  3. Click Print.

    Click Print button


  • To print a sheet so that the columns appear on one page and the rows extend to more than one page, type 1 in the page(s) wide box, and then type 9999 in the page(s) tall box.

  • You can see how your sheet prints before you print it. On the File menu, click Print, and then click Preview.

See also

Print with landscape orientation

Set page margins

Scale the sheet size for printing

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!