Share via

ShowAllData Method

  • Article

Makes all filtered rows visible on the specified worksheet and sets all filters to Show All.

expression.ShowAllData

*expression   * An expression that returns a Worksheet object.

Example

This example makes all filtered rows visible on the active worksheet and sets all filters to Show All.

Spreadsheet1.ActiveSheet.ShowAllData

Applies to | Worksheet Object