To create an outline, group the rows (or columns) that contain detailed data. You can then show or hide them later via a mouse click as required.
To group cells, proceed as follows:
| 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 increased to 2. You can even group a subset of cells within a group of cells, thus increasing their outline level to 3. Outlines can contain up to 8 outline levels.
Ungrouping grouped cells
You can ungroup cells at any time.
Proceed as follows:
| 1. | Select the rows (or columns) to be ungrouped. |
| 2. | Choose the ribbon command Data | group Outliner | Ungroup  . |
The cells are no longer grouped – more precisely, their outline level is reduced by one level. 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 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 of the cells has now been completely removed, thus their outline level is reset to 1.