How to create Expand and Collapse Rows in Excel

I would like to know if there is an option in Excel that can Expand and Collapse the rows. for instance if I want to create this document:

Task1
   * Details A
   * Details B
   * Details C
Task2
   * Details A
   * Details B
   * Details C

Something similar to way it is done in MS Project,
Thank you
jskfanAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

pls try to select each group of details and
Data / Outline / Group

each group
you can then click on the "-"

Regards
0
 
Rob HensonFinance AnalystCommented:
As RGonzo mentions, you can use the Group option from the Data/Outline feature.

This will involve grouping each set individually which if you have a lot of data could take some time. There is an option for Excel to try and create the Outline - Data/Group/Auto Outline but I've never had much luck with that.

One way round may be to use the Subtotal feature, this will group a table of sorted data after specifying a column in which to recognise the change. You will also need to specify a column on which to count or sum. The advantage with Subtotal is that it will also add the Grouping that you are looking for; the actual Subtotal formulas can be removed afterwards.

If your layout is as per the question with Task Header and Detail Line header in the same column, the data will need a tweak first; separating the Task header and Detail header into separate columns. You can then put the Task header against all rows and then use that as the change identifier and count for the Subtotal feature.

A dummy file will make easier to explain.
0
 
jskfanAuthor Commented:
Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.