Archive of Mr Excel Message Board

Back to Printing in Excel archive index
Back to archive home

Header/Footer

Posted by Carol on January 07, 2002 1:07 PM

I only want the header to appear on page 1, how do I get it off every page??
Thank you for your help

Re: Header/Footer

Posted by Scott on January 07, 2002 1:14 PM

I can give you two ways of doing this (of course there could be many more). The first would be to include the Header on the sheet itself as part of the print range. The second would be to create two seperate print ranges; one for the first page and one for the remainder. Set the header on the first page. You could do a macro that would set the print ranges and headers, and then print so it would all be in one step.

Follow Scott's suggestion below, but before you print...

Posted by Mark W. on January 07, 2002 1:22 PM

...right click any one of your workbook's tabs and
choose "Select All Sheets" before you print.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.