<< Click to Display Table of Contents >> Showing/hiding grouped cells |
If you have created an outline for a worksheet (as described in the previous section), you can hide/unhide detail data (i.e., grouped cells) at any time as required.
To hide/unhide grouped cells, use the Outline pane:
▪A bar with a minus sign is displayed next to grouped cells in the outline pane. To hide the grouped cells, click the minus sign.
▪A plus sign indicates grouped cells that are currently hidden. To unhide the grouped cells, click the plus sign.
▪Click the buttons on top of the Outline pane to determine which outline levels to display. For example, if you click the "2" button, all cells with an outline level between 1 and 2 will be displayed.
For rows, the commands Show details and Hide details on the ribbon tab Data | group Outliner can also be used to hide or unhide the grouped cells (corresponds to the plus and minus signs in the outline pane, see above).
Note: When you hide cells, the cells are not only hidden on the screen, but also ignored by charts evaluating these cells.