Grouping rows in Excel with the plus/minus icon in the first row

[MattMatthias]

Basically the title says it. I'm grouping rows using a statement like this:

sheet.Range("A2", "A10").Rows.Group()

This works perfectly, but the problem is that the plus/minus button is below
the group in row 11, but I need it to be in row 1.
I realize that it makes sense to have it below the rows if you want to hide
the components of a sum, but I'm want to use the groups for hiding lower
members of a hierarchy. I attached 2 screenshots for illustration.

#1: Expanded hierarchy, note the minus below, not above the group:
http://img31.imageshack.us/img31/1128/hiexpanded.jpg
#2: Collapsed hierarchy, with the plus in the wrong row:
http://img221.imageshack.us/img221/6779/hicollapsed.jpg

Is there a way to do this? I already spent hours on google but didn't find
anything.

I'm using Excel 2007 and VS2008 SP1, the project is an application level
add-in.


Thanks a lot for your answers and thoughts on this.

 

[Lex]

You could try:
ActiveSheet.Outline.SummaryRow = xlAbove

 

[Jacob Skaria]

Matt

This is a sheet setting. Try below and feedback

ActiveSheet.Outline.SummaryRow = xlAbove
ActiveSheet.Range("A2", "A10").Rows.Group

If this post helps click Yes

 

[MattMatthias]

That did it!
Thank you so much! It almost drove me nuts...

 

[feejaz]

Grouping in Word document

Hi everyone,

I just read this post about the Excel sheet for Grouping. Please let me know, how can I do the Grouping in Word document. Like in the excel sheet we can grouping/ Hiding the rows. I could not found a way to do this in word document. There are hundred's of rows in the Word document and and need to hide/Group that no need to see all the time. But want to save in the document for reference.

Help needed.

regards,

feejaz

 

[Donkeykong2012]

Hi all

For Excel 2007/2012. On the Data tab, outline subsection. If you click the arrow at the bottom right of the box, this provides the additional setting. Uncheck collate below and all summary rows will be grouped from above.

Regards