How to Find and Add Header and Footer in Excel
Question details
The user needs to insert a header and footer into an Excel worksheet but is unable to locate the corresponding command on the main interface.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Preparing a spreadsheet for printing or professional distribution by adding document titles, dates, or page numbers at the top and bottom of the pages.
- Observed behavior
- The Header & Footer command is not immediately apparent to the user when navigating the standard Excel ribbon.
Ensure your worksheet contains the data you intend to print, as headers and footers are primarily visible in the Page Layout view or print preview mode rather than the standard working view.
Access Header & Footer via the Insert Tab
The quickest and most direct method to add headers and footers is by using the Text group located on the Insert tab.
Using the Insert tab is the standard approach for adding document-level text elements. When you trigger this command, Excel will automatically switch your workbook from Normal view to Page Layout view so you can edit the header and footer areas directly on the page.
Look at the main ribbon at the top of your Excel window and click on the 'Insert' tab.
Scan to the right side of the Insert ribbon to find the 'Text' command group.
Click the 'Header & Footer' button. Your view will change, and your cursor will automatically be placed in the center header section ready for typing.
Find Header & Footer via the Page Layout Tab
You can also manage your headers and footers through the traditional Page Setup dialog box, which is ideal if you are adjusting margins and orientation at the same time.
Easily Add Headers and Footers with WPS Spreadsheet
WPS Spreadsheet offers a highly intuitive ribbon interface that makes finding and applying headers, footers, and page numbers incredibly straightforward. It is fully compatible with Microsoft Excel files, allowing you to format your documents for printing with zero hassle.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your workbook in the WPS Spreadsheet application.
- 2. Navigate to Insert: Click on the 'Insert' tab located on the top ribbon menu.
- 3. Select Header and Footer: Click the 'Header and Footer' icon to instantly access the page layout setup.
- 4. Customize and Apply: Type your desired text, insert dynamic dates, or add page numbers, then apply them to your printed pages.
Frequently Asked Questions
Why can't I see my header and footer in the normal Excel view?
Headers and footers are only visible in the Page Layout view or the Print Preview screen because they are strictly print elements. To see them while working, go to the 'View' tab on the ribbon and select 'Page Layout'.
How do I automatically insert page numbers in the Excel footer?
While editing your footer in Page Layout view, click inside the footer area. A special 'Header & Footer' tab will appear on the ribbon. Click 'Page Number' in the Header & Footer Elements group to insert the dynamic page number code (&[Page]).
Can I have a different header for the first page of my spreadsheet?
Yes. While in the Header & Footer editing mode, look at the 'Header & Footer' tab on the ribbon. Check the box that says 'Different First Page'. You can then type a unique header that will only appear on page one.
How do I remove a header or footer in Excel?
The easiest way to remove them is to go to the Page Layout tab, click the Page Setup dialog launcher arrow, navigate to the Header/Footer tab, and select '(none)' from the dropdown menus for both the Header and the Footer.
