Collapsing/Expanding Columns

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
 
H

Harald Staff

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
What determines collapsing of rows? 2
Unmatched rows 0
Prevent Collapsing of Pivot Table Rows 2
Collapse subtotals? 6
Excel pivot tables and SSAS 2
Pivot Table Expand Collapse not showing for Cube 2
Grouping will not work 1

Top