Initially, I need to select the column which I want to group it now, let’s select the months (i.e. I don’t want all the monthly sales data to be displayed I want only quarterly & yearly sales data to be displayed it can be done through multiple grouping of column options. Here the data is structured and does not contain any blank cells, hidden rows, or columns. In the below-mentioned example, the Table contains product monthly sales data from Jan to Dec month, and it is also represented in quarterly & yearly sales. Now, you can observe data bars & “+” buttons and “-” buttons disappear in the excel sheet once the ungroup option is selected.Įxample #2 – Multiple Grouping of Columns for Sales Data in Excel On the Data tab, in the Outline group, click on Ungroup command. the columns which you have previously grouped). Select the columns you wish to ungroup (i.e. it is called a state, 1st option is called a hidden state (if you click on it, it will hide B, C, D, E Columns) whereas 2nd option is called unhidden state, it will expand those hidden columns, I.E. You can press the “-” buttons in the margin to collapse the columns (B, C, D, E Columns completely disappears) or in case If you want to expand them again, press the “+” buttons in the margin (B, C, D, E Columns appears)Īnother way to access data is the use of 1 or 2 options on the left side of the worksheet, i.e. How to Collapse & Expand Columns After Column Grouping Grouping also introduces a toggle option, or it will create a hierarchy of groups, which is known as an outline, to help your worksheet appear in an organized manner, where each bar represents a level of organization (Grouping is also referred to as Outlines.) Now you can observe in data, the columns are grouped perfectly, and the outline bars you can observe at the top represent different levels of data organization. Go to the Data tab, then click on the group option under the outline section. Initially, you need to select the column in which you want to group it (i.e. Grouping of columns in Excel works out well for structured data where it should contain column headings, and it should not have a blank column or row data. You can download this Grouping Columns Excel Template here – Grouping Columns Excel Template Example #1 – Grouping of Columns in Excel TEXT and String Functions in Excel (26+).
0 kommentar(er)
