abc MICROSOFT EXCEL 2010 - FILTER
AUTOFILTER

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

Autofilter , steps:

  1. Select the cell(s).
  2. DATA TAB.
  3. SORT & FILETER group.
  4. FILTER button .
  5. Arrows in the column headers appear.
  6. Click the arrow in column which you wish.
  7. Choose a parameter and value(s).
  8. Excel will dislplay only rows with choosen values (rows without choosen values will be hidden).
  9. The end (Kraj).

Index