Create Advanced Filters for your data list

In this Excel Video Lesson we will teach you to use Advanced Filtering of your data list.

Here are the steps to follow in this video lesson:

1. Apart from your data table write your Criteria. Criteria must consist of at least 2 rows – a Header and at least 1 row of Criteria.
2. With an active cell selected in the data table, click Data, Filter, Advanced Filter.
3. Accept the default setting to Filter the Data in-place and also the range for the data list. Select the cells for your Criteria and click OK.
4. The Advanced Filter applies the Criteria to show only those records that meet your Criteria.
5. When you write your Criteria on 1 row, ALL of the criteria must be met – i.e. the “AND” option.
6. When you write your Criteria on multiple rows, each criteria is met independently – i.e. the “OR” option.

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

• AutoFilter your list
• Apply Custom Filters to your data list