Row to repeat while printing

[Jai]

Hello All,

I would like to reprint certain rows while printing. I know how to get rows
to repeat on ever page but I was to select which rows print on which page.

IE:
Rows 1 through 10 on pages 1 & 2

Rows 1 through 8 and row 55 on page 3 & 6 and so on.

Can this be done?

Thanks
Jai

 

[Gord Dibben]

Separate print jobs.

You could run from a macro but would still be multiple print jobs.

BTW...........rows to repeat at top must be contiguous.

i.e. 1 through 8 and 55 is not possible.


Gord Dibben MS Excel MVP

 

[Jai]

Thank you, that is what I thought. I was hoping to to avoid manually putting
in headers through out my spreadsheet that need to be changed when I add a
row or two.

Thanks

Jai

 

[Don Guillett]

You could, in row 9, put =a58 (etc), repeat rows 1-9 instead of row 8 to
print and then hide row 9 when not printing.
A macro can do this for you automatically.