How to Collapse Columns in Excel

Q: Can I collapse multiple columns at once?

Yes. Select all the columns you want, then use Data → Group (or Alt+Shift+Right Arrow). Excel collapses the entire group with a single minus (−) button, so you don't have to do them one at a time. The earlier idea that Excel only collapses columns individually applies to manual hiding, not grouping.

Q: What's the difference between collapsing (grouping) and hiding columns?

Grouping adds a reversible outline with +/- buttons so you can toggle the columns in and out of view instantly, and the structure is remembered until you ungroup. Hiding simply removes the columns with no on-screen button — you have to select across the gap and choose Unhide to get them back. Grouping is the better choice when you'll show and hide the same columns repeatedly.

Q: How do I expand all collapsed columns at the same time?

Click the highest outline level number (usually 2 or 3) in the top-left corner of the outline area above the row numbers. That expands every group on the sheet at once, while clicking 1 collapses everything back to the summary level.

Q: How do I remove the +/- buttons entirely?

Select the grouped columns and choose Data → Ungroup, or use Data → Ungroup → Clear Outline to strip every group from the sheet. Ungrouping removes only the outline buttons — your data is untouched.

Q: Can I collapse rows the same way?

Yes. Select whole rows and use Data → Group just as you do with columns; the +/- buttons appear to the left of the row numbers. The same outline level buttons and settings apply. See our guides to grouping in Excel and hiding rows for more, and select an entire column if you're not sure how to highlight a full column or row first.

To collapse columns in Excel, select the columns, go to Data → Group (or press Alt+Shift+Right Arrow), then click the minus (−) outline button that appears above the column headers to collapse them; click the plus (+) to expand. This is true grouping, which is reversible and shows the familiar +/- buttons, unlike simply hiding columns.

If you’re working on a large spreadsheet in Microsoft Excel, you might sometimes find yourself wanting to simplify your view by collapsing certain columns. Collapsing columns can help you focus on the most important data while hiding the rest, giving you a clearer overview of your data. In this blog post, we’ll show you how to collapse columns in Excel in just a few simple steps.

Grouping vs. Hiding: What “Collapse” Really Means

There are two ways to make columns disappear from view, and they behave very differently:

Grouping (collapse with +/−): Select columns and use Data → Group. Excel adds an outline bar above the column letters with plus and minus buttons so you can collapse and expand the group with one click, as often as you like. The grouping itself is remembered until you ungroup.
Hiding: Right-click selected column headers and choose Hide. The columns vanish with no on-screen buttons, and the only clue is a thin double line between the surrounding column letters. To bring them back you must select across the gap and choose Unhide.

For collapsible, reversible columns that show the +/- buttons, you want grouping. If you just need columns gone with no outline, see our guide to hiding columns in Excel and unhiding a column.

How to Group and Collapse Columns (Step by Step)

Step 1: Select the columns to group

Click the first column letter, then drag across (or Shift+Click the last letter) to select all the columns you want to collapse together. You can also select multiple columns that aren’t adjacent, but a single group works best on a contiguous block.

Step 2: Group the columns

On the Data tab, click Group (in the Outline group), or use the keyboard shortcut:

Windows: Alt+Shift+Right Arrow
Mac: Command (⌘)+Shift+K

An outline bar with a minus (−) button appears just above the column headers.

Step 3: Collapse the group

Click the minus (−) button at the right edge of the grouped columns. The columns collapse out of view and the button changes to a plus (+).

Step 4: Expand the group again

Click the plus (+) button to expand the columns and reveal the data again. You can collapse and expand the same group as many times as you need.

The same commands work on any modern version of Excel, including Excel 2016, Excel 2019, Excel 2021, and Microsoft 365, on both Windows and Mac.

Using the Outline Level Buttons (1 and 2)

When you create one or more column groups, Excel adds small numbered buttons (1, 2, sometimes 3) in the top-left corner of the outline area, above the row numbers. These are the outline level buttons:

Click 1 to collapse everything down to the top summary level.
Click 2 to expand the next level of detail, and so on.

This lets you collapse or expand every group on the sheet at once instead of clicking each +/- button individually — handy when you have several column groups.

Nested Groups and Subtotals

You can put a group inside another group to create nested outline levels — for example, a broad group of “Q1–Q4” columns with smaller monthly groups inside each quarter. Select the inner columns and group them, then select the wider range and group again. Each nesting level gets its own +/- button and a higher outline level number.

Excel can also build outlines for you automatically:

Auto Outline: Go to Data → Group → Auto Outline. Excel inspects your formulas (such as totals that sum the columns to their left) and creates the +/- outline structure for you. It works best on data laid out consistently with summary columns or rows.
Subtotals: When you use Data → Subtotal, Excel inserts subtotal rows and automatically wraps them in a collapsible row outline so you can roll the detail up and down. See how to add subtotals in Excel and our deeper guide to the SUBTOTAL function.

