Create levels in excel without subtotaling

A

Aaron

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?
 
J

John Bundy

select the rows you want to group then go to Data->Group and Outline and
select Group
 
M

Marvin P. Winterbottom

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.
 
M

Marvin P. Winterbottom

wow, i didn't know excel could do that...

John Bundy said:
select the rows you want to group then go to Data->Group and Outline and
select Group
Click to expand...
 
R

Ron Coderre

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
 
Top