Part I: Getting Started with Excel
create a header that prints your name at the left margin, the worksheet name centered in
the header, and the page number at the right margin.
If you want a consistent header or footer for all your documents, create a book.xltx template with your headers or
footers specified. A book.xltx template is used as the basis for new workbooks.
See Chapter 6, “Understanding Excel Files and Templates,” for details on creating a template.
When you activate the header or footer section in Page Layout view, the Ribbon displays a
new contextual tab: Header & Footer Tools ➪ Design. Use the controls on this tab to work
with headers and footers.
Selecting a predefined header or footer
You can choose from a number of predefined headers or footers by using either of the two
drop-down lists in the Header & Footer Tools ➪ Design ➪ Header & Footer group. Notice
that some items in these lists consist of multiple parts, separated by a comma. Each part
goes into one of the three header or footer sections (left, center, or right). Figure 7.6 shows
an example of a header that uses all three sections.
FIGURE 7.6
This three-part header is one of Excel’s predefined headers.
