다음을 통해 공유

Worksheet.ShowAllData Method (Excel)

  • 아티클

Makes all rows of the currently filtered list visible. If AutoFilter is in use, this method changes the arrows to "All."

Syntax

식 .ShowAllData

식 A variable that represents a Worksheet object.

Example

This example makes all data on Sheet1 visible. The example should be run on a worksheet that contains a list you filtered using the AutoFilter command.

Worksheets("Sheet1").ShowAllData

참고 항목

개념

Worksheet Object Members

Worksheet Object