If you have created an outline for a worksheet (as described in the previous section), you can show/hide detailed data (thus grouped cells) at any time as required.
To show/hide grouped cells, use the Outline pane as follows:
▪A bar with a minus sign 
is displayed next to grouped cells in the outline pane. To hide the grouped cells, click on the minus sign.
▪A plus sign 
appears next to hidden cells in the Outline pane. To show the grouped cells, click on the plus sign.
▪Use the 
buttons at the top of the Outline pane to specify that only detailed data from a certain level should generally be displayed. If, for example, you click on the "2" button, only rows of the first and second outline levels will be displayed.
For rows, you can also use the commands Show details 
and Hide details 
on the ribbon tab Data | group Outliner to show or hide the grouping (corresponds to the plus and minus signs in the Outline pane, see above).
Note: When you hide grouped cells, they are not only hidden on the screen but are also no longer considered in charts.