Buzz
This article provides a detailed guide on how to create header and footer in Excel 2013.
To create header and footer, follow these steps:
Step 1: Go to the Page layout -> Page Setup -> click the arrow below:
Step 2: The dialog box appears -> click the Header / Footer tab:
- In the Header section, click the arrow to choose the sheet for the header:
Step 3: After selecting the sheet for the header -> click Custom Header to input content for the header:
Step 4: The Header dialog box appears -> input content for the header with various options:
- Left Header: Input content for the header on the left side of the printed page.
- Center Header: Input header content at the center of the printed page.
- Right Header: Input header content on the right side of the printed page.
After entering the content, click OK:
Step 5: Click Custom Footer to input content for the footer:
Perform the same steps as entering content for the header:
- If you want to input different footer content for odd and even pages -> check the Different odd and even pages box -> the dialog box prompts you to input content for even pages with similar steps.
- If you wish to input different footer content for the first page, check the Different first pages: box.
- After entering the header content, click Print Preview to see the header displayed in the selected position.
This article provides a detailed guide on how to create header and footer for a spreadsheet in Excel 2013.
Wishing you all the best!
