How to start header on second page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the header to start on the second page. Other programs prompt you
where to start. Excel doesn't seem to do this. Do I have to write a macro
to accomplish this? If so, how do I find out how to do that?
 
IF you mean that you want a constant row to appear on each PRINTED sheet
then
file>page setup>sheet>rows to appear
 
Ron's macro examples are an excellent resource, no doubt about that!

If you do not want to work with macro's , you could have the cover
sheet on a seperate worksheet without the header.

Select both worksheets by holding the <cntrl> while clicking on the
second sheet and click onto print button.
 
go to Page Setup, then Header/Footer. Check the second option:
"Different First Page" . Header and/or Footer will not print on First Page. It will start from Second page and so on. I am using Excel 2007.
 
Back
Top