To reduce the amount of paper needed to print a large amount of information, you can print a sheet on just one page.

Print a sheet on one page

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

    On the Page Layout tab, select Page Setup

  2. Under Scaling, select Fit to, and type 1 in both the page(s) wide box and page(s) tall box. Select OK.

    Page Setup dialog box, with Fit to selected.

  3. On the File menu, select Print.


  • 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 Pages wide by box, and then type 9999 in the Tall box.

  • You can see how your sheet prints before you print it. On the File menu, click Print, and use the arrows to page through the worksheet.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Office Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!