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.
Step 1: Selection of the Columns to be Grouped
- Select the columns you want to group. Here, in this example, we will select columns C and D.
Step 2: Choosing the Group Command
- Select the Data tab from the Ribbon
Step 3: Selecting the Column Option to Group Columns
- Click the Group
- Select Columns Command and press Enter.
- Selected columns will be grouped. Here, columns C and D are grouped together. You can see the horizontal line marked with a red box.
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!
- Select the grouped columns.
- Click the Ungroup
- How to Add Columns in Excel (5 Quick Ways)
- Group Rows with Plus Sign on Top in Excel
- How to Group Rows in Excel Pivot Table (3 Ways)
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.
- Click the Hide Detail.
- Click the Show Detail button to show the group.
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.
- Select the rows with the country name, USA.
- Select Rows from the Group Command on the Data
Therefore, 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 in near range.
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.