If you're using Excel 2007 and earlier for PC, or Excel for Mac 2008 or 2011 Set the Scale to Fit options for Width and Height to the values you want.You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. This lesson explains how you can print your spreadsheet so it automatically scales to be one page wide without forcing the rows into a single page. Not only that, but Excel ignores any manual page breaks you've entered. The problem with that is that you can find your page fits onto one page, but becomes too small to read. You can use the Scaling option in Page Setup to set limits on how many pages wide and tall your document should be when you print it. Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.
