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

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

On Tue, 16 Sep 2008 15:16:01 -0700, Jai
wrote:

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

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

"Gord Dibben" wrote:

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

On Tue, 16 Sep 2008 15:16:01 -0700, Jai
wrote:

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

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.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jai" wrote in message
...
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

"Gord Dibben" wrote:

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

On Tue, 16 Sep 2008 15:16:01 -0700, Jai
wrote:

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