AutoOutline

If the selected cell range contains formulas or references, Collabora Office 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 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!