Excel Groups Help

Copper Contributor

Hello, I'm looking for a help with my project. I also recorded a video, which shows a complete table, what I would like to achieve, but in excel. Would be glad if someone could help me making it. Or send me an excel which does have this built-in. I would like to make these tables expandable, but the best would be, if the + or - icon would be next to the name of the table, just like in pivot table, if you have more data in rows. Link to the video: https://streamable.com/rnkk2b

1 Reply
What you show in that video would require extensive VBA coding to completely replicate. If you just want to be able to expand and collapse sections you can use the OUTLINE tools and GROUP lines. If you don't have/see these button you can add them in the customize ribbon options but I believe the shortcut key to Group is SHIFT-ALT-RIGHT arrow. highlight all the lines of the table and try it. (SHIFT-ALT-LEFT to ungroup)