In Excel for Microsoft 365 on Windows, select the grouped columns and press Alt+Shift+Left Arrow to ungroup them. This removes the outline grouping, not the data; if the shortcut does not work, use Data > Outline > Ungroup.
The Excel shortcut and what it applies to
The Windows shortcut for ungrouping rows or columns is Alt+Shift+Left Arrow. It acts on the selected outline group. To target columns reliably, select their column letters—the headers at the top of the worksheet—before pressing the keys. For example, if columns D through F are grouped, select the D, E, and F headers, then use the shortcut.
Excel uses a related shortcut for the opposite action: Alt+Shift+Right Arrow groups the selected rows or columns. The left arrow removes a group; the right arrow creates one. These shortcuts apply to worksheet outlining, not to deleting columns or clearing their contents.
If you select cells rather than entire column headers, Excel may still identify the group, but the result can depend on the selection and the outline structure. When Excel needs to know whether you mean rows or columns, it may show an Ungroup dialog. Selecting the column headers first makes your intention clearer and is a useful first step when troubleshooting.
How to ungroup columns step by step
- If the columns are collapsed, expand the outline group first. Click the plus sign above the grouped columns, or use an outline level button to show the relevant detail.
- Select the headers of the columns that belong to the group. For a group spanning D through F, drag across the D, E, and F column letters.
- Press Alt+Shift+Left Arrow. If Excel asks whether to ungroup rows or columns, choose Columns.
- Check the outline controls above the worksheet. The grouping bracket or its plus/minus control for that group should be removed. If another outline level remains, repeat for that level as needed.
You can do the same operation from the ribbon: select the grouped columns, open Data > Outline > Ungroup, and choose Columns if Excel asks. This menu path is a good fallback if a keyboard layout, remote desktop, or another application intercepts the shortcut.
What ungrouping changes—and what it does not
Excel’s Group feature creates an outline: a way to collapse and expand related rows or columns. A grouped set of columns can be hidden temporarily behind an outline control, so a worksheet can show a summary while keeping its detail available. Ungrouping removes the outline relationship. It does not erase values, formulas, formatting, or the columns themselves.
Grouping is different from manually hiding columns. If you hide columns with a context-menu command or through the ribbon, there may be no outline bracket to remove. In that case, ungrouping is not the right fix; select the neighboring column headers, right-click, and choose Unhide, or use Home > Format > Hide & Unhide > Unhide Columns. A missing column can also be caused by a very narrow column width, so check the boundary between its neighboring headers.
Ungrouping is also different from deleting a group’s data. It should not remove the contents of the selected columns. If your goal is to remove the values, formulas, or formatting, use the appropriate clear or delete command instead—and verify the selection before doing so.
Collapsed groups, selection, and outline levels
A collapsed group hides its detail columns from view, which can make selecting the precise headers difficult. Expand the group before selecting it, especially when you want to remove only one group from a worksheet with several outline sections. The plus and minus controls change what is displayed; they do not themselves create or remove the grouping.
The numbered outline buttons, often labeled 1, 2, and so on, display different levels of detail. Clicking a number is a quick way to show more or less of the outline, but it does not ungroup columns. For example, clicking level 1 may display only summary columns while leaving all groups intact. Use Ungroup when the outline structure itself should go away.
Excel permits nested groups. For instance, columns C:G might form a broad group, while D:E are grouped as a smaller detail set inside it. Removing one outline level may leave the other level and its controls in place. If you still see a bracket after ungrouping, inspect the outline and remove the remaining group separately rather than assuming the first shortcut failed.
Why the shortcut may appear not to work
Most apparent failures come from selection or from confusing a hidden range with an outline group. Before trying the shortcut repeatedly, look for the outline bracket and the plus/minus controls above the column headings. If there are no outline symbols, the columns may be hidden manually or the worksheet may not contain a group to ungroup.
- The wrong area is selected: Select the column headers belonging to the group, then try again. A cell selection elsewhere on the sheet will not target the intended columns.
- The group is collapsed: Expand it first so you can select the relevant headers. Then ungroup the intended range.
- You are changing the display level: Clicking 1 or 2, or using plus/minus controls, expands or collapses the outline; it does not remove it.
- The columns were hidden manually: Use Unhide Columns rather than Ungroup.
- The worksheet is protected: Protection can restrict structural changes. If you are authorized to edit the sheet, check Review > Unprotect Sheet; a password may be required.
- The keyboard intercepts the key combination: Use Data > Outline > Ungroup instead. Laptop function layers, remote-access software, and keyboard layouts can affect key combinations.
If you are uncertain whether the worksheet contains a group, inspect the Data tab’s Outline controls and the area above the column letters. Do not use Delete as a substitute: it can remove worksheet content or structure, while Ungroup is intended to remove the outline level.
Keyboard shortcut versus the ribbon
The shortcut is quickest when you already know which grouped columns are selected. The ribbon is easier to discover and can be clearer when Excel needs a Rows-or-Columns choice. Both routes perform the same ungrouping operation; neither one deletes the selected columns’ contents.
For a one-off change, the ribbon is often the safer route because it lets you see the command name before applying it. For repeated outline cleanup, the shortcut saves navigation. If the selection includes a mixture of rows and columns or only part of a nested outline, pause and verify the intended target before confirming a dialog.
Excel for Mac and Excel for the web
In Excel for Mac, the corresponding ungroup shortcut is generally Option+Shift+Left Arrow. Keyboard behavior can vary with the keyboard layout and macOS settings, so the dependable fallback is to select the grouped column headers and use Data > Ungroup on the ribbon. The Windows Alt-key combination is not the Mac equivalent.
Excel for the web can have different shortcut handling depending on the browser and keyboard configuration. If the key combination is intercepted or does not produce the expected result, select the columns and use the Data tab’s Ungroup command if it is available in the current interface. In either version, first determine whether the columns are grouped or simply hidden; the correct command depends on that distinction.
Frequently Asked Questions
What is the keyboard shortcut to ungroup columns in Excel?
In Excel for Microsoft 365 on Windows, select the grouped columns and press Alt+Shift+Left Arrow. On Mac, use Option+Shift+Left Arrow where supported, or choose the Ungroup command from the Data tab.
Does ungrouping columns delete their data?
No. Ungrouping removes the outline grouping; it does not delete the columns or their cell contents. Use a delete or clear command only if removing worksheet data is actually your goal.
Why are my columns still hidden after I try to ungroup them?
They may have been hidden manually rather than grouped, or another outline level may remain. Check for outline brackets and expand the group. If there are no outline controls, use Unhide Columns from the column-header context menu or the Home tab.
How do I ungroup only one section of columns?
Expand the outline, select the headers for the specific grouped section, and use the shortcut or Data > Outline > Ungroup. In a nested outline, check which bracket disappears; you may need to remove another level separately.
Does clicking the plus sign ungroup columns?
No. The plus sign expands a collapsed group so its columns become visible. To remove the group structure, select the columns and use Ungroup.
Can I use the same shortcut to ungroup rows?
Yes. Alt+Shift+Left Arrow also ungroups selected row groups in Windows Excel. Select the relevant row headers to target rows, or choose Rows if Excel presents an Ungroup dialog.
Related
- Excel Find Maximum Value Based on Criteria with MAXIFS
- Excel Find Hidden Names: Locate, Review, and Manage Them
- Excel Find Max Value Based on Criteria in Your Data
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Microsoft Word Monthly Budget Template: Make or Find OneYes. To find a Microsoft Word monthly budget template, open Word, choose File > New, and search for…
- Join Two Sheets in Google Sheets: Methods That WorkTo join two sheets in Google Sheets, decide whether you need to stack their rows, match records using…
- How to Indent and Double Space in WordTo indent and double-space text in Microsoft Word, select the paragraphs, open Home > Line and Paragraph Spacing…
- Google Sheets European Date Format: Set It CorrectlyTo use a European-style date in Google Sheets, set the spreadsheet’s region under File > Settings > General…
- How to Make a Flowchart in WordThe easiest way to make a flowchart in Word is to insert flowchart shapes, label them, and join…
- Import CSV to Outlook: Contacts, Steps, and TroubleshootingYes. To import a CSV contact list into Outlook, open People or Contacts and choose Manage contacts >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.