faxenergylife.blogg.se

• Hide columns in excel for mac how to#

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.

Hide columns in excel for mac how to#

How to Collapse & Expand Columns After Column Grouping