Menu
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:
https://www.youtube.com/watch?v=CBJY83PTiXs
581
We can use a Pivot Table to create collapsible rows. ➤ Here, to create a pivot table, first, we have to select the entire dataset. ➤ After that, we will select Insert > Pivot Table.
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. Thanks for contributing an answer to Stack Overflow!
Go to the column that holds the parent/children and at the top right click and you will see the collapse/expand all options Select the rows ---> Go to Data ---->Go to group tab at extreame right---> click on Group from the drop down Hit crtl+8 to hide the collapse buttons Hit crtl+8 to hide the collapse buttons.
Hit crtl+8 to hide the collapse buttons If we do not have a Pivot table, we can also collapse rows in Excel by selecting any cell in the group Number of Rows A file selection dialog will appear See below See below.
A much easier way is to go to Data and select Group or Subtotal. Instant collapsible rows without messing with pivot tables or VBA.
129
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
