FILTER
AUTOFILTER

Selct data in Excel is called filter. The user can choose only rows with wanted values.

FILTER - AUTOFILTER , steps:

  1. Select the cell(s).
  2. DATA menu.
  3. FILTER item.
  4. Submenu appears.
  5. AUTOFILTER item.
  6. Click button near the wanted column.
  7. Select the value.
  8. EXCEL will show only rows with choosen values.
  9. The end (Kraj).

Index