[Open in a new window]

Using Filters

Note: Excel 2007 has improved data filtering

  1. Select any cell in the list.
  2. Select the Data tab.
  3. Select the Filter button .
  4. Click the desired Filter arrow .
  5. Click Select All to deselect it.
  6. Select the value you want to use as a filter.
  7. Select OK.