Page 308 - Excel 2013 All-in-One For Dummies

290 Headers and Footers
and punctuation. For example, to have Excel display Page 1 of 4 in a custom header or footer, you do the following:
a. Type the word Page and press the spacebar.
b. Click the Page Number command button and press the spacebar
again.
c. Type the word of and press the spacebar a third time.
d. Click the Number of Pages command button.
This inserts Page &[Page] of &[Pages] in the custom header (or 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, italics, 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 in 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-12 shows you a custom footer I added to a spreadsheet in Page Layout view. This custom footer blends my own text with program-gen- erated page, date, and time information, and uses all three sections: left- aligned page information, a centered Preliminary warning, and right-aligned current date and time.
Creating unique first-page headers and footers
Excel 2013 enables you to define a header or footer for the first page that’s different from all the rest of the pages. Simply click the Different First Page check box to put a check mark in it. (This check box is part of the Options group of the Design tab on the Header & Footer Tools contextual tab that appears when you’re defining or editing a header or footer in Page Layout view.)