Forum Discussion
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 ...
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)