In this topic, we will apply a filter to data in an Excel spreadsheet.


  1. Click the down arrow in the column that is to be filtered.

    Step 1
  2. Check off the condition you want to filter.  Depending on the size of your list, it may be better to check off the "Select All" option first, then select your filter criteria.  You can filter more than one field.


    In this example, click the CA option.

    Step 2
  3. Click OK 

    Step 3
  4. In this example, California (CA) has been filtered out of the list.

    Step 4
  5. Custom Filters

    Step 5
  6. Click the down arrow in the column you want to filter.

    Step 6
  7. Click Text Filters (this will depend on what you are trying to filter).

    Step 7
  8. Click Custom Filter...

    Step 8
  9. Click in the field.

    Step 9
  10. Enter the parameters for your filter.  In this example, enter *CA

    Step 10
  11. You can also click the down arrows to select your parameters.


    Step 11
  12. Click OK

    Step 12
  13. The Filter has been applied.

    Step 13
  14. Turn off the Filter

    Step 14
  15. Click the down arrow in the column where the filter has been applied.


    Step 15
  16. Click Clear Filter From "State" 

    Step 16
  17. The Filter has been removed.

    Step 17

After completing this topic, you are able to apply / remove a filter in Excel.