Microsoft Office Tutorials and References
In Depth Information
Setting page orientation and scale
Scale the printout to a fixed number of pages
1 Click the Page Layout tab.
2 In the Scale To Fit group, click the Width down arrow and select the
number of horizontal pages that your worksheet should take up
3 In the Scale To Fit group, click the Height down arrow and select
the number of vertical pages that your worksheet should take up
TIP If you want to force your worksheet to print on 10 or
more pages in either dimension, click the Width or Height
control’s down arrow, and click More Pages. Then, using the controls
on the Page tab of the Page Setup dialog box, select the Fit To option
and type the number of pages the rows (pages wide) and columns (tall)
of your worksheet should be forced to fit on. Click OK.
TRY ThIS 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 now fits on a single page wide but prints on additional vertical
pages if necessary.