Excel 2010 Bible

Part I: Getting Started with Excel

186

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 9.6 shows an example of a header that

uses all three sections.

FIGURE 9.6

This three-part header is one of Excel’s predefined headers.

Understanding header and footer element codes .....................................................

When a header or footer section is activated, you can type whatever text you like into the section.

Or, to insert variable information, you can insert any of several element codes by clicking a button

in the Header & Footer Tools ➪ Design ➪ Header & Footer Elements group. Each button inserts a

code into the selected section. For example, to insert the current date, click the Current Date but-

ton. Table 9.2 lists the buttons and their functions.

TABLE 9.2

Header & Footer Buttons and Their Functions

Button Code Function

Page Number &Page] Displays the page number

Number of Pages &[Pages] Displays the total number of pages to be printed

Current Date &[Date] Displays the current date

Current Time &[Time] Displays the current time