Share via

Simple Expand/Collapse Spreadsheet Rows

Anonymous
2020-04-22T14:11:53+00:00

Is there a simple way in Excel, to make a bunch of sub-lines have the same expand/collapse feature that simply indenting a task does wen working in MS Project?  For instance, in project, the below image would have a little triangle at the "Item 1" line, where you can click to show or hide the Task A-G lines.  How can I achieve the same function with Excel?

Task Name
Item 1
Task A
Task B
Task C
Task D
Task E
Task F
Task G
Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2020-04-22T14:56:51+00:00

    You can use the Group feature.

    Activate the Data tab of the ribbon.

    Select the rows of Task A to Task G.

    In the Outline group, click Group.

    Repeat for other sub-line groups.

    100+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-04-22T22:11:48+00:00

    Hi postingnow,

    You can follow the suggestion provided by HansV, you can create an outline of up to eight levels to quickly display summary rows or columns. For your reference: Outline (group) data in a worksheet

    Please don’t hesitate to come back if you need further assistance, we will be here for you.

    Regards,

    Ivy

    1 person found this answer helpful.
    0 comments