How to Group and Ungroup Columns or Rows in Excel


Consider you have data in existing cells that contain names from different countries. They have different room numbers to be allocated according to their payment history. You have to group them into columns to organize a comparable layout.

Group Columns in Excel


  • Select the columns you want to group. In this example, we will select columns C and D.

Group Columns in Excel

  • Select the Data tab from the Ribbon.

Group Columns in Excel

  • Click on Group.

Group Columns in Excel

  • Select the Columns option and press Enter.

Group Columns in Excel

  • The selected columns will be grouped. Here, columns C and D are grouped together. You can see the horizontal line marked with a red box.

Group Columns in Excel

Read More: How to Group Duplicates in Excel

Read More: How to Group Cells with Same Value in Excel

How to Ungroup Columns


  • Select the grouped columns.
  • Click Ungroup.


How to Hide and Show Grouped Columns in Excel


  • Click the Hide Detail icon.


  • Click the Show Detail button to show the group.

Group Columns in Excel

How to Group Rows in Excel


  • Select the rows you want to group.

Row selection

  • Select Rows from the Group command on the Data tab.

Select rows

  • You will see the grouped rows indicating a vertical line on the left.


Things to Remember

  • In your Excel worksheet, you won’t be able to add Calculated Items to grouped Fields.
  • It’s impractical to select a few columns that aren’t nearby.

Download the Practice Workbook

Related Articles

<< Go Back to Group Cells in Excel | Outline in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bhubon Costa
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF