AutoFilter

Drop-down arrows on the header row (Data > Filter) that hide the rows that do not match. Hidden rows are not deleted, and filters on different columns combine with AND, while one column can take two conditions joined by And or Or.

When to use

Use it for quick exploration of the employee table, and pair it with SUBTOTAL to total only the visible rows. For OR across different columns it is not enough, and the Advanced Filter is used instead.

See Lec 01.

Appears in

No references yet.