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
- Display the Page Layout ribbon and notice
the options within the Scale to Fit area of the ribbon:
- 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.
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 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.
- To grow or shrink the printed worksheet by a selected about, adjust the
percentage shown within the Scale field.
- Choose OK to finish.