Group Rows and Columns in Excel: Steps, Outlines, and Fixes

How-to basics · Updated November 21, 2026

To group rows or columns in Excel for Microsoft 365 on Windows, select the adjacent row numbers or column letters, then choose Data > Outline > Group. Excel adds outline controls so you can collapse the selected detail and expand it again; grouping changes what is displayed, not the underlying values.

What grouping does in Excel

Grouping creates an outline around worksheet rows or columns. A small minus or plus button appears beside the grouped area: click the minus to hide its detail, or the plus to show it again. Numbered outline buttons, usually shown as 1, 2, and 3, switch between levels of detail. This is useful when a worksheet has information that readers need sometimes but do not need to see all at once.

For example, a monthly report might contain a heading, a subtotal, and several transaction rows for each department. You can group the transaction rows beneath each department, leaving the headings and subtotals visible when the details are collapsed. A budget worksheet might instead group columns for individual months so a reader can view quarterly totals without seeing every monthly column.

Grouping is not the same as adding or calculating a subtotal. It does not sum values, change formulas, or delete data. It only hides or reveals the rows or columns included in the outline. Save the workbook with the detail in the display state you want other people to see when they open it.

Group rows step by step

  1. Select the row headers for the adjacent rows you want to fold away. For example, click row 5, then drag down to row 10, or click row 5 and Shift-click row 10. Selecting the row numbers makes it clear that you are grouping whole rows.
  2. Open the Data tab, find the Outline group, and choose Group. If Excel asks whether to group Rows or Columns, choose Rows.
  3. Check the worksheet edge beside the selected rows. Excel should show a bracket and a minus button. Click the minus to collapse the group; click the plus that takes its place to expand it.

On Windows, Alt+Shift+Right Arrow groups the selected rows or columns. Alt+Shift+Left Arrow ungroups them. If the shortcut behaves differently because of your keyboard layout or system settings, use the ribbon command instead. In Excel for Mac, use Data > Group or Data > Ungroup; the exact ribbon presentation can vary by window size and Excel release.

Keep any title, heading, or total row outside the detail selection if you want it to remain visible after collapsing. For instance, to hide detail in rows 5 through 10 while keeping the total in row 11 visible, group rows 5 through 10 rather than rows 5 through 11.

Group columns step by step

Column grouping follows the same process, but select the column letters across the top of the sheet. To group columns C through F, click the C heading and drag through F, then choose Data > Outline > Group. If Excel displays a choice, select Columns. A bracket and plus or minus control will appear above the grouped columns.

This works well for detail columns that support a visible summary. A report could keep a Year Total column outside a group of monthly columns. Collapsing the months then leaves the annual figure available, while expanding them reveals the individual periods. Be careful to leave any column that should stay visible outside the selected range.

Rows and columns can both have outlines on the same worksheet. A report might group transaction rows within departments and also group monthly columns. Because those controls occupy the worksheet margins, a complicated outline can become hard to read; use clear labels and test the collapsed view before sharing the file.

Use outline controls to show the right detail

After grouping, click the minus sign beside a group to collapse it. Click the plus sign to reopen it. For a worksheet with several outline levels, the numbered buttons at the top-left or left edge show different levels. Level 1 shows the most summarized view; higher levels reveal progressively more detail. The precise number of levels depends on how many nested groups exist.

These controls apply to the whole outline level, not just one group. If a sheet has several department groups, clicking a level button can collapse or expand all groups at that level at once. Use an individual plus or minus control when you want to change only one department or section.

When a group is collapsed, its contents are hidden, not removed. Formulas elsewhere in the workbook can still refer to hidden cells, and the hidden values remain part of the sheet. If someone mistakes a collapsed section for missing data, remind them to look for the plus buttons or use the outline level controls.

Create nested groups and organize summaries

Nested groups let readers move from a broad summary to smaller sections and then to individual detail. For example, a yearly report can group each month’s transaction rows, then group the full set of monthly sections under a year. The inner groups provide month-level control; the outer group can hide the entire year’s detail. Build and test the levels gradually so the outline remains understandable.

Excel’s outline settings influence where summary rows and columns sit relative to detail. On Windows, open the Data tab and use the small dialog launcher in the Outline group to open the Settings dialog. The options include whether summary rows are below detail and whether summary columns are to the right of detail. Choose settings that match the layout before making an outline, especially if totals are above the data or summary columns are on the left.

