See all How-To Articles

Insert or Remove Headers & Footers in Excel & Google Sheets

This tutorial shows how to insert and remove headers and footers in Excel and Google Sheets.

 

remove header insert footer 15

 

Insert a Header in Excel

In Excel, headers and footers appear at the top and bottom of each page you print. To insert a header in Excel, follow these steps:

 

remove header insert footer initial1

 

  1. First click on Insert tab and choose Header & Footer from the Text group.

 

remove header insert footer 1

 

  1. This opens the Header & Footer tab.

 

remove header insert footer 2

 

  1. Now, you can see three boxes at the top of the page. The center box is selected by default, but if you want the header to appear in the top right or top left corner of the page, click the right or left box and enter your information there.

 

remove header insert footer 7

 

For more on entering header content, see How to Insert Picture Into Header in Excel and Google Sheets.

  1. To leave the header area, just click anywhere in the worksheet.

Insert a Footer in Excel

Just like inserting a header in Excel, you can insert a footer in few easy steps.

 

remove header insert footer initial2

 

  1. In the Ribbon, go to Insert > Header & Footer (from the Text group).

 

remove header insert footer 1

 

  1. This sends you to the Header & Footer tab.

 

remove header insert footer 2

 

  1. In the Header & Footer tab, click on Go to Footer to navigate directly to the footer. Or you can scroll down to the bottom of the page.

 

remove header insert footer 5

 

  1. Just as with the header, the footer has three boxes, and the center box is selected by default. If you want your footer to appear in the right corner of the page then put information in the right box, or if you want it to be in the left corner put information in the left box.

 

remove header insert footer 6

 

  1. When you are done editing the footer, just click anywhere in the worksheet to exit the footer area.

Remove Headers and/or Footers

  1. To remove the header and footer, first exit the header and footer area. To do that, click anywhere in the worksheet. Then in the Ribbon, go to Page Layout and activate Page Setup Dialog Box by clicking on the arrow in the bottom right part of the Page Setup group.

 

remove header insert footer 8

 

  1. In Page Setup Dialog Box click on Header/Footer, to remove header choose none and to remove footer also choose none.

 

remove header insert footer 9

 

As a result of Step 2, the header and footer is removed from the worksheet.

 

remove header insert footer 11

 

  1. To hide white space, move your cursor to the left and when it changes into another icon click on it.

 

remove header insert footer 10

 

  1. To restore normal view, in the Ribbon, go to View > Normal (in the Workbook Views group).

 

remove header insert footer 12

 

As a result of Step 4, the worksheet returns to the normal view.

 

remove header insert footer 17

 

Insert Headers and Footers in Google Sheets

In Google Sheets, you don’t see the header or footer until you go to print your spreadsheets, so if you want to add headers or footers, follow these steps:

 

remove header insert footer 23

 

  1. The first step is to go to File in the menu and click on Print (or you could use the keyboard shortcut CTRL + P) to open the Printer Settings Menu for your document.

 

remove header insert footer 18

 

  1. After you open the Printer Settings Menu, click on Headers & footers. A list of available options for both headers and footers appears. To use custom text instead, choose Edit custom fields.

 

remove-header-insert-footer-19

 

  1. After you click on Edit custom fields, the print view disappears. Now you can edit the text boxes in the header and/or footer.

 

remove header insert footer 20

 

  1. When you are done editing, just click Confirm in the top right corner of the page.

 

remove header insert footer 21

 

As a result, you will have a header and footer in your worksheet.

 

remove header insert footer 23

 

Remove Headers and Footers in Google Sheets

  1. To remove the header and footer in Google Sheets, click File in the menu, then Print to open the Printer Settings Menu for your document.

 

remove header insert footer 18

 

  1. The Printer Settings Menu appears. In it, go to Headers & footers. To remove a header or footer, uncheck any checked options in the list of available options, or if you made a custom header or footer, go to Edit custom fields and manually delete all of the information you entered in the header and footer boxes.

 

remove-header-insert-footer-19

 

  1. After you do that, click on the Confirm button in the top right corner of the page.

 

remove header insert footer 21

 

As a result, your Google Sheets worksheet won’t have a header and footer any longer.

 

remove header insert footer 24