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

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 \<emph\>AutoOutline\</emph\> 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!