Print Different First Page in Excel

Add to Favorites

How to include different information, headers, or footers, on the first page when printing an Excel spreadsheet.

Steps

Go to the View tab and click Page Layout.

2bdfa8a7eceea7f9d19eb1c751483b96.jpg

Click at the top of the page where it says Click to add header or click the bottom where it says Click to add footer.

e126566a942c6264d21b664a7b46705a.jpg

Click the Design tab that should have now appeared and put a check next to Different First Page.

a409f52bfd0d3023cdc967970f907f25.jpg

Now, you can put whatever you want in the header and footer for the first page and it will not affect the following pages.

Go to Print Preview to verify this:

1936cf57eac409cea43d903c93cdb182.jpg

In the included workbook for this tutorial the first page will say First Page in the left side of the header.

Notes

This is a very helpful feature, especially when you want to design a cover page that should not have anything in the header or the footer.

Make sure to download the sample file to see the above example in Excel.

Like this tutorial? Follow us on Google +

Excel Version: Excel 2007, Excel 2010, Excel 2013
Downloadable Files: Excel File