SHOW.LEVELS

Macro Sheets Only

Displays the specified number of row and column levels of an outline.

Syntax

SHOW.LEVELS(row_level, col_level)

Row_level specifies the number of row levels of an outline to display. If the outline has fewer levels than specified by row_level, Microsoft Excel shows all levels. If row_level is zero or omitted, no action is taken on rows.

Col_level specifies the number of column levels of an outline to display. If the outline has fewer levels than specified by col_level, Microsoft Excel shows all levels. If col_level is zero or omitted, no action is taken on columns.

Remarks

If you omit both arguments, SHOW.LEVELS returns the #VALUE! error value.

Related Function

SHOW.DETAIL Expands or collapses a portion of an outline

List of Command-Equivalent Functions