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.