AutoOutline

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

To access this command...

From the menu bar:

Choose Data - Group and Outline - AutoOutline.

From the tabbed interface:

On the Data menu of the Data tab, choose AutoOutline.

From toolbars:

Icon AutoOutline

AutoOutline


For example, consider the following table:

January

February

March

1st Quarter

April

May

June

2nd Quarter

100

120

130

350

100

100

200

400


The cells for the 1st and 2nd quarters each contain a sum formula for the three cells to their left. If you apply the AutoOutline command, the table is grouped into two quarters.

To remove the outline, select the table, and then choose Data - Group and Outline - Remove.

Please support us!