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
