Print Different First Page in Excel

Add to Favorites
Author:

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.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Print The Current Worksheet in Excel
Macro: This free Excel macro will print the current active worksheet in Excel. This means th...
Scale Data for Printing in Excel - Fit more onto a Printed Page
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
Print Specific Rows or Columns on Each Page in Excel
Tutorial: How to repeat specific rows or columns on every printed page so that you know what each c...
Print Gridlines in Excel
Tutorial: I'll teach you how to show gridlines for Excel when you print your files. This is a neat...
Print the Current Date or Time in Excel
Tutorial: How to print the current date and or time on an Excel spreadsheet. This is a simple techni...
Print Selected Worksheets in Excel
Macro: This free excel macro will print all selected worksheets in Excel. If there are no ot...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course