Microsoft Office Tutorials and References
In Depth Information
Getting Ready to Print a Worksheet
Switch to Page Layout or Normal view after you’re done fooling with page
breaks. You can clearly see page breaks in Page Layout view. In Normal view,
page breaks are marked by a dotted line.
“Scaling to fit” a worksheet
To scale the numbers and letters in a worksheet and make them a bit smaller
so that they fit on a page, you can experiment with the Scale to Fit options.
These options are located on the Page Layout tab. Starting in Page Layout
view, go to the Page Layout tab and test-drive these options to make your
worksheet fit on a single page or a certain number of pages:
✦ Scaling by width: Open the Width drop-down list and choose an option
to make your worksheet fit across one or more pages. Choose the 1 Page
option, for example, to squeeze a worksheet horizontally so that it fits
on one page.
✦ Scaling by height: Open the Height drop-down list and choose an option
to make your worksheet fit across on a select number of pages. For
example, choose the 2 Pages option to shrink a worksheet vertically so
that it fits on two pages.
✦ Scaling by percentage: Enter a percentage measurement in the Scale
box to shrink a worksheet vertically and horizontally. To scale this way,
you must choose Automatic in the Width and Height drop-down lists.
You can also fit a worksheet on a select number of pages by going to the
Page Setup dialog box shown in Figure 4-9. With this technique, you get a
chance to ”print-preview” your worksheet and get a better look at it after
you change the scale. On the Page Layout tab, click the Page Setup group
button to open the Page Setup dialog box. On the Page tab of the dialog box,
select the Fit To option button and enter the ideal number of pages you want
for your worksheet in the Page(s) Wide By and Tall text boxes. Excel shrinks
the data as much as is necessary to make it fit on the number of pages you
asked for. Click the Print Preview button to preview your worksheet in the
Print window and find out whether shrinking your worksheet this way helps.
Adjusting the margins
Another way to stuff all the data onto one page is to narrow the margins a
bit. Go to the Page Layout tab and use either of these techniques to adjust
the size of the margins:
✦ Click the Margins button and choose Narrow on the drop-down list.
✦ Click the Page Setup group button, and on the Margins tab of the Page
Setup dialog box, change the size of the margins, as shown in Figure 4-9.
By clicking the Print Preview button, you can preview your worksheet in
the Print window and adjust margins there by dragging them. Select the