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?

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?

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?

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?

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?