The number of pages it prints will depend on how many pages tall the scaled down spreadsheet is. Set the Scale to Fit option for Height to be Automatic.īoth methods will scale your spreadsheet so it prints out exactly one page wide. Set the Scale to Fit option for Width to be 1 page. It could also be that you have horizontal page breaks that you want to keep when you print your spreadsheet.
Suppose you want your Excel spreadsheet to print out one page wide, but you don't mind how many pages tall the print out is. Scaling an Excel spreadsheet to a specific number of pages Not only that, but Excel ignores any manual page breaks you've entered. The problem with this approach is that you can find your spreadsheet is scaled down too far and becomes too small to read. For example, you may choose to set your spreadsheet to be 1 page wide and 2 pages tall when printed.
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. The problem with that is that you can find your page fits onto one page, but becomes too small to read. Printing from Excel can be very frustrating, especially if your spreadsheet is too wide or too tall to fit on a single page.
0 kommentar(er)
