I have a booklet I want to print from Excel 2000. I'm not seeing how to have the HEADER on page one only. The header is coming up on all pages. Is there a way to tell Excel to print the Header on page one only?
Thank you for your help.
I have a booklet I want to print from Excel 2000. I'm not seeing how to have the HEADER on page one only. The header is coming up on all pages. Is there a way to tell Excel to print the Header on page one only?
Thank you for your help.
Last edited by LS Flowers; 03-05-2009 at 03:56 PM.
coffee man
http://www.excelforum.com/excel-misc...heet-only.html
but it can be done with two different print areas with a macro
or a workaround is
put page 1 only on sheet 1 with headers footers ect.
set print area
then
put rest on sheet 2
set print area
then before print
usr ctrl to select sheet 1 AND sheet 2 then print.
only the page from sheet 1 will have the headers/footers.
Last edited by martindwilson; 03-05-2009 at 11:57 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you much, I'll give it a go now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks