I would like to create indented collapsible row hierarchies in Excel for my spreadsheet.
I have used group function but that becomes hard to manage for me.
Here is an example of what I am trying to create:
Create a Pivot Table. It has these features and many more.
If you are dead-set on doing this yourself then you could add shapes to the worksheet and use VBA to hide and unhide rows and columns on clicking the shapes.
A much easier way is to go to Data and select Group or Subtotal. Instant collapsible rows without messing with pivot tables or VBA.
Source: Stackoverflow.com