How do I setup a header in Excel that prints only on first page?

[Guest]

I've created an Excel spreadsheet with a header. The spreadsheet prints on 5
pages.
I want the header to print on pg 1 but not pgs 2-5. Is this possible?

Currently the header is a custom header and prints on every page. I'd prefer
fot he header to print on pg 1 only.....

 

[Excel_Geek]

You'll probably need to remove the header info from the header, an
insert one (or however many you need) rows above the top of your "pag
1 content", and put the header info there. Decrease the top margin o
the page accordingly.

This should do it for you. I know of no "simple" way to prin
something in the header fields only on the first page in Excel.

Later

 

[Ron de Bruin]

Hi Mike

You can do this only with a macro, see
http://www.rondebruin.nl/print.htm#Header

 

[Excel_Geek]

Very nice, Ron de Bruin!