Print a sheet on just one page

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.


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

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.