Excel Column Grouping
Group Column in excel means bringing one or more columns together in an excel worksheet, this gives us option to contract or expand the column and excel provides us a button to do so, to group columns we need to select two or more columns and then from data tab in the outline section we have the option to group the columns.
How to Use Column Grouping in Excel? (with Examples)
- Step 1: Select the data that you are using to group the column in excel.
- Step 2: Go to data option in the excel toolbar and select group option in the outline toolbar as shown in below screenshot.
- Step 3: When you click on the group, it will enable you to group the particular column in your excel spreadsheet. As shown below in the screenshot, you will able to see the minus sign symbol added to the outline above the selected columns.
This is the result when you want to hide the column C and D in a spreadsheet and it automatically enables the grouping option in your spreadsheet
- Step 1: Select column B and C
- Step 2: Go to data option in the excel toolbar and select group option in the outline toolbar as shown in the below screenshot.
- Step 3: Go to the option group and make the group of a column as selected.
Now you will be able to see the two minus signs it means that there are two groups created in a particular spreadsheet that you want to group.
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
How to Hide or Unhide the Group Column?
- Step 1: Click on the minus sign which was created while grouping the column.
- Step 2: When you clicked on the minus sign, a column will collapse and it results in the hide in a column.
- Step 3: Once you clicked on the minus sign, it automatically shows the plus sign which means that if you want to unhide the column just click on plus sign to unhide the columns.
- Step 4: You can likewise utilize the small numbers in the upper left corner. They let you cover-up and unhide all groupings of a similar dimension without a moment’s delay. For instance, in my table on the screen capture, clicking on 2 will conceal columns B and D. This is particularly helpful on the off chance that you made a progressive system of collection. Clicking on 3 will unhide or hide columns C and D.
Shortcut Keys to Hide or Unhide Column Grouping in Excel
- Step 1: Select your data. Press Shortcut Excel Keys – Shift + Alt + right arrow. You will see the dialogue box in your excel spreadsheet as follows-
- Step 2: Select the radio button on a column, to hide the columns in excel.
- Step 3: Click on Ok and you will be able to hide and unhide the columns in excel.
Why you should use the Excel Column Grouping
- To effectively expand and contract the section or areas of a worksheet
- To limit schedules or side estimations that different user probably won’t require while working in excel worksheets
- To keep data composed and in an organized structure.
- As a substitute for making new sheets (tabs).
- As a better option than hiding cells.
- It is the better function as compare to hiding the column function.
- It helps you to set up the grouping level.
Why you should not use the Excel Column Grouping
- You won’t be able to make a group of the cell which is not adjacent cells.
- If you are managing different worksheets, and need to assemble similar lines/columns on numerous worksheets in the meantime, it is not possible to use this function.
- Always need to check that your data should be in a sorted form.
- You always need to check while grouping the column in excel that you are selecting the correct column which needs to group.
Things to Remember
- You won’t be able to add the Calculated Items to grouped Fields in your excel spreadsheet.
- It’s impractical to choose a few non-nearby columns.
- Clicking on the minus icon will hide the column and the icon will change to the plus sign letting you to instantly unhide the data.
- You can select the range and press Shift + Alt + left arrow to remove the grouping from your excel spreadsheet.
This has been a guide to Group Column in Excel. Here we discuss how to use Group Excel Column along with examples and downloadable excel templates. You may also look at these useful functions in excel –