Filter a List in Excel

When you working with columns of information it is nice to be able to sort it in ascending or descending order. Sometimes it is necesary to organize the data based on specific search conditions. Filtering is especially useful when you want to view only select data based on a specific criteria. Excel has a Auto Filter feature, which allows you to quickly filter a list to display a subset of the data in the list. Excel displays the filtered list based on your specified criteria. Excel hides the records that do not match the specified criteria.

 

You can also filter a list based on more than one criterion. This is done by using a Custom AutoFilter.

---

---

How To Filter a List:

1. Select any cell in the list.
2. From the Data menu choose Filter, slide right to AutoFilter to display the AutoFilter drop-down arrows.
3. Click the desired column arrow to display the list of criteria.
4. From the list of criteria, select the desired criterion.

To show the unfiltered, complete list:

1. From the Data menu, choose Filter, slide right to Show All.
2. From the Data menu, choose Filter, slide right to AutoFilter.

How to Filter using a Custom AutoFilter:

1. Select any cell in the list.
2. From the Data menu choose Filter, slide right to AutoFilter to display the AutoFilter drop-down arrows.
3. Click the desired column arrow to display the list of criteria.
4. Select Custom to open the Custom AutoFilter dialog box.
5. On the left side select the first comparison operator.
6. On the right side select its associated comparions criterion.
7. Select And or Or.
8. On the left side select the second comparison operator.
9. On the right side select its associated comparions criterion.
10. Click OK.