Description: This article describes how to create a group in Excel 2010.

Excel is a very useful program for managing data. Sometimes, if the spreadsheets contain a lot of data it becomes useful to create groups that one can hide or show so that the data can be more easily managed. This article describes how to create a group in Excel 2010.

1. Highlight the rows or columns to be grouped.

2. Click on the Data tab.

3. Click the Group button.

4. Select whether it is rows or columns that are to be grouped and click OK.

5. Now a group has been created. When visible, a minus sign will appear that can be clicked on to collapse the group. When hidden, a plus sign will appear that can be clicked on to expand the group.