āļšāˇœāļ§āˇ”āˇ€

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.


āļšāˇœāļ§āˇ”āˇ€

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

āļšāˇœāļ§āˇ”āˇ€

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

āļšāˇœāļ§āˇ”āˇ€

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

āļšāˇœāļ§āˇ”āˇ€

Removes the outline from the selected cell range.

āļšāˇœāļ§āˇ”āˇ€

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.

āļšāˇœāļ§āˇ”āˇ€

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!