How to Group Columns in Excel: 7 Methods That Tidy Up a Wide Spreadsheet

Method 1: The Shift + Alt + Right Arrow Keyboard Shortcut

Click the header of the first column in the block, hold Shift, then click the header of the last column so the entire column range highlights. Press Shift + Alt + Right Arrow. Excel draws an outline bracket above the column letters along with the collapse control.

On a Mac, the equivalent shortcut is Command + Shift + K.

The same keys in reverse, Shift + Alt + Left Arrow, remove the grouping. This pairing is worth committing to memory because the same steps work on rows, which makes these shortcuts useful across almost any layout job.

Method 2: The Group Button on the Data Tab

The ribbon route does the same job and helps when a keyboard shortcut conflicts with other software on the machine.

1. Select the columns to group.
2. Open the Data tab.
3. In the Outline section on the far right, click the Group button.
4. Choose Group from the small dropdown if one appears.

The bracket appears above the selection, and the Outline section now also gives access to Ungroup, Subtotal, and the dialog launcher for outline settings.

Method 3: The Group Dialog Box

When the selection covers cells rather than an entire column, Excel asks which direction to group in. Highlight a range such as C4:F20, press Shift + Alt + Right Arrow, and a small dialog will pop up with two options: Rows and Columns.

Choose Columns and click OK. Excel expands the grouping to the full height of those columns.

This dialog is the usual culprit when someone groups a range and ends up with a bracket down the left side of the page instead of across the top. The default option is Rows, so it needs changing every time.

Method 4: Nested Groups for a Multi-Level Hierarchy

Excel supports up to eight levels of grouping, which suits reports where months roll into quarters and quarters roll into a year.

A budget sheet, for instance, often splits into two sections, income and costs, each with its own bracket sitting inside a wider annual one.

Build the hierarchy from the inside out. Select the three columns for January, February, and March and create one group. Repeat for each remaining quarter, and note that four separate brackets now sit side by side. Then select every column from January through December and group that whole span as the outer group. Excel stacks a second bracket above the first, and the level buttons numbered 1, 2, and 3 appear in the top-left corner of the sheet.

Those buttons switch between different levels instantly. Clicking 1 shows the top summary only, clicking 2 reveals quarters, and clicking 3 opens the lowest level so every detail column is visible again. For example, a sales sheet with two groups inside each region lets a manager focus on regional totals while an analyst can still expand specific sections and analyze the underlying figures.

Method 5: Auto Outline

Auto Outline builds the whole structure automatically, which is a real time saver on large datasets.

First, make sure summary formulas exist. Place a total column beside each block of detail columns, using something like =SUM(C2:E2). Then click any cell inside the dataset, open the Data tab, click the arrow beside Group, and select Auto Outline. Excel reads the formula patterns, works out which columns feed which totals, and creates every bracket in one pass.

Blocks with hand-typed totals get skipped, since there is no formula to follow. A blank column in the middle of the data can also break the sequence, so close any gaps before running it.

Method 6: Change Where the Collapse Button Sits

By default, Excel expects the summary column to sit to the right of the detail columns, which is why the plus and minus icons appear above the rightmost column in a group. Sheets built the other way round, with totals on the left, need the setting flipped.

Open the Data tab, click the small dialog launcher arrow in the corner of the Outline section, and clear the checkbox for Summary columns to right of detail. Click OK. Existing groups redraw with the controls on the opposite side.

The same dialog holds Automatic styles, which applies bold formatting to summary columns as groups are created.

Method 7: A Macro for Repeat Grouping

Anyone rebuilding the same layout every week can automate it. Press Alt + F11 to open the Visual Basic editor, choose Insert > Module, and paste the following:

Sub GroupQuarterColumns()
    Columns("C:E").Group
    Columns("F:H").Group
    Columns("I:K").Group
    Columns("L:N").Group
    ActiveSheet.Outline.ShowLevels ColumnLevels:=1
End Sub

Close the editor and run the macro from Developer > Macros, or assign it a shortcut key. The final line collapses everything to the top level so the file opens tidy. Save as a macro-enabled workbook (.XLSM) to keep the code.

