Collapsing/Expanding Columns

  • Thread starter Thread starter kremlap
  • Start date Start date
K

kremlap

Is it possible to use the subtotal (or another tactic) to collapse an
expand columns with buttons. I used Data/Subtotal to collapse rows an
then deleted the unnecessary total rows, but I can't get it wit
columns. Any help is appreciated.

Thanks
~kremla
 
Hi kremlap

Sure. Select any row(s) or column(s) and go menu
Data > Group and outline > Group.

....and it's Ungroup to set things back to normal. And groups can contain groups, if you
want a hierarchy.
 
Back
Top