Excel Grouping and Hide

K

kathyboatwright

I am trying to figure out how to get rows to group up instead of down
so that when I expand, it iexands the detail below. It keeps adding
the +/- to the row below my selection instead of the top.

Also, I am a little confused as to what the hide feature does.
Anyone?
kbeandog
 
J

JE McGimpsey

one way:

Data/Group and Outline/Settings, uncheck the "Summary rows below
detail" checkbox.

Which "hide feature" are you referring to?
 
B

Bill

one way:

Data/Group and Outline/Settings, uncheck the "Summary rows below
detail" checkbox.

Which "hide feature" are you referring to?
Click to expand...

Anyone know how to do this from VBA (i.e. uncheck those boxes)?
 
D

Dave Peterson

Sometimes, just recording a macro will show you the code that you need:

With ActiveSheet.Outline
.AutomaticStyles = False
.SummaryRow = xlAbove
.SummaryColumn = xlRight
End With
 
Top