Excel Create Collapsible Indented Row Hierarchies

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.