Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Under data/Group&outline/group | Excel Discussion (Misc queries) | |||
Group under Data Group and Outline Data not working. Help. | Excel Worksheet Functions | |||
Outline/group data below | Excel Worksheet Functions | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
Data And Group Outline | Excel Worksheet Functions |