If Excel will not group columns, select the column headers you want to fold, then choose Data > Group; if the command is unavailable or an error appears, check whether the sheet is protected, multiple sheet tabs are selected, or merged cells cross the selection. Grouping creates an expandable outline, not a permanent change to the data, so you can usually fix the cause without moving or deleting anything.
What grouping columns does in Excel
Grouping columns adds an outline to a worksheet. Excel displays outline controls—typically a minus sign to collapse the selected columns and a plus sign to show them again—above the column letters. The columns remain in the workbook; collapsing a group hides them temporarily. This is different from deleting columns, hiding them individually with the column-header menu, or grouping items inside a PivotTable.
A practical example is a monthly report with detail columns D:F and a total in column G. You can group D:F so a reader can hide the detail and leave the total visible. You can also create several separate groups, such as one for each quarter, or nested groups when the worksheet has levels of detail. Excel supports up to eight outline levels for rows or columns.
Grouping is most useful when people need to switch between a compact overview and underlying detail. It does not calculate totals, change formulas, or make a workbook smaller. If the outline buttons seem to do nothing, verify that the columns were actually grouped and that the outline symbols are visible.
Group columns using the ribbon
On Excel for Microsoft 365 for Windows, use the column letters to make the selection clear. For example, to group D, E, and F, click the D column header and drag across to F, or select D and then Shift-click F. Then choose Data > Group in the Outline section of the ribbon. If Excel asks whether to group rows or columns, choose Columns.
- Save the workbook if you are making a substantial structural change.
- Select a continuous block of column headers. To make two independent groups, create each group separately rather than selecting both blocks at once.
- Choose Data > Group. If a Rows or Columns choice appears, select Columns.
- Use the minus control above the group to collapse it, and the plus control to expand it.
Windows also has a keyboard shortcut: select the columns and press Alt+Shift+Right Arrow to group them. Alt+Shift+Left Arrow ungroups the selected outline level. If the shortcut is intercepted by Windows or another application, use the ribbon instead. In Excel for Mac, use Data > Group; keyboard shortcuts can vary with the keyboard layout and macOS settings, so the menu is the dependable route.
Excel normally places the outline controls above the column headers. If the selected range includes a total or summary column, check that the summary column is outside the detail selection when you want it to remain visible after collapsing the group.
Why the Group command is unavailable
A gray Group command usually means Excel cannot apply the requested change in the workbook’s current state. Check these common causes first:
- The worksheet is protected. Protection can prevent changes to worksheet structure and outlines. See the next section before trying to group again.
- Several worksheets are selected as a group. When multiple tabs are selected, Excel applies some changes to several sheets at once and disables other commands. Right-click a selected sheet tab and choose Ungroup Sheets, then try on one worksheet.
- You are editing a cell. If a cell is in edit mode, press Enter to accept the edit or Esc to cancel it, then select the column headers again.
- The selection is not the intended columns. Selecting a few cells can make Excel infer whether you mean rows or columns. Selecting the column letters is clearer, especially when a prompt appears.
- The workbook is in a restricted or unusual state. For example, you may be viewing a protected sheet or working in a file where editing is restricted. Check the workbook’s status and ask its owner if you do not have permission.
If the command is available but Excel reports that it cannot create an outline, inspect the selected area for merged cells and existing outline levels. Try a smaller, simple block of ordinary columns in a copy of the workbook. That test helps distinguish a selection-specific problem from a workbook-wide restriction.
Check worksheet protection and permissions
To see whether protection is active, open the Review tab. If the command reads Unprotect Sheet, the worksheet is protected; choose it and supply the password if you are authorized to do so. If the command instead reads Protect Sheet, that is an indication the sheet is not currently protected. After unprotecting, select the columns and use Data > Group again.
Unprotecting a sheet requires the password when one was set. If you do not know it, ask the workbook owner or administrator for access. Do not assume that saving a new copy removes protection: a copy can preserve the same worksheet restrictions. In a shared work setting, it may also be better to request a permitted version than to alter a controlled reporting file.
Workbook structure protection and worksheet protection are separate. Protecting workbook structure is intended to restrict actions such as adding, deleting, moving, hiding, or renaming sheets; it is not the same as protecting cells on one sheet. If the issue concerns the sheet’s outline, check the Review tab for sheet protection first, and then confirm with the owner whether workbook-level restrictions also apply.
Merged cells, tables, and selection boundaries
Merged cells can make outlining less predictable, particularly when a merged area spans the boundary between columns you want to group and columns you want to leave visible. For example, a heading merged across C:G overlaps a proposed group of D:F. If the outline command fails, try the operation on a copy after checking whether merged areas cross the group boundary. Unmerging can affect the worksheet’s layout, and the text in a merged area is generally retained in its upper-left cell, so do not unmerge a production sheet casually.
Groups should represent contiguous blocks. If you want to fold D:F and H:J, make one group for D:F and another for H:J. A single selection that includes G would also include that column in the outline. This matters if G contains a total or a label that needs to stay visible.
An Excel table and a worksheet outline are different features. A table provides structured data, headers, and filtering; grouping hides worksheet columns with outline controls. Do not confuse the table’s filter arrows with outline buttons. If you are working with PivotTable fields, grouping items such as dates or numeric ranges is a PivotTable operation, not the same as grouping the worksheet columns that happen to contain the PivotTable.
Existing outlines and missing controls
A worksheet may already contain groups, perhaps created by another person or imported with the workbook. Clicking a minus sign collapses a group; it does not create one. To inspect the current structure, look for numbered outline-level buttons and plus or minus symbols above the column letters. If there are nested groups, collapse or expand them one level at a time to identify which columns belong together.
If a group appears to exist but its controls are missing, confirm that outline symbols are enabled for the worksheet. In Windows Excel, open File > Options > Advanced, find Display options for this worksheet, and check Show outline symbols if an outline is applied. The setting is worksheet-specific, so verify that the correct sheet is selected when you inspect it.
To remove a group, select its columns and choose Data > Ungroup. If the sheet has several outline levels, Excel may remove only the selected level; inspect the remaining controls and repeat only if needed. Data > Clear Outline removes the outline structure from the worksheet, so use it only when you intend to clear all groups rather than adjust one block.
Excel for the web and Mac differences
In Excel for the web, grouping and expanding outlined rows or columns are available in supported workbooks, but the ribbon layout and available controls can differ from desktop Excel. Look on the Data tab for Group or Ungroup. If you do not see the command, check whether the workbook is in a view-only state, whether you have editing permission, and whether the worksheet is protected. Opening the workbook in the desktop app can help when the browser interface does not expose the control you need.
Excel for Mac also uses the Data tab’s Group and Ungroup commands. The exact ribbon arrangement can vary by version and window width, but the operation is the same: select the column headers, then group them from the Data tab. If a Windows keyboard shortcut does not work on a Mac, use the ribbon rather than assuming the shortcut is identical. Menu labels and protection prompts can differ slightly across platforms.
When to use a different approach
Grouping is not always the best way to make a sheet easier to read. Use ordinary Hide and Unhide commands when you want to hide a few columns without maintaining an outline. Use a table’s filters when the task is to show only records that meet criteria; filters hide rows of data rather than create collapsible column sections. For a PivotTable, use its field and layout controls to change the displayed detail.
For a report where readers need both a summary and optional detail, keep totals outside the grouped columns and label the outline clearly. For example, a note such as “Collapse to hide monthly detail” explains what the plus and minus controls do. Avoid relying on hidden columns for security: hiding or grouping is a display convenience, not a way to protect confidential information.
Frequently Asked Questions
Why is Group grayed out in Excel?
Common causes include sheet protection, multiple selected worksheet tabs, or an active cell edit. Exit edit mode, ungroup the sheet tabs, and check Review > Unprotect Sheet if you are authorized to change the sheet.
How do I group columns in Excel with a keyboard shortcut?
On Windows, select the column headers and press Alt+Shift+Right Arrow. To remove the selected grouping level, use Alt+Shift+Left Arrow. If a shortcut does not work on your system, use Data > Group or Data > Ungroup.
Why can’t I see the plus and minus buttons?
The columns might not be grouped, or outline symbols may be switched off for that worksheet. In Windows, check File > Options > Advanced > Display options for this worksheet and enable Show outline symbols if an outline is applied.
Does grouping columns hide or delete the data?
It hides the grouped columns when you collapse the outline; it does not delete their contents. Click the plus control to show them again. Grouping is not a security feature, because a user can expand the outline or otherwise reveal hidden data.
Can I group nonadjacent columns together?
A single outline group covers a continuous block. Create separate groups for separate blocks, such as D:F and H:J, if you need to collapse them independently. Selecting D:J would include the intervening columns as well.
Related
- How to Name a Print Range in Excel and Reuse It for Printing
- How to Name a Selected Range in Excel and Use It Easily
- Excel Shortcuts for Naming a Range and Managing Names
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Time Format for Milliseconds: Display and CalculateTo show milliseconds in Excel, select the time cells, press Ctrl+1, choose Number > Custom, and enter hh:mm:ss.000…
- How to Make a Brochure in Microsoft WordTo make a brochure in Microsoft Word, start with a brochure template or set a blank document to…
- Excel R1C1 Reference Style: How It WorksIn Excel, R1C1 is a cell-reference style that identifies a cell by its row number (R) and column…
- Excel Shortcut Keys: Essential Commands and How to Use ThemIn Microsoft Excel for Microsoft 365 on Windows, shortcut keys let you edit cells, move around a worksheet,…
- Google Sheets Currency Converter: Rates and FormulasTo convert currencies in Google Sheets, use GOOGLEFINANCE to get a rate, then multiply the amount by that…
- How to Double Space in Word for the WebTo double-space text in Word for the web, select the paragraphs you want to change, open Home >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.