Equivalent to clicking the Group tool. Demotes, or groups, the selected rows or columns in an outline. Use DEMOTE to change the configuration of an outline by grouping rows or columns of information.
Syntax
DEMOTE(row_col)
DEMOTE?(row_col)
Row_col specifies whether to group rows or columns.
| Row_col | Demotes |
| 1 or omitted | Rows |
| 2 | Columns |
Remarks
If the selection consists of an entire row or rows, then rows are demoted even if row_col is 2. Similarly, selection of an entire column overrides row_col 1.
If the selection is unambiguous (an entire row or column), then DEMOTE? will not display the dialog box.
Related Functions
PROMOTE Promotes the selection in an outline
SHOW.DETAIL Expands or collapses a portion of an outline
SHOW.LEVELS Displays a specific number of levels of an outline
Return to index