AutoOutline

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

Toiminnon aloitustavat:

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 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!