Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create levels in excel without subtotaling
I have text in a spreedsheet we are using to organize a project. I want to
use the functionality of being able to roll up and unroll rows as we've all seen with the subtotal function, but I don't need any total lines, just wand the + and - buttons in key places so I can roll and unroll certain rows. Can this be done? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create levels in excel without subtotaling
select the rows you want to group then go to Data-Group and Outline and
select Group -- -John Please rate when your question is answered to help us and others know what is helpful. "Aaron" wrote: I have text in a spreedsheet we are using to organize a project. I want to use the functionality of being able to roll up and unroll rows as we've all seen with the subtotal function, but I don't need any total lines, just wand the + and - buttons in key places so I can roll and unroll certain rows. Can this be done? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create levels in excel without subtotaling
you can "fake" it by inserting a column and putting the same number by the
ones you want to group, then do a subtotal on that column. "Aaron" wrote: I have text in a spreedsheet we are using to organize a project. I want to use the functionality of being able to roll up and unroll rows as we've all seen with the subtotal function, but I don't need any total lines, just wand the + and - buttons in key places so I can roll and unroll certain rows. Can this be done? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create levels in excel without subtotaling
wow, i didn't know excel could do that...
"John Bundy" wrote: select the rows you want to group then go to Data-Group and Outline and select Group -- -John Please rate when your question is answered to help us and others know what is helpful. "Aaron" wrote: I have text in a spreedsheet we are using to organize a project. I want to use the functionality of being able to roll up and unroll rows as we've all seen with the subtotal function, but I don't need any total lines, just wand the + and - buttons in key places so I can roll and unroll certain rows. Can this be done? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create levels in excel without subtotaling
If you do this quite a bit (like I do).....
Here are some keyboard shortcuts: [Alt]+[space]......selects entire rows [Ctrl]+[space]......selects entire columns [Alt]+[Shift]+[right arrow]....demotes the row or col down in the Group [Alt]+[Shift]+[left arrow]......promotes the row or col up in the Group Is that something you can work with? *********** Regards, Ron XL2003, WinXP "Aaron" wrote: I have text in a spreedsheet we are using to organize a project. I want to use the functionality of being able to roll up and unroll rows as we've all seen with the subtotal function, but I don't need any total lines, just wand the + and - buttons in key places so I can roll and unroll certain rows. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotaling pages in excel | Excel Discussion (Misc queries) | |||
Is anyone having problems with nested subtotaling in XP Excel | Excel Discussion (Misc queries) | |||
How do I create a formula for multiple levels of discounts? | Excel Worksheet Functions | |||
When subtotaling can Excel also calculate percentages | Excel Worksheet Functions | |||
How do I create an "IF" statement with more than 7 levels? | Excel Worksheet Functions |