What grouping columns does and when you need it

Grouping columns in Excel lets you collapse related columns under a single control so you can hide them all at once. When you group columns, Excel adds a small minus sign (called a collapse button) to the left of your grouped columns. Click that button and the columns disappear from view — click the plus sign that replaces it and they reappear. This is useful when you have many columns but only want to focus on a few at a time, or when you're sharing a spreadsheet and want to let someone see the summary without the detail columns cluttering the view.

The most common use is grouping expense categories (like separate columns for hotel, airfare, and meals) under a "Travel" section, or grouping monthly sales figures by quarter. You can also nest groups — group columns within groups — so collapsing one button hides multiple levels at once. This is especially helpful in financial reports where you might show totals by default but let readers drill down into the monthly or weekly breakdown.

Key Takeaways

  • Select the columns you want to group by clicking the column letter of the first column, then holding Shift and clicking the last column letter in the group.
  • Go to the Data tab in the ribbon, click Group, then choose Group Columns from the dropdown menu.
  • Excel adds collapse buttons (minus and plus signs) to the left of your grouped columns; click the minus to hide them and the plus to show them again.
  • You can create multiple separate groups in the same spreadsheet, and you can nest groups inside other groups for more control over what displays.
  • To ungroup columns, select them again, go to Data > Group, and choose Ungroup Columns.

Selecting the columns you want to group

Start by clicking the column letter (A, B, C, and so on) of the first column in your group. The entire column highlights in blue. Then hold down the Shift key and click the column letter of the last column you want to include in the group. All columns from the first to the last are now selected.

If your columns are not next to each other, you can select them one at a time by holding Ctrl (or Command on Mac) and clicking each column letter. However, grouping works best when columns are adjacent, so if you have the choice, arrange your data so related columns sit side by side. This makes the grouping more intuitive for anyone reading the spreadsheet later.

Creating the group using the Data menu

With your columns selected, look at the ribbon at the top of Excel and click the Data tab. In the Data tab, you'll see a button labeled Group (it usually has a small icon that looks like brackets). Click that button and a dropdown menu appears.

From the dropdown, select Group Columns. Excel immediately adds a grouping control to the left side of your selected columns — you'll see a horizontal line with a minus sign button. The columns stay visible; the grouping is now in place and ready to use. You can repeat this process to create as many separate groups as you need in the same spreadsheet.

Using the collapse and expand buttons

Once your columns are grouped, a minus sign button appears to the left of the group. Click that minus sign and the grouped columns collapse — they disappear from view, and the minus sign becomes a plus sign. The plus sign tells you there are hidden columns underneath.

Click the plus sign to expand the group again and see all the columns. If you have multiple groups in the same spreadsheet, you can collapse and expand them independently. This lets you focus on different parts of your data without affecting the rest of the sheet. For example, you might collapse expense details while keeping sales figures visible.

Creating nested groups for more control

You can group columns within groups. For example, you might have a "Sales" group containing columns for January, February, and March. Inside that, you could create a smaller group for "Q1 Summary" containing just the total column. When you collapse the outer group, all columns disappear. When you collapse only the inner group, the Q1 Summary column stays visible but the monthly detail columns hide.

To create nested groups, first create your main group as described above. Then select a subset of those columns and create a second group. Excel automatically nests them and adds numbered buttons (1, 2, 3) on the left side that let you jump between different levels of detail with a single click. The number 1 button hides everything; number 2 shows only the outer groups; number 3 shows everything. This is powerful for reports where executives want to see totals but analysts need access to the underlying detail.

Removing groups when you no longer need them

To ungroup columns, select the grouped columns again by clicking the first column letter, holding Shift, and clicking the last column letter. Go to the Data tab, click the Group button, and this time select Ungroup Columns. The grouping control disappears and your columns return to normal.

If you have nested groups and want to remove only the inner group while keeping the outer one, select just the inner group's columns and ungroup those. The outer group remains in place. You can also select all cells and ungroup everything at once if you want to start fresh.

Grouping rows instead of columns

Excel's grouping feature works the same way for rows as it does for columns. Select the row numbers on the left side (instead of column letters at the top), go to Data > Group, and choose Group Rows. This is often used to collapse detail rows under category headers, or to hide supporting calculations while showing only the final totals.

The collapse and expand buttons appear on the left side of the spreadsheet, and the workflow is identical to column grouping. Row grouping is especially useful in budget spreadsheets where you might have line items under each department, or in inventory sheets where you group products by category.

Frequently Asked Questions

Can I group non-adjacent columns?

You can select non-adjacent columns by holding Ctrl and clicking each column letter, but grouping works best when columns are next to each other. If you need to group columns that are far apart, consider rearranging your data first so related columns sit side by side.

What happens to my data when I collapse a group?

Nothing happens to your data — it's still there. Collapsing a group only hides the columns from view. When you expand the group again, the columns reappear exactly as they were. The data is never deleted or moved.

Can I save a spreadsheet with groups already collapsed?

Yes. When you save your file, Excel remembers which groups are collapsed and which are expanded. The next time you open the file, the groups will be in the same state you left them. This is useful if you want to share a spreadsheet with groups pre-collapsed so the recipient sees only the summary view.

How do I remove all groups at once?

Select all cells in your spreadsheet by pressing Ctrl+A (or Command+A on Mac). Go to Data > Group and choose Ungroup Columns. This removes all column groups. If you also have row groups, you'll need to ungroup those separately using the same method.

What's the difference between grouping and freezing columns?

Grouping hides columns temporarily and lets you expand them again. Freezing (View > Freeze Panes) keeps certain columns visible while you scroll through the rest of the spreadsheet. They serve different purposes — use grouping when you want to hide detail, and freezing when you want to keep headers or identifiers visible while scrolling.