Grouping columns lets you collapse related data and expand it when you need it

Column grouping in Excel is a feature that lets you bundle related columns together so you can hide or show them all at once with a single click. When you group columns, Excel adds a small minus sign (called a collapse button) above or to the left of your grouped columns. Click that button and the columns disappear from view. Click it again and they reappear. This is useful when you have a spreadsheet with many columns — say, monthly sales data for 12 months, or detailed budget breakdowns — and you want to focus on summary columns without scrolling past all the detail.

Grouping is different from straightforward hiding columns. When you hide columns manually, there's no button to toggle them back. With grouping, the toggle button stays visible, making it straightforward to switch between detailed and summary views without leaving your spreadsheet.

Key Takeaways

  • Select the columns you want to group by clicking the column header of the first column, then holding Shift and clicking the last column header in the range.
  • Go to the Data menu, choose Group, and select Group Columns to create the grouping with a collapse button.
  • Click the minus button above the grouped columns to hide them, and click the plus button to show them again.
  • You can create multiple levels of grouping so that some columns collapse independently and others collapse together in a hierarchy.
  • Ungrouping removes the collapse buttons but does not delete any data from your spreadsheet.

How to select and group columns in three steps

Start by clicking the column header of the first column you want to group. The entire column will highlight. Then hold Shift and click the column header of the last column in the range you want to group. All columns from the first to the last will now be selected. If your columns are not adjacent — for example, you want to group columns A, B, and D but not C — you cannot group them in a single action. You would need to group A and B together, then group D separately, or reorganize your spreadsheet so related columns sit next to each other.

Once your columns are selected, open the Data menu at the top of the screen. Look for the option called Group (in newer versions of Excel it may say Group and Outline). Click Group, then select Group Columns from the dropdown. Excel will add a grouping control above your selected columns — you will see a horizontal line with a minus sign button and a small bracket showing which columns are grouped.

Test the grouping by clicking the minus button. Your grouped columns will disappear, and the minus button will change to a plus button. Click the plus button to bring them back. The data itself is not deleted or moved — it is only hidden from view.

Creating multiple levels of grouping for complex spreadsheets

If your spreadsheet has a natural hierarchy — for example, quarters that contain months, or regions that contain districts — you can create nested grouping levels. Start by grouping the smallest units first. If you have 12 months of data split into 4 quarters, group the 3 months in Q1 together, then the 3 months in Q2, and so on. Then select all 12 months and create a second grouping level for the entire year.

When you do this, Excel displays small numbered buttons (1, 2, 3, and so on) on the left side of your grouping controls. Click button 1 to collapse everything to the highest level. Click button 2 to expand one level down. This lets you move quickly between summary and detail views without clicking individual collapse buttons.

Each grouping level is independent. You can collapse the Q1 months while keeping Q2 months visible, or collapse the entire year while keeping individual months visible. This flexibility is what makes nested grouping powerful for large datasets.

When grouping columns makes sense versus other organization methods

Grouping works best when you have many columns of related data that you want to hide temporarily but may need to see again. Monthly sales data, quarterly budgets, or detailed product specifications are good examples. If you have only a few columns or if you rarely need to hide data, grouping adds complexity without much benefit.

If you need to permanently remove columns from view, hiding them (right-click the column header and select Hide) is simpler than grouping. If you need to reorganize your data so that related information appears together, sorting or using a pivot table might be more effective than grouping. Grouping is a viewing tool — it does not change the structure of your data, only what you see on screen.

How to remove grouping and restore your spreadsheet

To remove grouping, select the grouped columns again (the same way you selected them to create the grouping). Open the Data menu, choose Group, and select Ungroup. The collapse buttons disappear, but all your data remains exactly as it was. Ungrouping is safe and reversible — you can group the same columns again later if you change your mind.

If you have multiple levels of grouping and want to remove only one level, select just the columns in that level and ungroup. The other levels will remain in place. If you want to remove all grouping at once, select all columns in your spreadsheet (click the box at the top left corner where the row and column headers meet) and ungroup.

Grouping rows instead of columns

Excel also lets you group rows using the same method. Select the row numbers on the left side of your spreadsheet instead of column headers, then use Data > Group > Group Rows. This is useful when you have detailed line items that you want to collapse under category headers. For example, you might group individual expense items under department names, or group daily sales figures under weekly summaries.

Row grouping and column grouping work independently. You can group rows, columns, both, or neither in the same spreadsheet. The collapse buttons for rows appear on the left side, and the collapse buttons for columns appear at the top.

Frequently Asked Questions

Can I group non-adjacent columns?

No. Excel only lets you group columns that sit next to each other. If you need to group columns that are not adjacent, you would need to move them so they are next to each other, or create separate groupings for each set of adjacent columns.

Does grouping affect formulas or calculations?

No. Grouping only hides columns from view. Any formulas that reference those columns will continue to work whether the columns are visible or hidden. The data is still there and still being used in calculations.

What happens to grouping when I save and reopen the file?

Grouping is saved with your file. When you reopen the spreadsheet, the grouping controls will still be there, and the columns will be in the same state (expanded or collapsed) as when you saved.

Can I print a spreadsheet with grouped columns hidden?

Yes. When you print, Excel will print only the columns that are currently visible on screen. If you have grouped columns collapsed, they will not appear in the printed version. Make sure to expand any columns you want to include before printing.

Is there a keyboard shortcut for grouping?

There is no single keyboard shortcut that works across all versions of Excel. The menu path Data > Group > Group Columns is the most reliable method. Some users create custom shortcuts through Excel's options, but this requires setup in advance.