Headers and Footers

Contact Us or call 1-877-932-8228
Headers and Footers

Headers and Footers

To insert a header or footer into a Microsoft Excel workbook:

  1. On the INSERT tab, in the Text group, click Header & Footer:Header and Footer in Text Group of Insert Tab
  2. Note that:
    1. Excel has switched to the PAGE LAYOUT view, in which the header and footer are visible. When done editing the header and footer, simply switch back to the Normal view:Views on Status Bar
    2. The header contains three sections: left, center and right. By default your cursor starts in the center section of the header, but you can switch to one of the others by clicking on it:Header Sections
    3. Excel has automatically opened the HEADER & FOOTER TOOLS DESIGN toolbar:Header and Footer Tools Design Toolbar
  3. From the HEADER & FOOTER TOOLS DESIGN toolbar you can:
    1. In the Header & Footer group, click Header or Footer and insert one of the options available:Header Options
    2. In the Header & Footer Elements group, insert one of the following:
      1. Page Number. Adds the page number to the selected section of the header or footer.
      2. Number of Pages. Adds the number of pages to the selected section of the header or footer.
      3. Current Date. Adds the current date, at the time of printing, to the selected section of the header or footer.
      4. Current Time. Adds the current time, at the time of printing, to the selected section of the header or footer.
      5. File Path. Adds the file path to the selected section of the header or footer.
      6. File Name. Adds the file name to the selected section of the header or footer.
      7. Sheet Name. Adds the sheet name to the selected section of the header or footer.
      8. Picture. Opens up the Insert Picture dialog box, where you can surf to and select a picture by clicking Insert.Header and Footer Elements Group
    3. In the Options group, check Different First Page to set the header and footer such that they do not show on the first page:Options Group
  4. To move between the header and the footer, click Go to Footer or Go to Header in the Navigation group:Navigation Group
  5. To exit the Header/Footer go to View > Workbook Views > Normal
Next