Group and Outline

You can create an outline of your data and group rows and columns together so that you can collapse and expand the groups with a single click.

To access this command...

From the menu bar:

Choose Data - Group and Outline.


Group

Defines the selected cell range as a group of rows or columns.

Ungroup

Ungroups the selection. In a nested group, the last rows or columns that were added are removed from the group.

AutoOutline

If the selected cell range contains formulae or references, LibreOffice automatically outlines the selection.

Remove

Removes the outline from the selected cell range.

Show Details

Shows the details of the grouped row or column that contains the cursor. To show the details of all of the grouped rows or columns, select the outlined table, and then choose this command.

Hide Details

Hides the details of the grouped row or column that contains the cursor. To hide all of the grouped rows or columns, select the outlined table, and then choose this command.

Please support us!