I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 08:33:16 -0700 (PDT), Opal wrote:

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

It seems to work for me, but maybe not in the way the OP wants it. If I number
the cells in column A with the row number, then go to File / Page Setup / Sheet
/ Rows to repeat at top: and enter $12:$13, my printed pages show the following:

Page 1 - number 1 through 52
Page 2 - number 12 & 13 and then 53 through 102
Page 3 - number 12 & 13 and then 103 through 152
Page 4 - number 12 & 13 and then 153 through 202


Gord Dibben wrote:
You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 08:33:16 -0700 (PDT), Opal wrote:

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

I see the same type of behaviour as Glen in Excel 2010 beta
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Glenn" wrote in message
...
It seems to work for me, but maybe not in the way the OP wants it. If I
number the cells in column A with the row number, then go to File / Page
Setup / Sheet / Rows to repeat at top: and enter $12:$13, my printed pages
show the following:

Page 1 - number 1 through 52
Page 2 - number 12 & 13 and then 53 through 102
Page 3 - number 12 & 13 and then 103 through 152
Page 4 - number 12 & 13 and then 153 through 202


Gord Dibben wrote:
You cannot do this.

Rows to repeat at top must start from the top and be contiguous.


Gord Dibben MS Excel MVP

On Tue, 6 Apr 2010 08:33:16 -0700 (PDT), Opal
wrote:

I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 & 13). But when I print the
report I get all rows from 1 to 13 repeating at
the top? Has anyone come across this?
Does anyone have any advice?

It used to repeat just 12 and 13 and now all of a sudden
and I don't know why, it is repeating 1 - 13.

Same in 2003 and 2007

I misspoke.

Rows 12 and 13 won't appear as repeating on first page but will on each
successive page.

Right as always...............NOT! <g


Gord


On Tue, 6 Apr 2010 15:46:15 -0300, "Bernard Liengme"
wrote:

I see the same type of behaviour as Glen in Excel 2010 beta
best wishes

??

Yes, they used to repeat and suddenly not...not sure why
or how this happened, but I can't get these rows to repeat
anymore.