Excel Headers and Footers

Learn how to create and work with Excel Headers and Footers.

It’s easy to add headers and footer to your Excel spreadsheets, similar to those added to Word documents.  The Excel headers and footers allow you to include document details, such as titles, dates, page numbers, locations, etc. while also making the spreadsheet more professional looking in appearance.  Below are the step-by-step instructions for working with Excel Headers and Footers.

Working with Headers
Creating a Header
  1. Click the Insert tab.
  2. Click Header & Footer in the Text group. VLBTechEd Excel Headers Footers Image 1
  3. Excel will switch to the Page Layout view.
  4. Click the left, center or right header text box at the top of the worksheet page.VLBTechEd Excel Headers Footers Image 2
  5. Type the header.
    • Press Enter to start a new line in the header.
    • To include an ampersand (&) in the text of the header, use two ampersands. Example:  Smith & Jones LLC would be typed as Smith && Jones LLC in the header area. VLBTechEd Excel Headers Footers Image 3

      VLBTechEd Excel Headers Footers Image 4
      (Print Preview)
  6. Elements can be added to the header from the Header & Footer Elements group on the Design tab.
  7. Options can also be set from the Options group on the Design tab.VLBTechEd Excel Headers Footers Image 5
  • Header & Footer Elements allows you to add specific elements to your Header:
    • Page Number
    • Number of Pages
    • Current Date
    • Current Time
    • File Path
    • File Name
    • Sheet Name
    • Picture (such as a logo) VLBTechEd Excel Headers Footers Image 6

      VLBTechEd Excel Headers Footers Image 7
      (Print Preview)
  • Options allow you to format the header.
    • Different First Page – Create a different header for the first page, similar to the Word feature.
    • Different Odd & Even Pages – Create different headers for odd and even pages.
    • Scale with Document – Scale the Header to match the spreadsheet scaling.
    • Align with Page Margins – Align the header margins to match the spreadsheet margins.
  1. Once you have completed setting up your header, click the Normal View icon to the right side of the status bar to return to the normal view. VLBTechEd Excel Headers Footers Image 8
Using Built-in Header
  1. Once you have navigated to the header in the Page Layout view, click the Design tab.
  2. Click Header in the Header & Footer group.VLBTechEd Excel Headers Footers Image 9
  3. Click one of the listed headers. VLBTechEd Excel Headers Footers Image 10
  4. Click the Normal View icon to the right side of the status bar to return to the normal view. VLBTechEd Excel Headers Footers Image 11
Working with Footers
Creating a Footer
  1. Click the Insert tab
  2. Click Header & Footer in the Text group.VLBTechEd Excel Headers Footers Image 12
  3. Excel will switch to the Page Layout view.
  4. Click Go to Footer from the Navigation group on the Design tab.VLBTechEd Excel Headers Footers Image 13
  5. Click the left, center or right footer text box at the top of the worksheet page. VLBTechEd Excel Headers Footers Image 14
  6. Type the footer.
    • Press Enter to start a new line in the footer.
    • To include an ampersand (&) in the text of the footer, use two ampersands. Example:  Smith & Jones LLC would be typed as Smith && Jones LLC in the footer area.
  7. Elements can be added to the footer from the Header & Footer Elements group on the Design tab.
  8. Options can also be set from the Options group on the Design tab. VLBTechEd Excel Headers Footers Image 15
  • Header & Footer Elements allows you to add specific elements to your Footer.
    • Page Number
    • Number of Pages
    • Current Date
    • Current Time
    • File Path
    • File Name
    • Sheet Name
    • Picture (such as a logo) VLBTechEd Excel Headers Footers Image 16

      VLBTechEd Excel Headers Footers Image 17
      (Print Preview)
  • Options allow you to format the Footer.
    • Different First Page – Create a different footer for the first page, similar to the Word feature.
    • Different Odd & Even Pages – Create different footers for odd and even pages.
    • Scale with Document – Scale the footer to match the spreadsheet scaling.
    • Align with Page Margins – Align the footer margins to match the spreadsheet margins.
  1. Click the Normal View icon to the right side of the status bar to exit the header and return to the normal view. VLBTechEd Excel Headers Footers Image 18

Using Built-in Footer

  1. Once you have navigated to the header in the Page Layout view, click the Design tab.
  2. Click Footer in the Header & Footer group.VLBTechEd Excel Headers Footers Image 19
  3. Click one of the listed footers. VLBTechEd Excel Headers Footers Image 20
  4. Click the Normal View icon to the right side of the status bar to exit the footer and return to the normal view. VLBTechEd Excel Headers Footers Image 21

To learn more about Office applications, please check out my courses at vlbteched.teachable.com.

9 thoughts on “Excel Headers and Footers”

  1. Hey There. I found your blog using msn. This is a very well written article. I will be sure to bookmark it and return to read more of your useful info. Thanks for the post. I’ll certainly comeback.

  2. fantastic publish, very informative. I wonder why the other specialists of this sector don’t understand this. You must proceed your writing. I am sure, you’ve a huge readers’ base already!

Leave a Reply

Your email address will not be published. Required fields are marked *