Search notes:

Excel: Data -> Sort & Filter -> Clear

Data -> Sort & Filter -> Clear removes all criterias from a Filter.
In VBA, this corresponds to
activeSheet.showAllData

See also

The autoFilter object.

Index