Microsoft Office Tutorials and References
In Depth Information
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout
Adjust to lets you modulate the size of the printout by a percent of the original, “actual” print size.
It thus affords you a way to enlarge a small print range so that it occupies more of the page if you type a
percentage greater than 100. On the other hand, entering a percentage less than 100 can act as a
variation on the Fit Sheet on Sheet One Page option. Type say, 92 in the Adjust to field and you may be
able to make room on page 1 for those few excess rows that have tip-toed onto page 2.
Fit to represents a variation on the Fit All Columns or Rows On One Page options. It lets you resize
the printout either horizontally or vertically, and again may come into play if your printout
experiences a small surplus of columns or rows. If, say, the last five of the 200 rows you want to print
g e t bumpe d on to a n e w pa g e—sa y pa g e 4—y ou ca n cl i ck 3 i n the tall Fit to field, and Excel will shrink
the row sizes just a bit in order to achieve a three-page-tall output, which now encompasses all 200
rows. These options are also available via the Page Layout tab Scale to Fit button group (note that
modifying Fit to automatically changes the percentage you’ll see in the Adjust to box. After all, scaling
a four-page tall printout down to three pages brings about a change in the way the worksheet is
Headers and Footers—Getting to the Bottom (and the Top) of
It may not be something that immediately comes to mind to Excel users, but you can add header and
footer information to your prints, so that a recurring bit of information—such as today’s date, the
current page number, or your workbook title—will appear at the top and/or bottom of your pages.
There are two rather different routes to headers and footers, and we’ll start with the original, classic
a ppr oa ch.
The basic tools for adding headers and tooters are stored in the Page Setup dialog box, which, as
stated earlier, can be accessed in several different ways. To demonstrate, let’s open the
SampleSalespesonReport workbook, if you haven’t already done so. Select cells A1:E100, and set the
print area via the Page Layout tab Print Area (in the Page Setup button group) Set Print Area. Then
access the Page Setup dialog box, and click the Header/Footer tab. You’ll see (Figure 9-9):
Figure 9–9. The Header and Footer tab