Scale the Sheet Size

Print a sheet to fit the page width

1.   From the Ribbon, click Layout tab go to Print and select the Fit to check box

TIP              You can select Fit to check box located under Scaling in the Print dialog box

2.   In the page(s) wide box, enter 1 (for one-page wide)

3.   In the page(s) tall box, enter 0 so that the number of pages tall is unspecified

4.   Press command + P (⌘P)

NOTE          Excel ignores manual page breaks when you use the Fit to option

 

Print a sheet on a specified number of pages

1.   From the Ribbon, click Layout tab > Print > select the Fit to check box

TIP              You can select Fit to check box located under Scaling in the Print dialog box

 

2.   In the page(s) wide and page(s) tall boxes, enter the number of pages on which you want to print the sheet

3.   Press command + P (⌘B)

NOTE           Excel ignore manual page breaks when you use the Fit to option

 

Reduce or enlarge a sheet to fit the page

1.   From the Ribbon, click Layout tab ð Print

2.   In the Scale box, enter the percentage to reduce or enlarge the sheet

NOTE           Printed are never exceeds 100%

3.   Press command + P (⌘P)