Microsoft Office Tutorials and References
In Depth Information
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout
This dialog box, little changed from previous Excel versions, offers you a pretty extensive array of
pre-packaged header/footer options. Click the down arrow by Header, for example, and you’ll get
(Figure 9-10):
Figure 9–10. Customizing a header
Click on the first drop-down option and your printout will display the page number at the top of
e a ch pa g e . T he n e xt se l e cti on , Page 1 of ? , indicates the current page number relative to the total
number of pages in the printout, e.g., Page 1 of 3, Page 2 of 3, etc. Source Data refers to the name of the
pa r ti cul a r worksheet on which you’re working in the header, and so on; and these options are likewise
available on the Footer dr op-down menu.
You’ve also doubtless noted the Custom Header… and Custom Footer… buttons posted in the
dialog box, too. These enable you to do two things that aren’t available in those initial drop-down
menus: They allow you to align a header or footer on the left, center, or right of a page, and they allow
you to enter your own, customized text, e.g., your name, or Acme Widgets, Inc., as well. To see what I
mean, click Custom Header…. You’ll see (Figure 9-11):
Figure 9–11. Header options, and where to place them
Search JabSto ::

Custom Search