Print a sheet on just one page in Excel 2016 for Mac

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.

Tips

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

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.

×