Excel Header Footer First Page Only
Yes, you can add a header or footer to only the first page in Excel, but it requires a built-in feature called “Different First Page” that many users overlook. You enable it in the Page Setup dialog, then type your header or footer content for the first page separately from the rest of the document.
Why Excel Doesn’t Do This by Default
Excel’s normal header and footer behavior applies the same content to every printed page. This is fine for simple documents, but it becomes a problem when you want a title page with a logo or a cover page with no header, while the rest of the report shows page numbers and a document title. Microsoft added the “Different First Page” option to solve exactly this, but it is hidden inside the Page Setup dialog rather than the main Insert tab.
How to Enable Different First Page
Follow these steps in Excel 2016, 2019, 2021, or Microsoft 365:
- Click the Page Layout tab on the ribbon.
- Click the small arrow in the bottom-right corner of the Page Setup group (the little square with an arrow). This opens the Page Setup dialog.
- Go to the Header/Footer tab.
- Check the box that says Different first page.
- Click OK.
Now you can insert a header or footer for the first page. The trick is that Excel creates two separate areas: one labeled “Header” and one labeled “First Page Header.” You must type your content into the correct one.
Adding Content to the First Page Header or Footer
After enabling the option, go back to the Insert tab and click Header & Footer. Excel switches to Page Layout view. You will see three text boxes at the top of the page (left, center, right) and three at the bottom. On the first page, the text boxes are labeled with “First Page Header” or “First Page Footer” in the center box. On subsequent pages, they are just “Header” or “Footer”.
Type whatever you want on the first page into the first page boxes. For example, you might put a company name and logo in the first page header, and leave the other pages with just a page number in the footer. If you want the first page to have no header or footer at all, simply leave those boxes empty.
Using Built-in Header and Footer Elements
Excel provides quick elements like page numbers, file name, current date, and sheet name. On the Header & Footer tab, you’ll see buttons for these. Click into a first page header or footer box, then click a button to insert the code. For example, clicking Page Number inserts &[Page]. The code will display as the actual page number when you click outside the box or print.
One common misconception is that the first page header and footer are linked to the rest of the document. They are not. You can have completely different content, or even different formatting, on the first page.
Common Problems and Fixes
Here are a few issues people run into:
- Header appears on all pages: You probably typed the content into the regular header box instead of the first page header box. Double-check the label in the center box.
- The option is grayed out: This happens if you are in Normal view. Switch to Page Layout view (View tab > Page Layout) or open the Page Setup dialog from the Page Layout tab.
- First page header shows on page 2: Make sure the “Different first page” checkbox is still checked. If you later uncheck it, the first page header content is deleted and the regular header applies to all pages.
- Header appears too large or overlaps content: Adjust the header margin in Page Setup > Margins tab, or reduce the font size in the header.
Print Preview and Troubleshooting
Always check Print Preview (Ctrl+P) before printing. This shows exactly what will appear on each page. If the first page header looks correct but the second page also shows it, go back to the Header & Footer tab and confirm the checkbox is still ticked. Sometimes users accidentally uncheck it when adjusting other settings.
Another tip: If you want the first page to have no header but the rest to have one, leave the first page header boxes empty. Excel will not automatically copy the regular header to the first page when “Different first page” is on.
Alternatives to Different First Page
If you need more control, you can create separate print areas or use a separate worksheet for the first page. For example, put the cover page on Sheet1 and the report on Sheet2, then set print areas accordingly. However, this splits the document into two files if you need a single PDF. Another option is to use a macro to conditionally hide headers, but that is overkill for most users.
For most situations, the built-in “Different First Page” feature is the simplest and most reliable method. It works for both headers and footers, and it applies to the printed output and PDF exports.
Frequently Asked Questions
How do I remove the header from the first page only?
Enable “Different first page” in Page Setup, then go to the first page header and delete all content. The regular header on other pages will remain.
Does “Different first page” work in Google Sheets?
No. Google Sheets does not have a built-in “different first page” option. You would need to manually set up separate print ranges or use a workaround like creating a separate sheet for the first page.
Can I have a different header on the first page and the rest of the document in Excel Online?
Excel for the web has limited header/footer features. The “Different first page” option is not available in the online version. You can only set a single header and footer for the entire worksheet.
Why is my first page header showing on every page?
You likely typed the content into the regular header box instead of the first page header box. Check the label in the center of the header area. Also ensure the “Different first page” checkbox is checked.
How do I add page numbers starting from page 2?
Enable “Different first page” and leave the first page footer empty. In the regular footer, insert a page number field. The first page will have no number, and page 2 will show “2”. If you want page 2 to show “1”, you need to adjust the starting page number in Page Setup > Page tab.
Does the first page header affect the print area?
No. The header and footer are independent of the print area. They only affect what appears in the margins of each printed page.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.