Changing outline settings

<< Click to Display Table of Contents >>

Changing outline settings

You can change outline settings via the dialog box Outliner options. To open this dialog box, click on the group arrowgroup_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

A title line is a row directly above or below grouped cells.
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 this title bar to be located below the grouped cells. Disable it if you want the title bar to be above the grouped cells.

Title right of the group columns

Similar to above, except this option only affects worksheets with a column outline. You can use it to determine whether the title is 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 appears 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 (see Sheet protection).
The current state of the outline will then be frozen. Users will not be able to group/ungroup cells or hide/unhide grouped cells.