Add predefined or custom headers and footers to Excel spreadsheets

In Excel, headers and footers are lines of text that are printed at the top (header) and footer (footer) of every page on a worksheet. Headers and footers contain descriptive text such as headings, dates, or page numbers. Because they are not visible in normal sheet view, headers and footers are added to the sheet when it is printed.

The instructions in this article apply to Excel 2019, 2016, and 2013.

Contents
  1. Options for working with headers and footers
  2. Place the header and footer
  3. Preset headers and footers
  4. Add a custom header or footer to a page layout
  5. Add a predefined header or footer to a page layout
  6. Return to normal view from page layout view
  7. Add predefined headers and footers in the Page Setup dialog
  8. Remove headers and footers

Options for working with headers and footers

Excel comes with several preset titles, such as page numbers or book titles, that are easy to add. Or you can create custom headers and footers that contain text, images, and other spreadsheet data.

Although real watermarks cannot be created in Excel, “pseudo” watermarks can be added to a worksheet by adding images to custom headers or footers.

Place the header and footer

A header or footer can contain up to three pieces of information. This information can appear in three places on the page. For headings, the locations are the top left, top center, and top right of the page. For footers, the locations are the bottom left, bottom center, and bottom right of the page.

Preset headers and footers

Most of the preset headers and footers available in Excel introduce codes such as: † [Page] or † [Date] to enter the required information. These codes make the headers and footers dynamic. This means they change as needed, while custom headers and footers are static.

For example code † [Page] shows different page numbers on each page. When entered manually using a custom option, each page has the same page number.

Add a custom header or footer to a page layout

Add a custom title or title to a view page layout

  1. Select Vision

  2. Select page layout going to page layout

  3. Choose one of three fields at the top or bottom of the page to add a header or footer.

  4. Enter header or footer information in the selected field.

Add a predefined header or footer to a page layout

Add one of the preset titles or titles to a view page layout

  1. Select Vision

  2. Select page layout going to page layout

  3. Choose one of three fields at the top or bottom of the page to add header or footer information. Note that a new tab will appear labeled “Design”.

  4. On the Design tab, select a preset option. For example, choose one of the options Page number, current date or file name.

Return to normal view from page layout view

Once you’ve added a header or footer, Excel will let you in page layout † While it is possible to work in this mode, you can return to normal vision. For this:

  1. Select every cell on the sheet to exit the header/footer area.

  2. Select Vision

  3. Select normal

Add predefined headers and footers in the Page Setup dialog

Use the Page Setup dialog box for more control over the appearance of headers and footers. Here’s how:

  1. Select Page layout.

  2. Select Launchpad Page Settings to open the dialog Page Settings

  3. In the dialog box, select the tab Header/Footer

  4. Select a predefined title from the drop-down list Page main or footer

  5. Select Okay to close the dialog box.

Custom headers and footers can also be added to the dialog box by selecting Custom Header or Custom Footer

Remove headers and footers

To remove headers and footers from multiple sheets at once:

  1. Select sheets.

  2. Select page layout

  3. Select Launchpad Page Settings to open the dialog Page Settings

  4. In the dialog box, select the tab Header/Footer

  5. Select (New) in the drop-down list of preset headers and footers.

  6. Select Okay to close the dialog box.

  7. All header or footer content will be removed from the selected sheets.

Leave a Reply

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