Microsoft Office Tutorials and References
In Depth Information
Creating Headers and Footers
Creating Headers and Footers
A header is a bit of text that’s printed at the top of every page in your printout. A
footer is a bit of text that’s printed at the bottom of every page. You can use one, both,
or neither in a printout.
Ordinarily, every new workbook starts out without a header or footer. However,
Page Layout view gives you an easy way to add either one (or both). Just scroll up
to the top of any page to create a header (or the bottom to create a footer), and then
look for the box with the text “Click to add header” or “Click to add footer”. Click
inside this box, and you can type the header or footer text you want.
Note: You won’t see the header or footer boxes if you’ve drastically compressed your margins. That’s
because the header and footer don’t fit. To get them back, resize the margins so that they’re larger. When
you’re finished adding the header or footer, you can try adjusting the margins again to see just how small
you can get them.
Of course, a good header or footer isn’t just an ordinary piece of text. Instead, it
contains information that changes dynamically, like the file name, current page, or
the date you printed it. You can get these pieces of information using specialized
header and footer codes , which are distinguished by their use of square brackets. For
example, if you enter the code [Page] into a footer, Excel replaces it with the current
page number. If you use the code [Date] , Excel substitutes the current date (when
you fire off your printout). Of course, no one wants to memorize a long list of cryptic
header and footer codes. To help you get these important details right, Excel adds a
new tab to the ribbon named Header & Footer Tools | Design (Figure 14-43) when
you edit a header or footer.
The quickest way to get a header or footer is to go to the Header & Footer Tools |
Design Header & Footer section (shown in Figure 14-43), and then choose one of
the Header or Footer list’s ready-made options. Some of the options you can use for
a header or footer include:
• Page numbering (for example, Page 1 or Page 1 of 10).
• Worksheet name (for example, Sheet 1).
• File name (for example, myfile.xlsx or C:\MyDocuments\myfile.xlsx ).
• The person who created the document, and the date it was created.
• A combination of the above information.
Oddly enough, the header and footer options are the same. It’s up to you to decide
whether you want page numbering at the bottom and a title at the top, or vice versa.
Search JabSto ::

Custom Search