Create header and footer in Excel

The following article details you how to create headers and footers in Excel 2013.

Create header and footer in Excel Picture 1

To create the header, the footer follows these steps:

Step 1: In card Page Layout -> Page Setup -> click on the arrow below:

Create header and footer in Excel Picture 2

Step 2: A dialog box appears -> click the header / Footer tab :

- In the Header section, click the arrow to select the sheet to create a title:

Create header and footer in Excel Picture 3

Step 3: After selecting the sheet to create a title -> click on Custom Header to enter the content for the header:

Create header and footer in Excel Picture 4

Step 4: The Header dialog box appears -> enter the content for the title with options:

- Left Header: Enter the title content on the left side of the printed page.

- Center Header: Enter the title content in the middle of the printed page.

- Right Header: Enter the title content on the right side of the printed page.

After entering the content, click OK:

Create header and footer in Excel Picture 5

Step 5: Click Custom Footer to enter the content for the header at the bottom of the page:

Create header and footer in Excel Picture 6

The same operation as entering text for headers:

Create header and footer in Excel Picture 7

- In case you want to enter the title content for different odd and even pages -> check the Different odd and even pages -> dialog box to ask for content for even pages with the same operation.

- If you want to enter the content of different first page titles, tick the Different first pages:

Create header and footer in Excel Picture 8

- After you enter the title content, you click Print Preview will see the title content displayed at the selected position.

Create header and footer in Excel Picture 9

Above is a detailed guide on how to create headers and footers for spreadsheets in Excel 2013.

Good luck!