Copy Rows After Page Breaks

  • Thread starter Thread starter RJ Swain
  • Start date Start date
R

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
 
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
 
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.
 
Back
Top