Grouping columns lets you collapse and expand related data without deleting it

Column grouping in Excel hides multiple columns behind a single collapse button, so you can show only the data you need to see right now. When you group columns, Excel adds a small minus sign (−) above or to the left of your grouped columns. Click that button and the columns fold away. Click the plus sign (+) that appears and they come back. The original data stays intact — you are just controlling what is visible on screen.

This is useful when you have many columns of related information. For example, if you track sales by month across a year, you might group all the January columns together, all the February columns together, and so on. Or if you have quarterly breakdowns within each month, you can create nested groups so you can collapse by quarter first, then by month within each quarter.

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, click Group, and choose Columns from the dropdown to create the grouping.
  • Excel adds outline buttons (+ and −) to the left of your columns that let you collapse and expand the group with one click.
  • You can create nested groups by grouping columns within already-grouped columns, and Excel will show numbered outline levels so you can collapse to any level at once.
  • To remove a group, select the grouped columns again, go to Data > Ungroup, and choose Columns.

Select the columns you want to group

Click on the column header of the first column in your group. The entire column highlights. Then hold Shift and click the column header of the last column you want to include. All columns from the first to the last are now selected, shown by the blue highlight across all their headers.

If your columns are not adjacent — for example, you want to group columns A, C, and E but not B and D — you cannot group them as one unit. Grouping only works on columns that sit next to each other. If you need to hide non-adjacent columns, you can hide them individually instead (right-click a column header and choose Hide), but that does not create the collapse buttons that grouping does.

Open the Group dialog from the Data menu

With your columns selected, click the Data menu at the top of the screen. Look for the word Group in the menu. Click it. A small submenu appears with two options: Group and Ungroup. Click Group.

Excel when ready adds outline buttons to the left side of your spreadsheet. You will see a small minus sign (−) button positioned above your grouped columns. The columns themselves do not move or change — only the control buttons appear.

Use the collapse and expand buttons

Click the minus sign (−) button to collapse your grouped columns. They fold away and a plus sign (+) appears in their place. The rest of your spreadsheet shifts left to fill the space, and you see only the columns outside the group.

Click the plus sign (+) to expand the group again and see all the columns you hid. You can collapse and expand as many times as you want without affecting the data. The grouping stays in place until you remove it.

Create nested groups for more control

If you have many columns, you can group columns within columns. For example, suppose you have 12 columns of monthly sales data, with three columns for each quarter (Jan, Feb, Mar for Q1; Apr, May, Jun for Q2, and so on). You could first group Jan-Mar together, Apr-Jun together, Jul-Sep together, and Oct-Dec together. Then you could select all 12 columns and group them again as a single larger group.

When you create nested groups, Excel adds numbered outline levels on the left side of your spreadsheet: 1, 2, 3, and so on. Click the number 1 button and all groups collapse at once, showing only the outermost group buttons. Click 2 and the first level of groups expands, showing the second-level groups. This lets you zoom in and out of your data structure without collapsing and expanding each group individually.

To create a nested group, first create your smallest groups (like the monthly groups). Then select a range that includes multiple already-grouped columns and group that range too. Excel recognizes the existing groups and nests the new group around them.

Remove grouping when you no longer need it

Select the grouped columns again by clicking the first column header, holding Shift, and clicking the last column header. Go to Data > Ungroup > Columns. The outline buttons disappear and the columns return to normal. If you have nested groups, you may need to ungroup multiple times — start with the outermost group and work inward.

Ungrouping does not delete or hide your columns. It only removes the collapse buttons. All your data remains exactly as it was.

When grouping columns is better than hiding them

Hiding columns (right-click a column header and choose Hide) removes them from view but does not add collapse buttons. You have to remember which columns are hidden and manually unhide them one at a time if you need them back. Grouping is faster when you regularly switch between seeing and hiding the same set of columns, because the buttons are always visible and you can toggle with one click.

Grouping is also clearer for other people reading your spreadsheet. When someone sees the outline buttons, they when ready understand that columns can be collapsed. A hidden column leaves no visual clue that data is missing from view.

Frequently Asked Questions

Can I group rows the same way I group columns?

Yes. Select the rows you want to group by clicking the row number of the first row, holding Shift, and clicking the row number of the last row. Then go to Data > Group > Rows. The same collapse and expand buttons appear on the left side of your spreadsheet, and you can create nested row groups the same way.

What if I group columns but then want to add a new column in the middle of the group?

Right-click between two column headers where you want the new column to go and choose Insert. Excel inserts a blank column and automatically includes it in the existing group. The grouping adjusts to include the new column without you having to regroup.

Can I print my spreadsheet with the groups collapsed?

Yes. Collapse the groups the way you want them to appear, then print. Excel prints only the columns that are currently visible. If you expand the groups later, the next print will show all columns again unless you collapse them before printing.

Do I lose the grouping if I save and close the file?

No. Grouping is saved as part of your spreadsheet file. When you reopen the file, the grouping buttons are still there in the same state you left them — either collapsed or expanded.