How to Group and Ungroup Columns or Rows in Excel

It’s difficult to read and understand worksheets that contain a lot of extensive information. Fortunately, Microsoft Excel offers grouping data a breeze by allowing you to collapse and expand columns with comparable material to produce more compact and clear layouts. In this article, we will show you how to group and ungroup columns in excel. Thus you can organize data easily in groups and it will allow you to show and hide different sections of your worksheet.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Steps to Group Columns in Excel

Consider the following scenario: 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. Now, you have to group them into columns to organize a comparable layout.

Group Columns in Excel

Step 1: Selection of the Columns to be Grouped

Here, We will use the Group Command from selecting the Data tab on the Ribbon to group columns in Excel.

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

Group Columns in Excel

Read More: How to Group Columns in Excel (5 Easy Methods)

Step 2: Choosing the Group Command

  • Select the Data tab from the Ribbon

Group Columns in Excel

Step 3: Selecting the Column Option to Group Columns

  • Click the Group

Group Columns in Excel

  • Select Columns Command and press Enter.

Group Columns in Excel

  • 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


How to Ungroup Columns from Grouped Columns

In this section, we will discuss how you can ungroup your columns after you group them in Excel. Let’s learn this!

Steps:

  • Select the grouped columns.
  • Click the Ungroup

Steps


Similar Readings


How to Hide and Show Grouped Columns in Excel

If you want to organize data in a smart layout, you may need to hide any group or want to get back the hidden columns. It is basically a very easy process consisting of the following 2 steps.

Steps:

Process

  • Click the Show Detail button to show the group.

Group Columns in Excel

Read More: How to Hide Columns in Excel with Minus or Plus Sign (2 Quick Ways)


How to Group Rows in Excel

For Example, we want to group rows for the persons who are from the USA. To do this, we will follow a similar operation to group columns in Excel.

Step 1:

  • Select the rows with the country name, USA.

Row selection Step 2:

  • Select Rows from the Group Command on the Data

Select rows

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

Steps

Read More: How to Group Rows in Excel (5 Easy Ways)


✍ 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 in near range.


Conclusion

Thank you for reading this article. Using these methods, you can easily add characters to cells or specific positions as you want. If you have any questions – Feel free to ask us. We, The Exceldemy Team, are always responsive to your queries.


Related Articles

Bhubon Costa

Bhubon Costa

Myself, Bhubon Costa, an engineer, is currently employed with Exceldemy as an Excel & VBA Content Developer. I appreciate solving analytical difficulties, finding practical answers, and, for the most part, I enjoy taking on new tasks. I write articles on Exceldemy about various ways to get out of Microsoft Excel's stuck conditions. My passion is to leave my mark on the world through my work and to have an impact on the community who benefit from it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo