You can arrange the rows or columns in a group. You can also ungroup them at any time.
Steps
To set data as a group
- Select some cells that you want to arrange in a group.
- Select Data > Group/Outline > Group.
- Select Row and click the OK button in the Group dialog box.
- Click the [-] icon to hide data in a group.
The [-] icon changes to the [+] icon when the data in a group collapses.
Ungroup data
- Select one or some cells in a group that you want to ungroup.
- Select Data > Group/Outline > Ungroup.
- Select Row and click the OK button in the Group dialog box.