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)
Following are the steps of excel column grouping –
- Select the data that you are using to group the column in excel.
- Go to the data option in the excel toolbar and select the group option in the outline toolbar, as shown in the below screenshot.
- 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 the data option in the excel toolbarExcel ToolbarThe toolbar, also known as the quick access toolbar, is located on the left top-most side of the excel window and has only a few options by default, such as save, redo, and undo. Users can, however, customize it to their liking and add any option or button to make it easier to access the commands. and select the 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.
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 the 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 excelHide The Columns In ExcelThe methods to hide columns in excel are - hide columns using right-click option, hide columns using shortcut cut key, hide columns using column width, hide columns using VBA code..
- Step 3: Click on the Ok, and you will be able to hide and unhide the columns in excelUnhide The Columns In ExcelUsing the Home tab of the Excel ribbon, using the shortcut key, using the context menu, altering the column width, using the ctrl+G (go to) command, and using the ctrl+F (find) command are some of the ways to unhide a column 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 users 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 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 –