Find out
You can print a worksheet to fit the paper width or a specific number of pages.
- Click the worksheet you want to print.
- Go to File|Page Setup.
- Click the Page tab.
- Under Scaling, click Fit to.
To fit to a paper width, type "1" for page(s) wide in the first box beside Fit to. Clear the contents of the second box to leave the tall value unspecified. To fit the data in your worksheet into a specific number of pages, enter into the boxes the number of pages on which you want to print your worksheet.
Finally, make sure you are not working with manual page breaks when using the Fit to function, since Excel ignores them.