Scale Printing

Don't you hate it when your worksheet won't fit on the 'right' number of pages? Using Excel's Scale To Fit settings, you can scale (grow or shrink) the worksheet as desired.

  1. Display the Page Layout ribbon and notice the options within the Scale to Fit area of the ribbon:
  2. To specify the number of pages wide you want you worksheet to print on, use the drop list in the Width field and select the number of pages.
  3. If you need a number greater than shown, choose More Pages at the bottom of the list then enter the value in the Fit to field(s).

  4. To specify the number of pages tall you want you worksheet to print on, use the drop list in the Height field and select the number of pages.


  5. To grow or shrink the printed worksheet by a selected about, adjust the percentage shown within the Scale field.


  6. Choose OK to finish.

Additional References