Have you seen a excel spreadsheets with + or – symbols which on clicking unhides or hides rows and columns? You might think that, it is done using Excel VBA. But this is not done by any VBA code. It is a simple grouping features of Excel. It is very useful when you want to display only the summary and show details with single button click. Lets start learning how to group and ungroup in Excel.
For example you might have data which contains datewise data along with Weekly summary. You can show only the summary and provide the option to user to view the details using the + or – buttons
Steps to Group Rows or Columns in Excel
Step 1: Select the cells you want to group it. You can choose rows or columns according to your requirement. In this example i am selecting the rows from A2 to A5.
Step 2: Go to Data and click on Group and select Group once again. Your selected rows or columns are grouped.
Step 3: There will be + sign when your details are grouped and showing only summary. Where clicking on + sign will expand the group
Steps to Ungroup rows or Columns
Step1: Select the rows or columns you have Group enabled.
Step2: Go to Data and select Ungroup and choose Ungroup.
Step3: The Group is removed.
As mentioned earlier, grouping in excel is very useful for presenting the data in good manner. Advantages of grouping is it shows the summary and it required, the all the details are also there. Unlike simple row/column hiding, in grouping you will will have symbol which indicates that, there is a grouping.
Hope this Excel tips is useful. If you find this guide useful, then please share it with your friends. Any queries and support needed, then leave a comment below.
Leave a Reply