Print Page setup question

D

Damian

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?
 
J

Jacob Skaria

No. Rows/columns to repeat in 'Print page setup' should be continuous...

If this post helps click Yes
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Footer 1
Excel MSO 2010 - Excel 3
Insert automatic page numbering into a cell, not a header or foote 1
Repeat Rows at Top - Except Final Page 2
Repeating Rows - Exception 1
Print Titles: Repeating both left column and top rows 2
Repeating first Row AND first column on every page 1
Help Reg Print 1

Top