AutoOutline

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

To access this command...

Choose Data - Group and Outline - AutoOutline.


For example, consider the following table:

Siječanj

Veljača

Ožujak

1st Quarter

Travanj

Svibanj

Lipanj

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.