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:

  1. With one cell selected in your data list choose Data, Filter, AutoFilter.
  2. From the ¬†drop-down menus of your selected field choose “Custom.”
  3. In the “Custom AutoFilter” dialog box choose the operator and type in your filters.
  4. Note the distiction between the AND and the OR options.
  5. 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.
  6. 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

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind