ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Print Page setup question (https://www.excelbanter.com/excel-discussion-misc-queries/238754-print-page-setup-question.html)

Damian

Print Page setup question
 
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?

Jacob Skaria

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

If this post helps click Yes
---------------
Jacob Skaria


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


Pete_UK

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?




All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com