Microsoft Excel 2008: Adding Headers and Footers (Mac)

Adding Headers and Footers

Headers and footers can be useful tools for organizing and identifying a document. A header is a section of information that is printed above the body of the document, and a footer is a section of information that is printed below the body of the document. Information in headers and footers is often static throughout a document (e.g., identifying the name of the document or supplying a page number).You may choose to add a preset header or footer to your document, or to create a custom header and footer.

• Using Preset Headers and Footers
• Creating Custom Headers and Footers
• Header and Footer Elements

Using Preset Headers and Footers

Preset headers and footers are provided by Excel, or can be taken from documents you have used in the past.

1. From the View menu, select Header and Footer...
   The Page Setup dialog box appears.
   
2. From the Header or Footer pull-down menu, select a preset header or footer
3. Click OK
   The header or footer is applied to the document.
   NOTE: The header or footer may display the header or footer code on your screen, but the text will be visible when the worksheet is printed.

Creating Custom Headers and Footers

You may want to create your own headers or footers. You can adjust the font face and the size, add your own text, and add text that will be automatically updated with your document. Custom headers and footers may be added by using the Header and Footer dialog boxes.

1. From the View menu, select Header and Footer...
   The Page Setup dialog box appears.
2. To customize the header, click CUSTOMIZE HEADER...
   OR
   To customize the footer, click CUSTOMIZE FOOTER...
   The Header or Footer dialog box appears.
   

1. In the Left section, Center section, and Right section text boxes, type or use the Header & Footer Elements to insert the desired information in each section of your header or footer
2. OPTIONAL: To change the formatting of your text
   1. Select the text you want to format
   2. Click FORMAT TEXT
      The Font dialog box appears.
   3. Make all desired formatting changes
      Click OK
      You are returned to the Header/Footer dialog box.
3. When finished, click OK
   The Header/Footer dialog box closes and you are returned to the Page Setup dialog box.
4. Click OK
   NOTES:
   If you created a header with multiple lines, it may overlap with the information on the spreadsheet.
   To ensure that your header with multiple lines is displaying properly, refer to Adjusting Margins.
   The header or footer may display the header or footer code on your screen, but the text will be visible when the worksheet is printed.

Header and Footer Elements

Excel allows you to create custom headers and footers by either typing your own text or adding specific text fields. The buttons available in the Header & Footer Elements group provide you with text fields that will automatically update the information displayed as your document changes. These elements can also be added to preset headers and footers to customize your document.
The Code column in the table below shows the command that Excel will insert when the option is selected.
Although you may see only the code when looking at your document, the code will be translated to the corresponding information when the sheet is printed.
NOTES:
If you choose to create a custom header or footer using the dialog box option, note that these buttons are also available in the Header and Footer dialog boxes. However, only the graphic part of the button will be visible in these dialog boxes.

Button	Code	Action
	&[Page]	Inserts the page number NOTE: Excel will count only the pages that have data in at least one cell.
	&[Pages]	Inserts the total number of pages NOTE: Excel will count only the pages that have data in at least one cell.
	&[Date]	Inserts the current date
	&[Time]	Inserts the current time
	&[File]	Inserts the filename of the workbook
	&[Tab]	Inserts the name of the current worksheet
	&[Path]&[File]	Inserts the path and filename
	&[Picture]	Displays the Insert Picture dialog box so you can insert a picture
	None	Displays the Format Picture dialog box so you can adjust picture properties
	None	Available only in the Header and Footer dialog boxes; displays the Font text box to adjust text formatting Make sure to let me know in the comments below or on our Facebook page how you've got with it or Do you have any questions