Footer in Excel

  • Thread starter Thread starter David V
  • Start date Start date
D

David V

How do you not have the footer shown on the first page
when you print the document?
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top