Copy Rows After Page Breaks
 

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

Copy Rows After Page Breaks
 

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



RJ Swain wrote:

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

Copy Rows After Page Breaks
 

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.

"RJ Swain" wrote:

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