Free Online Tutorials on Spreadsheets

Group data in Excel

To present data in a well-organized way or to show the only relevant data, use the group feature in Excel. In this illustration, we will first learn how to group then un-group data mentioned in the below screenshot.

1- Select data range that you want to group.

Step 1

2- Go to the Data Tab, in the Outline section, press Group.

Step 2

3- The Group box will appear, select Rows as we are going to group rows now. Press OK.

Step 3

4- Result. Now by pressing the negative sign, you can show the more precisely.

Step 4
Step 5

Ungroup Data

Similarly, to ungroup data, First select the data range then go to the Data Tab, select Ungroup from the Outline section.

Copyright © 2016 - 2019 | All Rights Reserved