Forum Discussion

Patrikos15782's avatar
Patrikos15782
Copper Contributor
May 24, 2023

Excel Groups Help

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

excel

1 Reply

  • mtarler's avatar
    mtarler
    Silver Contributor
    May 24, 2023
    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)

Resources