Excel Grouping and Hide
 

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

Excel Grouping and Hide
 

one way:

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

Which "hide feature" are you referring to?

In article .com,
wrote:

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

Excel Grouping and Hide
 

On Mar 26, 12:03 pm, JE McGimpsey wrote:
one way:

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

Which "hide feature" are you referring to?

In article .com,

wrote:
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

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

Excel Grouping and Hide
 

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

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


Bill wrote:

On Mar 26, 12:03 pm, JE McGimpsey wrote:
one way:

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

Which "hide feature" are you referring to?

In article .com,

wrote:
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

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

--

Dave Peterson