AutoFilter adds ▾ buttons to the headers: each holds the list of column values with check boxes and conditions ("greater than", "contains", "top 10"). Rows that do not match are hidden, not deleted; the numbers of the visible rows turn blue.
- Turn it on / off: Data → Filter or Ctrl+Shift+L.
- Conditions in different columns combine with AND: "Region = South" and "Amount > 1000".
- Clear removes all conditions but keeps the buttons.
Totals of visible rows
A filter hides the whole row, so totals go above the table or in the header row, not beside the data. SUM adds all rows, even hidden ones. For a total that follows the filter, use SUBTOTAL(9, D2:D11): the first argument says what to calculate (9 — sum, 1 — average, 2 — count of numbers, 4 — max, 5 — min). AutoSum on a filtered table inserts exactly this function.