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.
Find the Excel Video Lesson that you want – Index to all Excel Topics
News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.
Related Video Lessons
Link to this post!
Speak Your Mind