Grouping Rows Uses the Same Steps

Everything above applies vertically as well. To group rows, select the row numbers and press Shift + Alt + Right Arrow, or use the Group button on the Data tab. Excel treats summary rows the same way it treats summary columns, placing the control beside the last of the detail rows unless the outline settings say otherwise.

Many people group rows based on a shared heading, such as a department name or a month, which turns a long list into a short set of headings that anyone can expand. To ungroup rows, select them and press Shift + Alt + Left Arrow.

Common Issues and Troubleshooting

The Group button is greyed out. The most frequent cause is an Excel Table. An outline cannot be applied within a table, so click any cell in the table, open the Table Design tab, and choose Convert to Range first. A protected worksheet produces the same result, in which case grouping needs to happen before protection is reapplied.

Rows got grouped instead of columns. The dialog defaults to Rows. Press Shift + Alt + Left Arrow to undo it, reselect, and pick Columns.

Outline symbols have vanished: Go to File > Options > Advanced, scroll to the worksheet display options, and tick Show outline symbols if an outline is applied. Some templates ship with this turned off, which hides the plus and minus icons even though the grouping is still there.

Removing every group at once: Open the Ungroup dropdown on the Data tab and choose Clear Outline. This strips all brackets from the sheet without touching the data.

Collapsed columns still appear in print - Collapsed columns count as hidden, so they are excluded from print output. Columns that print anyway are still expanded, so click level 1 first.

Copying only what is on screen - Copying across a collapsed group brings the hidden data with it. To copy the summary view alone, press F5, choose Special, and select Visible cells only before copying. The same trick works around hidden rows.

Grouping disappeared after saving. CSV files store values only, with no outline structure. Save as .XLSX to keep groups intact.

Excel refuses to add another level. Eight is the maximum. Anything deeper needs splitting across sheets.

Merged cells behave oddly. A merged header spanning a group boundary can block collapsing. Unmerge it, or centre the text across the selection instead.

Grouping compared with hiding: Hidden columns give no clue that data is missing, whereas a group leaves a visible control that anyone can expand. Grouping is the safer choice in a shared file, and it lets colleagues easily hide detail again when they are done.

Handling Group Columns Programmatically with IronXL

Manual grouping works well for a single report. Teams that generate hundreds of spreadsheets from a database, a website, or an internal portal usually want the outline applied automatically, and at that point a library takes over from the interface.

IronXL is a .NET Excel library that reads and writes workbooks without Microsoft Office installed on the machine, which suits web servers and scheduled reports. Grouping columns takes a single call:

using IronXL;

WorkBook workBook = WorkBook.Load("SalesReport.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Group the monthly detail columns C through E
workSheet.GroupColumns(2, 4);

workBook.SaveAs("SalesReport-Grouped.xlsx");

using IronXL;

WorkBook workBook = WorkBook.Load("SalesReport.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Group the monthly detail columns C through E
workSheet.GroupColumns(2, 4);

workBook.SaveAs("SalesReport-Grouped.xlsx");

Imports IronXL

Dim workBook As WorkBook = WorkBook.Load("SalesReport.xlsx")
Dim workSheet As WorkSheet = workBook.DefaultWorkSheet

' Group the monthly detail columns C through E
workSheet.GroupColumns(2, 4)

workBook.SaveAs("SalesReport-Grouped.xlsx")

The saved file opens in Excel with the bracket already in place, ready for a reader to collapse or expand.

Conclusion

Grouping columns turns a sprawling worksheet into a report that adapts to its audience: collapsed for a summary, expanded for detail, with nothing deleted along the way. The Shift + Alt + Right Arrow shortcut handles most cases, the Data tab covers the rest, and Auto Outline does the heavy lifting on large datasets built around summary formulas.

For related layout work, the guides on freezing panes and printing gridlines pair naturally with grouped reports, and IronXL is worth a look for anyone who needs the same structure applied to spreadsheets generated in bulk. You can also download a free trial to explore its features in your own projects.