Filter a range of data
- Select any cell within the range.
- Select Data > Filter.
- Select the column header arrow .
- Select Text Filters or Number Filters, and then select a comparison, like Between.
- Enter the filter criteria and select OK.
How do I filter a list in Excel?
To run the Advanced Filter:
- Select a cell in the data table.
- On the Data tab of the Ribbon, in the Sort & Filter group, click Advanced.
- For Action, select Filter the list, in-place.
- For List range, select the data table.
- For Criteria range, select C1:C2 – the criteria heading and formula cells.
- Click OK, to see the results.
How do I create a drop-down filter in Excel?
Create a drop-down list
- Select the cells that you want to contain the lists.
- On the ribbon, click DATA > Data Validation.
- In the dialog, set Allow to List.
- Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.
