Excel > Excel 2007 Foundation > Printing a Worksheet

Add a Header and Footer

Data can be added to the top (header) or bottom (footer) of a page in the margin area to appear when printed.

Any text or picture such as a logo can be added. Fields, information that updates automatically, such as the date or page number can also be added.

  1. Click the Header and Footer button in the Text group of the Insert tab
  2. The workbook switches to Page Layout View and the cursor appears in the header area, ready to add or edit some text.

    The Header and Footer Tools contextual tabs appear on the Ribbon providing commands for working with headers and footers.

    Insert a header

    To work with the footer, click the Go To Footer button in the Navigation group of the Design tab.

  3. Enter the header or footer text and click outside of the area.
  4. The header or footer is centre aligned by default. Select the areas to the left or right to apply the appropriate orientation to the header or footer.

Insert header and footer elements

Individual elements such as page numbers, pictures and the date can be added to a header or footer

  1. Click the Header and Footer button in the Text group of the Insert tab
  2. The Header and Footer Tools contextual tabs appear.

  3. Click the button in the Header and Footer Elements group of the Design tab for the element you want to insert.

Use auto headers and footers

You can insert built-in header and footer text as an alternative to writing the text or inserting the appropriate field yourself.

  1. Click the Header and Footer button in the Text group of the Insert tab
  2. Click either the Header or Footer button in the Header and Footer group on the Design tab
  3. A list of different types of page numbers, dates, titles and file paths appears.

  4. Select the auto header of footer you want to use
  5. The text is automatically inserted into the header or footer. Any text entered previously is replaced.

Follow us on

Facebook  Twitter  You Tube