How to Filter a List in Microsoft Excel

If you created a list in Microsoft Excel and need to filter it, you can easily do so. Using AutoFilter, you can create three types of filters: by a list values, by a format or by criteria. You can filter cells that have text or cells with numerical values. The filtering option is useful as it saves you time from having to manually reorder a list. You only need to access the "Data" section in Excel to get started.

Instructions

1. Open the Excel spreadsheet that has the list you want to filter and click the "Data" tab located in the ribbon at the top of the page.

2. Highlight the range of cells that you want to filter and then look to the "Sort & Filter" section of the ribbon. You can select a filtering option from the ribbon or click "Filter" from the spreadsheet.

3. Click a filtering button from the ribbon to filter the list or click the arrow on the spreadsheet to open the filtering options. You can choose to filter the list by size or color.

4. Click the filter option you want to use. The list will filter automatically.

Tips & Warnings

• If you decide you don't want to use the filter option you selected, click "Clear" and then select a different filter.

References

• Microsoft: Filter Data