Copy Rows After Page Breaks

[RJ Swain]

I am working on a sheet now for business leads. I set up the page layout for
letter size and I would like to have rows 1 & 2 to print on every page. How
can I make this happen without having to cut and paste on every page manually?

Thank you

 

[Dave Peterson]

Maybe you could try this (check to see if it breaks your page breaks):

File|Page setup|Sheet tab
Type
1:2
in the "Rows to repeat at top" box

 

[Gilbert]

Under page set up, go to the sheet tab. Click inside Rows to repeat at the
top and then select the two rows you want repeated and then click ok. Do a
print preview to make sure it will print the rows you want.