Viewing Grouped and Outlined Data

When you have added groups or created an outline, either manually or automatically, Excel includes several features to make it easy to view different parts of the data at once. You can expand or collapse detail data. You can also jump to another group at any time.

To follow is how to work with grouped or outlined data.

The Hide Detail icon allows you to quickly hide the detail data.

The + icons indicate hiding detail data.

The Show Detail icon allows you to quickly show the detail data. You can select the Show Detail icon multiple times to continue expanding the current level.

The minus icons allow you to collapse individual groups. The plus icons allow you to expand individual groups.

The numbers in the top left corner indicate a level. Click on a number to show that level.