Excel Guides

How to Use Header and Footer Data Codes in Excel

You can insert header and footer information into your Excel worksheets to automatically display printable information such as page numbers, sheet names, file paths, and more. This is especially useful when you need to print or share your work with others.

To insert a header or footer code in Excel:

  1. Click the Insert tab on the ribbon.
  2. In the Text group, click Header & Footer. This will open the Header & Footer Tools contextual tab.
  3. (Optional): If you want to include a built-in code such as page number or file path, click the Quick Parts drop-down in the Header & Footer Elements group. Then select the desired code from the list.




  4. (Optional): If you want to insert your own custom information, click in the header or footer area where you want the information to appear. Then type the desired text directly into the header or footer.




  5. (Optional): To format your header or footer text, select it and use the options in the Font, Alignment, and [Number Formatting]




  6. (Optional): To insert a picture into your header or footer, click the [Insert Picture]




  7. (Optional): To position your header or footer elements differently on odd vs even pages (or first vs subsequent pages), click the [Different Odd & Even Pages], or [Different First Page]


  8. For example, if you wanted your company logo only on the first page:

    1) On page one, click in the header.
    2) Click Insert > Header & Footer.
    3) Click Quick Parts > Field.
    4) In Field Names, select Page.
    5) In Field Codes, select Current Position > Absolute from the Category list box.
    The field code should look like this: { PAGE \* MERGEFORMAT } . This code tells Word to insert "Page 1 of n," where "n" is replaced by the total number of pages in your document.
    6) Click Insert Picture from File.
    The Insert Picture dialog box appears.
    7) Locate and then click the picture that you want to insert into your document.
    8) Click Insert.
    9) Click Close Header and Footer or press Esc to exit.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.