How to Make Collapsible Sections in Excel

Open the Collapsible Plan sheet. It contains three workstreams:

Select only the detail rows. For example, including row 10 in the Discovery group will cause its summary to disappear when you collapse the section.

Group rows 11:14, 16:19, and 21:24 so Discovery, Build, and Rollout can be collapsed independently while rows 10, 15, and 20 remain visible.

The workbook’s editable areas are:

• Review week: B2
• Task inputs: A11:H14, A16:H19, and A21:H24

Don’t overwrite B5:B8, G10:J10, G15:J15, G20:J20, or the formulas in columns I:J.

Each summary row in the workbook sits above its detail rows. Before creating the groups, adjust the outline options:

1. Open the Data tab.
2. In the Outline section, select the small dialog-box launcher.
3. Clear Summary rows below detail.
4. Select OK.

This setting positions the outline controls consistently with summary rows 10, 15, and 20. If Summary rows below detail remains selected, the summaries can still stay visible, but Excel associates the controls with the area below each group.

Microsoft explains these options in Outline (group) data in a worksheet.

Start by creating the Discovery group:

1. Select rows 11:14 by dragging across the row numbers on the left.
2. Open the Data tab.
3. Select Group > Group.
4. Choose Rows if Excel asks whether you want to group rows or columns.

An outline control should appear beside the selected rows. Select the minus button to collapse the group. Rows 11 through 14 should be hidden, while row 10 remains visible.

Next, select the plus button and confirm that all four detail rows return.

Repeat the process for the remaining workstreams:

• Group rows 16:19 for Build, leaving row 15 outside the group.
• Group rows 21:24 for Rollout, leaving row 20 outside the group.

To test the setup, collapse only rows 16:19. The Build details should disappear, while the Discovery and Rollout details remain expanded.

Be sure to create each group separately. Grouping rows 11:24 in one operation produces a single collapsible block instead of three independent sections.

Use each minus button to hide its detail rows. Because the summary rows remain visible, you can quickly decide which sections to open.

The supplied workbook has a recorded week-four reference state with:

• B6 = 2 tasks needing action
• J10 = 0 for Discovery
• J15 = 2 for Build
• J20 = 0 for Rollout

These are recorded calculation results from the complete Google Sheets fixture, not evidence of Microsoft Excel recalculation. You don’t need the arithmetic to create the row groups. After opening the downloaded file, confirm the displayed results in your Excel environment.

During a collapsed weekly review, B6 and the section counts in J10, J15, and J20 identify which workstreams need to be expanded.

When all sections are collapsed, rows 10, 15, and 20 should remain visible. The reference values point to Build as the section to expand because J15 contains the only nonzero section count.

Grouping doesn’t rewrite formulas or remove the underlying records. Instead, it marks the collapsed detail rows as hidden. As a result, formulas configured to ignore hidden rows can return different values.

Edit the review week in B2 and task inputs in A11:H14; the overall and Discovery summaries recalculate before the detail rows are collapsed.

If a summary row disappears, you probably included it in the group:

1. Expand the affected section.
2. Select all rows in the incorrect group.
3. Choose Data > Ungroup > Rows.
4. Select only the intended detail rows.
5. Choose Data > Group > Rows again.

For example, grouping rows 10:14 hides the Discovery summary. Ungroup that range, then recreate the group using rows 11:14.

The summary might remain visible even if the outline control appears below the details. In that case, return to the Outline settings and clear Summary rows below detail.

To remove a collapsible section without deleting its contents, select the grouped detail rows and choose Data > Ungroup > Rows. The outline control should disappear, while the cell values remain unchanged.

For groups you want to keep:

1. Save the workbook in Excel desktop for Windows.
2. Close the workbook.
3. Reopen the saved file.
4. Test each plus and minus button.

This process checks the grouping behavior in your Excel desktop environment. It isn’t a calculation test.

ModelMonkey can inspect spreadsheet context and help organize or change workbook content through natural-language instructions. You’ll still use Excel’s native outline command to create the collapsible row groups.

For this project plan, you could submit the following request:

On the Collapsible Plan sheet, check the task inputs in A11:H14, A16:H19, and A21:H24 for inconsistent status labels. Use only Done, In progress, Blocked, or Not started. Don’t change formula cells.

Where the workflow presents a preview, review the proposed edits before proceeding. You can then create or check the row groups in Excel using the ranges above.