Groupings and inconsistencies

R

Rod

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
 
D

Dave Peterson

You can tell excel where to put the summary rows.

In xl2003 menus:
Data|group and outline|Settings
 
R

Rod

Thanks, worked straight out of the box.


Dave Peterson said:
You can tell excel where to put the summary rows.

In xl2003 menus:
Data|group and outline|Settings
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable row groupings 3
Data Group and Ungroup 3
Macro to hide rows with zero in specifc column range 2
formula help PLEASE PT 2 5
Pivottable - use same source data, and group data differently 1
How do I read this VBA code? 1
Macro problem 2
IS THERE ANY FORMULA IN EXCEL THAT CAN DO THIS? HLOOKUP MAYBE? 1

Top