Grouping Data
You can create groups of data to help you work with large worksheets of data, or anytime that you want to provide some structure to your worksheet or facilitate outlining tools. A group simply creates an object out of selected rows or columns. This object can be expanded or collapsed.
Use the following procedure to create a group.
- Select the range of cells you want to group.
- Select the Data tab from the Ribbon.
- Select Group.