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?