Footer in Excel

D

David V

How do you not have the footer shown on the first page
when you print the document?
 
C

Chip Pearson

David,

You can't. Header and Footer sections apply to all pages the
worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

David McRitchie

If you want to make the macro a little more generalized
you could have your headers and footers as you want them
for the rest of the sheets then have the macro save the
header/footer parts you want to change and then restore
them after printing the first page. (in Ron's macro)

If you wanted to do first page differently with respect to headers,
such as with or without a logo
or no header rows you can do that by using the top rows of
the spreadsheet and doing the rows to repeat later on. And
forcing the page break just before your rows to repeat.
http://www.mvps.org/dmcritchie/excel/logoshd.htm#toprows
 
Top