Creates an outline and defines settings for automatically creating outlines.
The first three arguments are logical values corresponding to check boxes in the Outline dialog box, which appears when you choose the Settings command from the Group and Outline submenu on the Data menu. If an argument is TRUE, Microsoft Excel selects the check box; if FALSE, Microsoft Excel clears the check box. If an argument is omitted, the check box is left in its current state.
Syntax
OUTLINE(auto_styles, row_dir, col_dir, create_apply)
OUTLINE?(auto_styles, row_dir, col_dir, create_apply)
Auto_styles corresponds to the Automatic Styles check box.
Row_dir corresponds to the Summary Rows Below Detail check box.
Col_dir corresponds to the Summary Columns To Right Of Detail check box.
Create_apply is the number 1 or 2 and corresponds to the Create button and the Apply Styles button.
| Create_apply | Result |
| 1 | Creates an outline with the current settings |
| 2 | Applies outlining styles to the selection based on outline levels |
| Omitted | Corresponds to choosing the OK button to set the other outline settings |
Related Functions
DEMOTE Demotes the selection in an outline
PROMOTE Promotes the selection in an outline
Return to index