Create Header and Footer in Excel

This guide provides a practical overview of Create Header and Footer, including its main features, benefits, limitations, and important considerations.

To create the header, the footer follows these steps:

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

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:

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

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:

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

The same operation as entering text for headers:

- 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:

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

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

Good luck!