Microsoft Office Tutorials and References
In Depth Information
Creating Headers and Footers
The header area
Figure 14-43:
The Header & Footer
Tools | Design tab is
chock-full of useful
ingredients you can
add to a header or
footer. Click a button
in the Header &
Footer Elements section to
insert a special Excel
code that represents
a dynamic value, like
the current page.
If none of the standard options match what you need, you can edit the automatic
header or footer, or you can create your own from scratch. Start typing in the header
or footer box, and use the buttons in the Header & Footer Elements section to paste
in the code you need for a dynamic value. And if you want to get more creative,
switch to the Home tab of the ribbon, and then use the formatting buttons to change
the font, size, alignment, and color of your header or footer.
Finally, Excel gives you a few high-powered options in the Header & Footer Tools |
Design Options section. These include:
Different First Page . This option lets you create one header and footer for the
first page, and use a different pair for all subsequent pages. Once you’ve checked
this option, fill in the first page header and footer on the first page, and then
head to the second page to create a new header and footer that Excel can use for
all subsequent pages.
Different Odd & Even pages . This option lets you create two different headers
(and footers)—one for all even-numbered pages and one for all odd-numbered
pages. (If you’re printing a bunch of double-sided pages, you can use this option
to make sure the page number appears in the correct corner.) Use the first page
to fill in the odd-numbered header and footer, and then use the second page to
fill in the even-numbered header and footer.
Search JabSto ::

Custom Search