How to Ungroup Columns

To remove the outline and the +/- buttons:

Select the grouped columns and click Data → Ungroup, or press Alt+Shift+Left Arrow (Windows) / Command (⌘)+Shift+J (Mac).
To clear every group on the sheet at once, choose Data → Ungroup → Clear Outline.

Ungrouping only removes the outline; it never deletes your data. For more detail, see how to ungroup in Excel.

Settings: Where the Summary Buttons Appear

By default, Excel places the +/- collapse buttons to the right of a column group (and below a row group), assuming your summary or total sits after the detail. If your totals sit on the left instead, you can flip this:

Go to the Data tab and click the small dialog launcher arrow in the corner of the Outline group.
In the Settings dialog, uncheck Summary columns to right of detail (and/or Summary rows below detail for rows).
Click OK.

The +/- buttons will then appear on the opposite side, lining up with where your summary columns actually are.

When to Collapse Columns in Excel

Collapsing columns is an excellent way to focus on specific data points on your Excel sheet and hide data you don’t necessarily need at the moment. One of the most practical applications of this function is when you’re dealing with a dataset that has many columns you don’t need to view regularly. For instance, an inventory management spreadsheet with countless product descriptions in a column can make analyzing product sales information challenging. By collapsing the description column, you can focus on the essential data metrics such as product name, sales volumes, and prices.

Customization and Expansion of Collapsed Columns

In Excel, collapsing a column doesn’t mean that column vanishes entirely. The data stays in the workbook and remains available to formulas. You can expand a collapsed group at any time by clicking its plus (+) button or one of the numbered outline level buttons, and the columns reappear exactly as they were.

If you grouped columns purely to tidy the view but later want them gone for good, you can also right-click and Hide them, or delete them — but grouping is the non-destructive choice when you simply want to toggle visibility.

Windows vs. Mac: Quick Reference

Action	Windows	Mac
Group columns	Alt+Shift+Right Arrow	Command (⌘)+Shift+K
Ungroup columns	Alt+Shift+Left Arrow	Command (⌘)+Shift+J
Group/Ungroup menu	Data → Group / Ungroup	Data → Group / Ungroup
Collapse / expand	Click − / + outline button	Click − / + outline button

The ribbon path (Data → Outline → Group) is identical on both platforms; only the keyboard shortcuts differ.

Troubleshooting

No +/- buttons appear after grouping. The outline symbols may be turned off. On Windows, go to File → Options → Advanced and, under “Display options for this worksheet,” check Show outline symbols if an outline is applied. (On Mac: Excel → Preferences → View.) You can also toggle them quickly with Ctrl+8.
The +/- button is on the wrong side. Adjust the outline Settings dialog as described above to match where your summary columns sit.
Group is greyed out. Make sure you’ve selected whole columns (click the column letters), and that the sheet isn’t protected. A protected sheet blocks grouping until you unprotect it.
You wanted columns gone, not collapsible. Grouping always leaves a toggle button. If you want them simply removed from view, use Hide instead.

Final Thoughts

Grouping and collapsing columns is a useful feature in Excel that can make it easier to navigate and analyze your data. It’s a quick, reversible process that can save you time and help you focus on the most important information on your worksheets. Pair it with freezing the top row or first column and adjusting column width for an even cleaner view.

Frequently Asked Questions

Can I collapse multiple columns at once?

Yes. Select all the columns you want, then use Data → Group (or Alt+Shift+Right Arrow). Excel collapses the entire group with a single minus (−) button, so you don’t have to do them one at a time. The earlier idea that Excel only collapses columns individually applies to manual hiding, not grouping.

What’s the difference between collapsing (grouping) and hiding columns?

Grouping adds a reversible outline with +/- buttons so you can toggle the columns in and out of view instantly, and the structure is remembered until you ungroup. Hiding simply removes the columns with no on-screen button — you have to select across the gap and choose Unhide to get them back. Grouping is the better choice when you’ll show and hide the same columns repeatedly.

Can I still reference data from a collapsed column?

Yes. Even when a group is collapsed, the data within those columns stays live. You can reference it in formulas, copy it, and the values continue to feed totals and charts exactly as before.

How do I expand all collapsed columns at the same time?

Click the highest outline level number (usually 2 or 3) in the top-left corner of the outline area above the row numbers. That expands every group on the sheet at once, while clicking 1 collapses everything back to the summary level.

How do I remove the +/- buttons entirely?

Select the grouped columns and choose Data → Ungroup, or use Data → Ungroup → Clear Outline to strip every group from the sheet. Ungrouping removes only the outline buttons — your data is untouched.

Can I collapse rows the same way?

Yes. Select whole rows and use Data → Group just as you do with columns; the +/- buttons appear to the left of the row numbers. The same outline level buttons and settings apply. See our guides to grouping in Excel and hiding rows for more, and select an entire column if you’re not sure how to highlight a full column or row first.