I have two sheets in the same workbook (Excel XP SP3)

In one sheet if I select say rows 5 to 10 and do Data, Group
Then the '+' sign is alongside row 4, and when I expand the group the '-'
sign stays next to row 4 with the line extending down to row 10.
This is what I want.

In the other sheet if I do exactly the same but this time the '+' sign is
next to row 11 and when expanded the '-' sign stays next to row 11 and the
line extends upwards.
In the same two sheets column groupings behave differently as well.
I really don't want this.

Anybody got a clue about what is going on?


many thanks

Rod

You can tell excel where to put the summary rows.

In xl2003 menus:
Data|group and outline|Settings



Rod wrote:

I have two sheets in the same workbook (Excel XP SP3)

In one sheet if I select say rows 5 to 10 and do Data, Group
Then the '+' sign is alongside row 4, and when I expand the group the '-'
sign stays next to row 4 with the line extending down to row 10.
This is what I want.

In the other sheet if I do exactly the same but this time the '+' sign is
next to row 11 and when expanded the '-' sign stays next to row 11 and the
line extends upwards.
In the same two sheets column groupings behave differently as well.
I really don't want this.

Anybody got a clue about what is going on?

many thanks

Rod

--

Dave Peterson

Thanks, worked straight out of the box.


"Dave Peterson" wrote in message
...
You can tell excel where to put the summary rows.

In xl2003 menus:
Data|group and outline|Settings



Rod wrote:

I have two sheets in the same workbook (Excel XP SP3)

In one sheet if I select say rows 5 to 10 and do Data, Group
Then the '+' sign is alongside row 4, and when I expand the group the '-'
sign stays next to row 4 with the line extending down to row 10.
This is what I want.

In the other sheet if I do exactly the same but this time the '+' sign is
next to row 11 and when expanded the '-' sign stays next to row 11 and
the
line extends upwards.
In the same two sheets column groupings behave differently as well.
I really don't want this.

Anybody got a clue about what is going on?

many thanks

Rod

--

Dave Peterson

Visit www.ExcelGoodies.Com

---
frmsrcurl: http://msgroups.net/microsoft.public...nconsistencies