View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Print Page setup question

Perhaps you could insert a row 10 and copy from row 29 (will be row 30
now) or put formulae in to make it dynamic:

=A30

copied across from A10. Adjust the repeat rows to $2:$10.

Hope this helps.

Pete

On Aug 3, 4:26*pm, Damian wrote:
Can the "Rows to Repeat on Top" and print rows that are not continuous?

ex.
I want to repeat Row $2:$9 and also Row 29. Is there a way to do this?