Microsoft Office Tutorials and References
In Depth Information
Build a Custom Header and Footer
Chapter 3: Customizing Worksheet Presentation
Build a Custom Header
1 Type any text you want in
the header.
2 If you want to include a
predefined header item,
click Header and then
click the item.
3 Click a button in the
Header & Footer Elements
group to add that element
to the header.
3
22
5
1
Excel inserts a code into the
header, such as &[Date]
for the Current Date
element as shown here.
4 Repeat steps 1 to 3 to
build the header.
5 Click Go to Footer.
Build a Custom Footer
1 Type any text you want
to display in the footer.
2 If you want to include a
predefined footer item,
click Footer and then
click the item.
3 Click a button in the
Header & Footer Elements
group to add that element
to the footer.
4 Repeat steps 1 to 3 to
build the footer.
5 Click outside the footer.
6 Click the Normal icon to
exit Page Layout view.
‚óŹ
3
22
1
5
6
More Options!
You can have a different header and footer on
the first page, which is useful if you want to add
a title or explanatory text to the first page. In the
Design tab, click to select the Different First
Page option. You can also have different
headers and footers on the even and odd pages
of the printout, such as showing the filename
on the even pages and the page numbers on
the odd pages. In the Design tab, click to select
the Different Odd & Even Pages option.
Did You Know?
Before you print the workbook, you
might want to get the big picture
and see the header, footer, and
sheet text all at once. To do this,
click File and then click Print. In the
Print tab that Excel displays, the right
side of the tab shows you a preview
of the workbook printout. Click the
arrows to scroll through the pages.
 
Search JabSto ::




Custom Search