Search notes:

Excel: Data -> Sort & Filter -> Filter

With the Filter, it is possible to hide rows in a Range that meet given criterias.
If such a filter is in place, the Filter symbol is displayed with a gray background (even if no rows are actually filtered), as shown below:

See also

The autoFilter object.

Index