Excel Create Collapsible Indented Row Hierarchies

excel rows folding
user2533460 picture user2533460 · Jun 29, 2013 · Viewed 140.9k times · Source

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

Answer

Athlwulf picture Athlwulf · Aug 5, 2013

A much easier way is to go to Data and select Group or Subtotal. Instant collapsible rows without messing with pivot tables or VBA.

Related questions

Excel CSV. file with more than 1,048,576 rows of data

I have been given a CSV file with more than the MAX Excel can handle, and I really need to be able to see all the data. I understand and have tried the method of "splitting" it, but it doesnt …

Read More
Drag down formula and change ROW references instead of COLUMNS

In excel I have sheet1 contains total every month. (please see image below) Then in my sheet2 it will display horizontally. (please see image below) I used the formula =Sheet1!$B$1, my problem is when i drag it to the …

Read More
How to consolidate duplicates in Excel where several columns need to remain uncosolidated

I am trying to do a stock count through product stores but have several part numbers that are listed twice (Column A). When I try to consolidate these I recieve the error 'no data consolidated' which I think is caused …

Read More