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
Return to index