1. Open the Excel spreadsheet.
  2. Click in cell A1.
  3. Select the Data tab in the Office ribbon and click the Filter button. Drop-down arrows appear in each column.
  4. Click the drop-down arrow for the column you wish to filter by.
  5. Either unmark all the items you want filtered out or unmark Select All and mark each item you want to see.