How to Group Columns in Excel: Step-by-Step Guide

To group columns in Excel, select the columns you want to group, then go to the Data tab and click Group in the Outline section. This creates a collapsible group that helps organize your spreadsheet by hiding or showing those columns.

Syntax

Grouping columns in Excel does not use a formula but a menu command. The steps are:

• Select the columns you want to group.
• Go to the Data tab on the ribbon.
• Click the Group button in the Outline group.

This creates a collapsible group with a minus (-) or plus (+) sign to hide or show the columns.

excel

Select columns → Data tab → Group button

Example

This example shows how to group columns B to D in an Excel sheet:

1. Click and drag to select columns B, C, and D.
2. Click the Data tab.
3. Click Group in the Outline section.
4. You will see a line and a minus (-) button above the columns.
5. Click the minus (-) to collapse (hide) the grouped columns.
6. Click the plus (+) to expand (show) them again.

excel

1. Select columns B:D
2. Data tab → Group
3. Use minus (-) to collapse, plus (+) to expand

Output

Columns B, C, and D are grouped and can be collapsed or expanded.

Common Pitfalls

Common mistakes when grouping columns include:

• Not selecting the entire columns before grouping, which causes partial grouping or errors.
• Trying to group non-adjacent columns; Excel only groups adjacent columns at once.
• Forgetting to use the Data tab's Ungroup option to remove groups.
• Confusing grouping with hiding columns manually; grouping allows easy toggling.

excel

Wrong: Select columns B and D only (non-adjacent) → Group (won't work)
Right: Select columns B, C, and D (adjacent) → Group

Quick Reference

Action	Steps
Group columns	Select columns → Data tab → Group
Collapse group	Click minus (-) button above grouped columns
Expand group	Click plus (+) button above grouped columns
Ungroup columns	Select grouped columns → Data tab → Ungroup
Group non-adjacent columns	Not possible; group adjacent columns only

Key Takeaways

Select adjacent columns before using the Data tab's Group button to create a collapsible group.

Use the minus (-) and plus (+) buttons to collapse or expand grouped columns easily.

Ungroup columns by selecting them and clicking Ungroup in the Data tab.

Grouping helps organize large spreadsheets by hiding and showing related columns quickly.

You cannot group non-adjacent columns together; they must be next to each other.