View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom Marvin P. Winterbottom is offline
external usenet poster
 
Posts: 34
Default 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?