Excel Column Grouping: How to Collapse Columns

How-to basics · Updated November 18, 2026

To group columns in Excel for Microsoft 365 on Windows, select the column letters you want to fold away, then choose Data > Group in the Outline section. Click the minus sign above the columns to collapse them, or the plus sign to show them again. Grouping hides detail temporarily; it does not delete the columns or their contents.

What column grouping does

Column grouping adds outline controls to a worksheet so readers can show a compact view or expand it to inspect supporting detail. For example, a monthly report might keep a quarterly total visible while allowing the three monthly columns behind it to be collapsed. A minus button collapses a group; a plus button expands it. Numbered outline buttons, usually displayed at the upper-left of the worksheet near the column headings, let you show broader outline levels at once.

Grouping is a display and navigation feature, not a calculation tool. The data remains in the workbook, and formulas that refer to grouped columns continue to use those cells while the columns are collapsed. Grouping also does not combine columns, move data, or change the values in a calculation.

How to group columns step by step

  1. Select the columns to group by clicking the first column letter and dragging across the adjacent column letters. To select a range without dragging, click the first letter, hold Shift, and click the last letter. For example, select C through E to group columns C, D, and E.
  2. On the ribbon, choose Data > Group in the Outline section. If Excel displays a Group dialog, choose Columns and confirm.
  3. Look above the selected columns for the outline bracket and its minus button. Click the minus button to collapse the group.
  4. Click the plus button in the same area to expand the group and reveal the columns.

Another Windows method is to select the columns and press Alt+Shift+Right Arrow. To ungroup a selection, press Alt+Shift+Left Arrow. Keyboard shortcuts can be affected by keyboard layout or system settings. In Excel for Mac, the corresponding outline shortcuts are generally Option+Shift+Right Arrow to group and Option+Shift+Left Arrow to ungroup; if a shortcut is intercepted by macOS or does not work in your setup, use the Data ribbon commands instead. The ribbon command is also the clearest option when Excel asks whether the selection represents rows or columns.

Collapse, expand, and use outline levels

The plus and minus buttons control one group at a time. Click minus to hide the grouped columns, leaving the other worksheet columns in place; click plus to reveal the hidden columns again. When a worksheet has several groups, the numbered outline buttons control how much detail is displayed. A lower level shows a more summarized view, while a higher level reveals more detail. The exact appearance depends on how the groups are nested.

For example, suppose columns B through M contain a yearly report: B contains product names, C:E contain first-quarter months, F:H second-quarter months, I:K third-quarter months, and L:N fourth-quarter months. You could group the monthly columns within each quarter so each quarter can be collapsed separately. If the workbook also has an annual summary, you can create a larger, outer group to hide more detail at once. Excel supports up to eight outline levels, though a small number is usually easier for readers to understand.

To build nested groups, create the smaller, inner groups first, then group a wider range around them. In the example, group each quarter’s columns, then create an outer group if the layout calls for a broader summary view. Check the outline buttons after each step: a sensible structure should make it clear which columns will disappear when a particular minus sign is clicked.

Where summary columns should go

A useful outline keeps the summary outside the columns it hides. If a total is in column F and the detail is in C:E, grouping C:E allows the total to remain visible when those detail columns are collapsed. Excel’s outline settings include Summary columns to right of detail, which is selected by default in many installations. That setting tells Excel where to expect summary columns in relation to detail; it does not create totals or move data.

If your summary columns are to the left of the detail, review the setting before creating an outline. On Windows, open the Data tab and use the small dialog box launcher in the Outline section to open outline settings. Clear Summary columns to right of detail when the workbook’s layout requires summaries on the left. Choose the setting to match the actual worksheet structure, then create or adjust the groups. A well-placed summary remains visible and gives readers a useful reference while the supporting columns are hidden.

Grouping versus hiding columns

