How to Filter by List of Values in Excel

Filtering by a list of values in Excel allows you to display only the rows that meet specific criteria. You can use the built-in filter functionality in Excel to achieve this. Here's how to filter by a list of values in Excel:

1. Open the Excel worksheet containing the data you want to filter.
2. Click on a cell within the data range you want to filter. Make sure the data range has headers.
3. Go to the "Data" tab on the Excel ribbon.
4. Click on the "Filter" button. Small drop-down arrows will appear in the headers of each column.
5. Click the drop-down arrow in the header of the column you want to filter by the list of values.
6. In the drop-down menu, uncheck "Select All" to deselect all the values.
7. Check the boxes next to the values you want to filter by. You can select multiple values.
8. Click "OK" to apply the filter. Excel will now display only the rows that contain the selected values in the specified column.

Example

Suppose you have a list of sales data, and you want to filter the data to display only the rows with specific product names.

1. Click on a cell within the data range.
2. Go to the "Data" tab and click on the "Filter" button.
3. Click the drop-down arrow in the header of the "Product Name" column.
4. Uncheck "Select All" to deselect all the values.
5. Check the boxes next to the product names you want to filter by, for example, "Product A" and "Product B".
6. Click "OK" to apply the filter.

Now, the Excel worksheet will display only the rows with the selected product names (Product A and Product B) in the "Product Name" column.