Create, Edit, and Delete Headers and Footers

Headers and Footers can help to determine what kind of data that the worksheet contains, when it was last updated, including information related to the file name, date the file was printed, and the page numbers, at the bottom or top of each printed page

NOTE

  • Headers and Footers don't show on the worksheet in normal view — they are only visible in page layout view and on the printed pages.
  • Each sheet in a workbook can have its own headers and footers
  • When you customize your header or footer, you can add images, page numbers, date, time, sheet name, file name and path, and more.

 

Insert a standard or customized Header or Footer

1.   From the Ribbon, click Layout tab go to View group and choose Page Layout

2.   From the Ribbon, click Layout tab go to Page Setup group and choose Header & Footer

 

3.   In the Page Setup dialog box, select Headers & Footers tab

  • To add a pre-made header or footer, click the list down arrow under Header section or Footer section and select a desired style from the list

 

  • To add a customized header or footer, click Customize Headers or Customize Footers button

 

  • Use the controls in the Headers dialog box or Footers dialog box to create a custom style
  • Select desired positions to insert a custom header or footer in separate sections: Left, Center and Right section
  • Enter the text you want to appear in the header or footer

TIP  To create a header or footer with the style “Page 1 of 5”, do the following:

  1. Select a desired position to insert a header or footer
  2. Click Insert Page Numbers button (displayed as & [Page] in the section box)
  3. Press space key on the keyboard
  4. Type the word “of”
  5. Press space key on the keyboard
  6. Click Insert Page Numbers button
  7. Click OK  button

 

Insert an image to a Header or Footer

1.   From the Ribbon, click Layout tab go to View group and choose Page Layout

2.   From the Ribbon, click Layout tab go to Page Setup group and choose Footer & Header

3.   In the Page Setup dialog box, do the following:

  • Select Headers & Footers tab
  • Click Customize Headers or Customize Footers button

4.   In the Headers dialog box or Footers dialog box, do the following:

  • Select desired positions to insert a custom header or footer in separate sections: Left, Center and Right section
  • Click Insert Pictures button

5.   In the Choose a Picture dialog box, browse a desired picture and click Insert button

 

NOTE         To format an image inserted in the header or footer of the document, do the following:

  1. Select the image by high the code in the section you want to insert it into
  2. Click Format Picture
  3. Use the controls in the Format Picture dialog box to edit the picture

Remove a Header and Footer

1.   From the Ribbon, click Layout tab go to Page Setup group and click Header & Footer

2.   In the Page Setup dialog box, select Headers & Footer tab and do the following:

  • To remove a standard header or footer, click the list down arrow under Headers section or Footer section and select (none)
  • To remove a custom header or footer, click Customize Header button or Customize Footer button and text in the sections box