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
Book1.xlsx
Microsoft Excel
Last Comment
daisypetals313
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
Thomas
ASKER
Does anyone know what macro code would do this?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Add a vba button and use the above code
ASKER
Thank you.