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:

January

February

March

1st Quarter

April

May

June

2nd Quarter

2000

120

130

350

2000

2000

2000

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 - Outline - Remove.

Please support us!