To create an outline, group the rows (or columns) containing detail data. After that, you can hide/unhide such groups with a single click.
To group cells:
| 1. | Select the rows (or columns) to be grouped. |
| 2. | Choose the ribbon command Data | group Outliner | Group  . |
The cells are now grouped.
Note: Ungrouped cells have an outline level of 1. When you group cells, their outline level is set to 2. You can even group a subset of cells within a group of cells, thereby increasing the outline level to 3, etc. Outlines can contain up to 8 outline levels.
Ungrouping grouped cells
You can ungroup cells at any time.
To do so, proceed as follows:
| 1. | Select the rows (or columns) to be ungrouped. |
| 2. | Choose the ribbon command Data | group Outliner | Ungroup  . |
The cells are now ungrouped. To be precise, their outline level is reduced by 1. This means, that if you ungroup cells with an outline level of 3, they will not be completely ungrouped, but their outline level will be reduced to 2.
Completely removing the outline of grouped cells
If you want to completely remove the outline of cells, proceed as follows:
| 1. | Select the rows (or columns) whose outline you want to remove. Note: If you do not select any cells, the outline of the entire worksheet will be removed. |
| 2. | Choose the ribbon command Data | group Outliner | Remove all groups  . |
The outline is removed; all cells now have outline level 1.