Grouping and hiding both remove columns from the current view, but they solve different problems. Hiding a column is a simple way to keep a particular field out of sight. Grouping adds an explicit, reusable expand-and-collapse control, making it more suitable for reports with several layers of detail or readers who need to switch between summary and detail views.

  • Use grouping when people will repeatedly switch between a compact report and its supporting columns, or when several related sections need their own controls.
  • Use Hide when you need to conceal a column temporarily and do not need an outline or multiple levels.
  • Use Freeze Panes when the problem is keeping headings or identifying columns visible while scrolling. Freezing panes does not collapse columns and is separate from grouping.

Neither hiding nor grouping is a security measure. A person with access to the workbook can generally expand a group or unhide columns. Do not use either feature to protect confidential information; use appropriate access controls and workbook-sharing practices instead.

Ungroup columns and remove an outline

To remove one group, select the columns in that group and choose Data > Ungroup. If Excel asks whether to ungroup rows or columns, choose Columns. The Ungroup command removes the outline relationship for the selected columns; it is different from clicking plus, which merely expands a group while leaving the outline in place.

To remove all outline groups from a worksheet, choose Data > Ungroup and use Clear Outline if that option is available in the menu. Clearing an outline is a broader action than ungrouping one selection, so use it only when you intend to remove the worksheet’s outline structure. If columns are still hidden after changing the outline, select the surrounding column headings, right-click, and choose Unhide to address visibility separately.

Common problems and practical fixes

  • The plus and minus buttons are missing. First confirm that the columns were grouped, rather than just hidden. On Windows, check File > Options > Advanced, find the display options for the current worksheet, and make sure Show outline symbols if an outline is applied is enabled. If the symbols are present but off-screen, scroll to the grouped columns.
  • Excel groups rows instead of columns. This can happen when the selection is ambiguous, such as a selection of cells rather than whole column headings. Select the column letters, repeat Data > Group, and choose Columns if the dialog appears.
  • The total disappears when detail is collapsed. Check whether the summary column is inside the group. A summary meant to stay visible should sit outside the detail columns being hidden. Also review the outline setting for summaries to the right or left of detail.
  • One click hides too much. The selection may have created a broader group than intended, or the outline may contain nested levels. Expand the outline, inspect the brackets, and ungroup the unwanted section before building the intended smaller groups.
  • A group will not collapse as expected. Check that the columns are actually part of the group and that outline symbols are enabled. Also consider whether another nested group is controlling the view; expand the relevant level and use the bracket associated with the precise range.

Excel for Mac uses the same general idea and has Group and Ungroup commands on the Data ribbon, though ribbon arrangement and shortcut behavior can vary by release. Excel for the web may present a more compact ribbon, so look on its Data tab for the grouping commands; if a desktop-only setting or shortcut is unavailable, use the web interface’s visible controls or open the workbook in the desktop app. The worksheet’s outline is part of the workbook, so it can be useful to save after setting up a layout that other readers will use.

Frequently Asked Questions

Can I group columns that are not next to each other?
For a clear outline, group a continuous range of columns. If the columns you want to fold are separated by other columns, create separate groups for the separate ranges rather than expecting one group control to hide a scattered selection as a single block.

Does grouping delete or change data?
No. Grouping changes which columns are displayed, not their stored values. When collapsed, the columns are hidden from view, and formulas that refer to them continue to calculate. It is still wise to save a workbook before making large layout changes.

Why can I see a plus or minus sign but not the hidden columns?
A plus sign means the group is collapsed. Click it to expand the group. If the columns remain absent, they may also have been hidden separately, or a different outline group may be controlling the visible range; expand the outline and check the column headings.

Can I group rows as well as columns?
Yes. Select the row numbers you want to group and choose Data > Group, selecting Rows if Excel asks. Row grouping uses the same outline concept but places its controls alongside the row headings rather than above the column headings.

Is column grouping the same as grouping items in a PivotTable?
No. Worksheet column grouping hides and reveals existing columns in an outline. PivotTable grouping combines items in a PivotTable field, such as dates or numeric ranges, to change how the PivotTable summarizes data. Choose the feature that matches whether you want to fold worksheet columns or reorganize PivotTable categories.

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.