AutoFilter

AutoFilter temporarily hides the rows that do not meet criteria chosen on one or more columns, without deleting any data. It applies to a range with headers and offers filters by value, text, number, date or color. Hidden rows stay in the workbook.

Example

Filter the Statut column on "En retard" (late) to show only those rows.

Related concepts

The whole glossary