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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rgonzo1971Commented:
Hi,

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

each group
you can then click on the "-"

Regards
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.