Link to home
Start Free TrialLog in
Avatar of daisypetals313
daisypetals313Flag for United States of America

asked on

Easy way to show 3 groupings in Excel

I have three sets of grouping on my sample file attached.  If I click 1or 2 (at top right) then either all groups expand or close up.  Is there a way to have numbers 1, 2, 3 up top and clicking on each number will expand just one of the sections?
Book1.xlsx
Avatar of NBVC
NBVC
Flag of Canada image

I don't think so, but you can easily just click the + sign above the group you want to expand, then click the - sign to contract it...
Just like he said, but you could build a macro that would expand / collapse the currently selected group and code it to buttons marked 1, 2, and 3.

Thomas
Avatar of daisypetals313

ASKER

Does anyone know what macro code would do this?
ASKER CERTIFIED SOLUTION
Avatar of nutsch
nutsch
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Add a vba button and use the above code
Thank you.