Group and Outline

You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click.

To access this command...

Choose Data - Group and Outline.

Hide Details

Hides the details of the grouped row or column that contains the cursor. To hide all of the grouped rows or columns, select the outlined table, and then choose this command.

Show Details

Shows the details of the grouped row or column that contains the cursor. To show the details of all of the grouped rows or columns, select the outlined table, and then choose this command.

Group

Defines the selected cell range as a group of rows or columns.

Ungroup

Ungroups the selection. In a nested group, the last rows or columns that were added are removed from the group.

AutoOutline

If the selected cell range contains formulae or references, Office automatically outlines the selection.

Remove

Removes the outline from the selected cell range.