Data (group And Outline)
 

Hello fellow Excel users.

I'm using the Data otion to outline and seggegrate the data. However the possition of the button doesn't seems very logical to me. The button works from downunder to upwards. Is there a way to have it the other way around? Please see attachement to understand my question.

Cheers,

Jun

Data (group And Outline)
 

Junnies expressed precisely :
Hello fellow Excel users.

I'm using the Data otion to outline and seggegrate the data. However the
possition of the button doesn't seems very logical to me. The button
works from downunder to upwards. Is there a way to have it the other way
around? Please see attachement to understand my question.

Cheers,

Jun


+-------------------------------------------------------------------+
Filename: data group.JPG |
Download: http://www.excelbanter.com/attachment.php?attachmentid=357|
+-------------------------------------------------------------------+

Did you try to change the 'summary' rows/cols options in the 'Settings'
dialog and it doesn't work? Or are you just asking how to change the
Summary row/col options? If the latter, clear the checkbox[es]!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I was having the same problem but I think I found a solution. Within the same worksheet you're working in, create a small set of data at the bottom that you will be deleting. It doesn't matter what you put, just make sure it's a few cells (like a 4x4 or something).

Select the cells and click on the "Subtotal" button under Outline: Data. The only option you need to change is unclick the "Summary below data" option. Click okay. Now delete the rows you put the data in. The setting should now apply for your whole worksheet. All you have to do is un-group and re-group your original groupings and the plus sign should now be at the top of your list.

Hope this works!