Apply a custom filter to a data list

In this video lesson you will learn how to apply a Custom AutoFilter to your Excel data list.

Here are the steps to follow in this video lesson:

With one cell selected in your data list choose Data, Filter, AutoFilter.
From the drop-down menus of your selected field choose “Custom.”
In the “Custom AutoFilter” dialog box choose the operator and type in your filters.
Note the distiction between the AND and the OR options.
You can then apply a Custom Filter to another field – i.e. filter another field within the existing Custom Filter you applied to the 1st field.
To remove the Custom Filter, select “All” for each field that you filtered.