Create levels in excel without subtotaling

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
Back
Top