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

Mail Merge Help 1
Merging from an Excel file with graphics 1
Need some PWA help 0
Improving Macro That Keeps First Letter 0
Variable row groupings 3
Finding the proper style field and the numbered paragraph value within the style 0
Save mulit-page two-sided document as a PDF 1
group and outline 1

Top