You can change outline settings via the dialog box Outliner options. To open this dialog box, click on the group arrow
in the bottom right corner of the ribbon tab Data | group Outliner.
Here, you can make the following settings for the structure of the current worksheet:
▪Title below group rows
| This option basically only determines whether the plus and minus signs should be displayed above or below the bar for grouped cells in the Outline pane. |
| Enable this option if you want the plus and minus signs to be located below the grouped cells. Disable it if you want them to be above the grouped cells. |
▪Title to the right of group columns
| This option corresponds to the above option; however, it refers to worksheets where columns have been grouped rather than rows. You can use it to determine whether the plus and minus signs are located to the left or right of the grouped cells. |
▪Automatically show outline pane
| This option determines whether the Outline pane should be displayed automatically if the worksheet contains grouped cells. |
| If this option is enabled, this pane will appear automatically as soon as the worksheet contains at least one group of cells. If disabled, the Outline pane will not be displayed. |
▪Protect outline
| If this option is enabled, the outline will be protected if sheet protection is enabled for the worksheet. For more information, see Sheet protection. |
| If sheet protection is enabled, the current state of the outline will then be "frozen". Users will not be able to show or hide grouped cells nor group or ungroup cells. |