How to Filter a Column by Multiple Values in Excel

To filter a column by multiple values in Excel, follow these steps:

1. Open your Excel workbook and select the worksheet containing the data you want to filter.
2. Click on any cell within the data range, which will be your starting point.
3. On the top menu, click on the "Data" tab.
4. In the "Sort & Filter" group, click on the "Filter" button. This will add a drop-down arrow in the header row of each column.

Now that you have set up the Filter, you can filter a column by multiple values.

Example

Suppose you have the following data in an Excel worksheet:

A          B
----------------
Name       Age
----------------
Alice      25
Bob        30
Charlie    50
Diana      45
Emma       30
Frank      25
George     40

Let's say you want to filter the "Age" column to display only the rows with ages 25 and 30. Here's how to do it:

1. Click on the drop-down arrow in the header row of the "Age" column (cell B1).
2. In the drop-down menu, uncheck "Select All" to deselect all values.
3. Check the boxes next to the values 25 and 30.
4. Click "OK" to apply the filter.

Your filtered data will now look like this:

A          B
----------------
Name       Age
----------------
Alice      25
Bob        30
Emma       30
Frank      25

The "Age" column has been successfully filtered to display only the rows with ages 25 and 30. To clear the filter and display all the data again, click on the drop-down arrow in the header row of the "Age" column and select "Clear Filter."