 | Scale the sheet size for printing |  | Show All |
|
Do any of the following:
| Print a sheet to fit the page width |
-
On the Layout tab, under Print, select the Fit To check box.
-
In the page(s) wide box, enter
1 (for one-page wide).
-
In the page(s) 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 Layout tab, under Print, select the Fit To check box.
-
In the page(s) wide and page(s) 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 Layout tab, under Print, in the Scale box, enter the percentage to reduce or enlarge the sheet.
| Note Printed data never exceeds 100%. |
-
On the File menu, click Print.
Share your feedback about this topic
