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


M

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.
 
Ad

Advertisements

J

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
 
Joined
Jul 10, 2009
Messages
1
Reaction score
0
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
 
Ad

Advertisements

Joined
Aug 7, 2012
Messages
1
Reaction score
0
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
 
Ad

Advertisements


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

Top