Repeat Rows but not on every page!

A

AndreaW

Is it possible to set the repeat for just a certain number of pages, not all?
Example: I want to repeat $2:$2 on page 1 through 6 but I don't want the
repeat on pages 7 through 10. Is there a way to define this?
 
L

Luke M

Setup a custom print macro that prints pages 1-6 with the repeated row, and
pages 7 - 10 w/o repeat?
(You can record this macro yourself)
 

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

Excel Vertical to horizontal repeat after 16 rows 3
Repeat Rows at Top - Except Final Page 2
Rows to repeat on each page 6
count how long it will takes for a number to repeat 1
How do I repeat rows at the top of SOME of the pages in Excel 2
Can I repeat rows at the top, except the last page? 3
Printing non-contiguous rows at the top 1
Repeat rows on top - in worksheet - not printing! 2

Top