Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac More...Less
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
-
On the Page Layout tab, select Page Setup.
-
On the Page tab, select the Fit To check box.
-
In the Page wide by box, enter 1 (for one-page wide).
-
In the Tall box, enter 0 so that the number of pages tall is unspecified.
-
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
-
On the Page Layout tab, select Page Setup.
-
On the Page tab, select the Fit To check box.
-
In the Pages wide by and Tall boxes, enter the number of pages on which you want to print the sheet.
-
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
-
On the Page Layout tab, select Page Setup.
-
On the Page tab, select the Adjust to check box, and select the percentage to reduce or enlarge the sheet.
Note:Printed data never exceeds 100%.
-
On the File menu, click Print.
Need more help?
Want more options?
Discover Community
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.