Grouping alone does not create a hierarchy from labels or formulas. You select the sections to include, and Excel creates the outline controls. If the worksheet has a consistent list with totals, the Subtotal command may be a better starting point: it inserts summary rows and can create an outline for grouped data. Review the resulting layout, because Subtotal changes the worksheet by inserting calculated summary rows; it is not just a display toggle.

Grouping versus hiding rows or columns

Manual hiding is useful for a quick, one-off change. Select row or column headers, right-click, and choose Hide; use Unhide to bring them back. Hiding does not create the structured plus and minus controls that make an outline easy to navigate. It can be difficult for another person to notice that information is hidden.

Grouping is generally better when readers need to switch between a summary and detail repeatedly, or when a worksheet contains several related sections. It makes the hidden structure visible through outline brackets and controls. Neither method protects confidential information: hidden or grouped data remains in the workbook and may be revealed. Do not use grouping as a security measure; remove sensitive information or use appropriate file access controls instead.

Filtering is different again. A filter displays rows that meet chosen criteria and temporarily hides rows that do not. Grouping lets the reader collapse a selected section regardless of its cell values. A filtered list can be useful for finding records, while an outline is useful for navigating a report’s planned levels of detail.

Common problems and how to fix them

  • No plus or minus buttons appear: Confirm that the rows or columns were selected and that Data > Group was applied. Check Data > Outline > Show Outline Symbols if the symbols have been turned off. The groups may still exist even when their controls are not shown.
  • Excel groups the wrong direction: Select the row numbers or column letters, not an ambiguous block of cells. If a prompt appears, choose Rows or Columns to match your intention.
  • A summary row disappears with the detail: Ungroup the section and select only the detail rows, leaving the summary row outside the group. Also check the summary-position setting in the Outline Settings dialog.
  • There are too many brackets or outline levels: The sheet may contain nested groups or groups created earlier. Use Data > Ungroup for a selected section, or choose Clear Outline from the Outline commands to remove the entire outline and start over. Clear Outline removes the grouping structure, not the worksheet data.
  • Ungroup does not restore the expected view: Ungrouping removes outline structure; it is not the same action as expanding a collapsed group. Expand the group first if you simply want to see its rows, or use Ungroup if you want to remove the controls.

On Excel for the web, grouping support and the ribbon layout may differ from the Windows desktop application and can change as Microsoft updates the service. Look for Group and Ungroup on the Data tab. If the commands you need are unavailable in the browser, open the workbook in the desktop app. Avoid relying on a shortcut from another platform; use the visible ribbon command when the interface differs.

When to use automatic outlining or Subtotal

If data is arranged in a clear hierarchy, Excel may be able to create an outline automatically. On Windows, select the relevant range and choose Data > Outline > Group > Auto Outline. Excel looks for summary formulas and nearby detail to build groups. Results depend on how the worksheet is laid out, so inspect the outline and undo or clear it if it does not match the report structure.

For a list that needs a subtotal each time a category changes, sort the data by that category and consider Data > Outline > Subtotal. For example, a sales list sorted by department can use Subtotal to add a total at each department break and create an outline. This is distinct from manually grouping rows: Subtotal adds summary rows and calculations, while Group simply makes selected rows or columns collapsible.

Frequently Asked Questions

How do I group rows in Excel with a shortcut?
On Windows, select the row headers and press Alt+Shift+Right Arrow. To remove the group, select it and press Alt+Shift+Left Arrow. The Data tab’s Group and Ungroup commands are a reliable alternative when keyboard shortcuts are unavailable.

Can I group nonadjacent rows or columns?
One outline group covers a contiguous section, so nonadjacent selections cannot be treated as one continuous group. Create separate groups for separate sections. You can still collapse or expand each section independently.

How do I remove grouping without deleting data?
Select the grouped rows or columns and choose Data > Outline > Ungroup. To remove all outline groups on the worksheet, use Clear Outline. Both actions remove the grouping structure, not the underlying cell contents.

Why is a group plus sign missing in Excel?
The group may be expanded, its outline symbols may be hidden, or no group may have been created. Check the worksheet edge and the Show Outline Symbols command on the Data tab. Reapply Group to the intended row or column headers if necessary.

Does grouping hide information from other people?
No. It only collapses rows or columns in the worksheet display. Anyone with access to the workbook can expand the outline or otherwise reveal the data, so grouping should never be used to protect private or confidential information.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.