Prev: numbers in a column are not sorting ascending
Next: Need to bring back 2 vlookup values
From: Opal on 6 Apr 2010 11:33
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?
From: Gord Dibben on 6 Apr 2010 14:31
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 <tmwelton(a)hotmail.com> 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?

From: Glenn on 6 Apr 2010 14:44
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 <tmwelton(a)hotmail.com> 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?
>
From: Bernard Liengme on 6 Apr 2010 14:46
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" <address(a)not.valid> wrote in message
news:udTzDkb1KHA.224(a)TK2MSFTNGP06.phx.gbl...
> 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 <tmwelton(a)hotmail.com>
>> 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?
>>
From: Opal on 6 Apr 2010 15:18
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.

 |  Next  |  Last
Pages: 1 2 3
Prev: numbers in a column are not sorting ascending
Next: Need to bring back 2 vlookup values