Microsoft Office Tutorials and References
In Depth Information
From Header to Footer
5. (Optional) To modify the font, font size, or some other font attribute
of your custom header or footer, drag through its codes and text, click
the Home tab, and then click the appropriate command button in the
Font group.
In addition to selecting a new font and font size for the custom header or
footer, you can add bold, italic, underlining, and a new font color to its
text with the Bold, Italic, Underline, and Font Color command buttons on
the Home tab.
6. After you finish defining and formatting the codes and text for your
custom header or footer, click a cell in the Worksheet area to deselect
the header or footer area.
Excel replaces the header/footer codes in the custom header or footer
with the actual information, while at the same time removing the Header
& Footer Tools contextual tab from the Ribbon.
Figure 5-11 shows you a custom footer I added to a spreadsheet in Page
Layout view. This custom footer blends my own text, Preliminary Client List,
with a program-generated sheet name, date, and time information, and uses
all three sections: left-aligned page information, centered Preliminary Client
List text, and right-aligned current date and time.
Figure 5-11:
A
spreadsheet
in Page
Layout view
showing
the custom
footer.
Search JabSto ::




Custom Search