Grouping a cell range allows hiding parts of a spreadsheet. This makes spreadsheets more readable, as you can hide all the parts you are not currently interested in. It is possible to group rows or columns and nest groups in other groups.
To group a range, proceed as follows:
Procedure 11.5: Grouping a Selected Cell Range
Select a cell range in your spreadsheet.
Select Data › Group and Outline › Group. A dialog appears.
Decide if you want to group your selected range by rows or by columns. Confirm with OK.
After grouping selected cells, a line indicating the grouped cell range appears in the upper-left margin. Fold or unfold the cell range with the + and – icons. The numbers at the top left of the margins display the depth of your groups and can be clicked too.
To ungroup a cell range, click into a cell which belongs to a group and select Data › Group and Outline › Ungroup. The line in the margin disappears. The innermost group is always deleted first.