DEMOTE

Macro Sheets Only

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

List of Command-Equivalent Functions