Microsoft Office Tutorials and References
In Depth Information
Working with Headers and Footers
Different Odd & Even Pages: Choose this
option if you want a header or footer for
the odd-numbered pages of the document
different from the one that prints on the
Page Number: Insert a code that indicates
the page number.
Number of Pages: Insert a code that
indicates the total number of pages.
Scale with Document: This option is
selected by default and tells Excel to use the
same font size and scaling as the worksheet.
If you want the header and footer font size
and scaling independent of the worksheet
scaling, clear this check box.
Adding Static Text
You can add text to the Page text. For
example, “Page &[Page] of &[Pages]” will print
“Page 3 of 5” or “Page 1 of 2”.
Align with Page Margins: Choose this
option to align the header and footer with
the left and right margins of the worksheet.
If this is unchecked, the header and footer
margins print independently of the
Current Date or Current Time: Insert the
print date or time of day.
File Path, File Name, or Sheet Name:
Include file information.
Picture: Insert a graphic image such as a
Creating Custom Headers and
If none of the predefined headers or footers meets
your needs, you can easily create your own. While
in Page Layout View, choose the desired header or
footer section in which you want to work. Type the
text you want for the header (or footer), which, as
you see in Figure 12-25, you can format just as you
would any cell data. You can also choose from any
options in the Header & Footer Elements group:
Format Picture: Resize, rotate, or crop a
header or footer graphic image.
To continue editing the worksheet, when you are
finished working in your header or footer, click a
cell outside the header or footer area.
Creating your own header or footer.