View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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