As you look at your worksheet and think about how you want it to appear on the printed page, be aware that you have the choice of printing in a vertical format (portrait mode) or a horizontal format (landscape mode). Landscape mode is particularly useful when you have a lot of columns in your worksheet, such as in a worksheet storing customer contact or product sales information. You can fit your worksheet onto a specific number of printed pages, which helps if you have been allotted a fixed number of pages in which to present your data in a typeset report.
In the Scale to Fit group, click the Width down arrow and select the number of horizontal pages your worksheet should take up when printed.
In the Scale to Fit group, click the Height down arrow and select the number of vertical pages your worksheet should take up when printed.
Click the Microsoft Office button, click the Print item’s arrow, and then click Print Preview to see how the document will look after it is forced onto a fixed number of pages.
The maximum number of pages you can choose from the Width and Height list boxes is nine. If you want to force your worksheet to print on 10 or more pages in either dimension, click the Scale to Fit dialog box launcher, select the Fit To option button, and then type how many pages the rows (pages wide) and columns (tall) should be forced to fit. Click OK.
Click the Page Layout tab and then click the Page Setup group’s dialog box launcher. In the Page Setup dialog box, click the Page tab and then select the Fit To option. Type 1 in the Page(s) Wide box and delete the contents of the Tall box. The worksheet will now fit on a single page width but will print on additional vertical pages if necessary.
18.219.236.70