• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Outline Manually Upward

mgris

New Member
Hi !


When you manually create an outline to group data, it groups rows "downwardly"


Lets say you want to group row 2,3,4.

If you select those and group them, it will do so on row 5.


I don't like it this way... :(


Do you know a way that allow to group "upwardly", i.e that would group rows 2,3,4 in row 1 ?


Thx in advance,


M.
 
Thank the nature of accounting for that "feature". It was originally designed so that subtotals (which come at a bottom of a list) would be displayed while the compiled data would be hidden.
 
I know... Accounting sucks ! LOL

Surprisingly, if for instance A1 contains the sum of A2 + A3 + A4, Auto Outline will group the data upward... Therefore it should be feasible manually... But how ???

Any of you have an idea ?

Thx,

M.
 
Not sure if this is what your after

Add the following 2 subroutines to a Code Module in VBA Alt F11

Run each as appropriate

Not the commented lines for Columns if required

[pre]
Code:
Sub Summary_Above()
With ActiveSheet.Outline
.AutomaticStyles = False
.SummaryRow = xlAbove
'   .SummaryColumn = xlRight
End With
End Sub

Sub Summary_Below()
With ActiveSheet.Outline
.AutomaticStyles = False
.SummaryRow = xlBelow
'   .SummaryColumn = xlLeft
End With
End Sub
[/pre]
 
Hmm. After some more digging, I noticed that (at least in 2003) you can go to:

Data - Group and Outline - Settings, and uncheck the box for "Direction: Summary rows below detail"


This seems to do what you want. Thanks to Hui though for making me aware that this was even possible. =)
 
@ Hui Thank you so much that's awesome !

@ Luke M: Unluckily I work on excel 2007... Thx though ;)
 
Back
Top