Microsoft Office Tutorials and References
In Depth Information
Adding Custom Headers and Footers
Figure 10–48. The Custom Header dialog box
Here you can see three edit boxes or sections, which correspond to the three header ,
areas (that turn blue) in the Page Layout view. Note the existing header data lurking
behind all those button descriptions, too. This text can be deleted in word-processing
fashion: just select the relevant header and press the Delete key.
You can click in any one of the edit boxes and type any header data you wish, and you
can click any of the buttons above the edit boxes to access additional options. The
following list reviews what these buttons do (from left to right):
Format Text: Clicking this button will call up Excel’s standard Font dialog
box, enabling you format header text.
Insert Page Number: This button posts a page number on each printed
Insert Number of Pages: This places the total number of pages in a printout
in each page’s header/footer. Thus, in a three-page printout, a 3 will be
displayed on each page.
Insert Date: This records the date on which the printout was executed.
This means of course that the header/footer will change according to the
date on which you print.
Insert Time: This displays the time when the printout was issued.
When you click one of these buttons in the desired section, a
strangelooking code is installed in that area. For example, if you click the Insert
Date button in the right edit box, you’ll see what’s shown in Figure 10–49.