Filtering Data

Filtering in Excel lets you temporarily hide unwanted data. Use filters in Excel to narrow down data in your Excel spreadsheet.


  1. Open our practice workbook.
  2. Click the Challenge tab in the bottom-left of the workbook.
  3. Apply a filter to show only Electronics and Instruments.
  4. Use the Search feature to filter item descriptions that contain the word Sansei. After you do this, you should have six entries showing.
  5. Clear the Item Description filter.
  6. Using a number filter, show loan amounts greater than or equal to $100.
  7. Filter to show only items that have deadlines in 2016.
  8. When you're finished, your workbook should look like this:

    Filtering Challenge