How to Filter Multiple Columns in Google Sheets

To filter multiple columns in Google Sheets, follow these steps:

1. Open your Google Sheets document.
2. Click on the "Data" tab in the top menu.
3. Select "Create a filter" or click on the filter icon (a funnel) in the toolbar. This will create filter icons (funnels) in the header row of your data.
4. Click on the filter icon in the first column you want to filter. A drop-down menu will appear.
5. In the drop-down menu, click on "Filter by condition" or "Filter by values" according to your needs.
   • If you choose "Filter by condition," select a condition (e.g., "Text contains") and enter the required value or formula.
   • If you choose "Filter by values," uncheck the values you don't want to include in your filter.
6. Click on "OK" to apply the filter to the first column.
7. Repeat steps 4-6 for each additional column you want to filter.

Example

Let's say you have a Google Sheet with the following data:

Name       | Age | Gender | Country
-----------|-----|--------|---------
Alice      | 25  | Female | USA
Bob        | 30  | Male   | UK
Charlie    | 22  | Male   | USA
David      | 27  | Male   | Canada
Eva        | 33  | Female | UK

To filter the data by "Gender" and "Country," follow these steps:

1. Click on the "Data" tab in the top menu.
2. Select "Create a filter." Filter icons will appear in each header cell.
3. Click on the filter icon in the "Gender" column. In the drop-down menu, click on "Filter by values."
4. Uncheck "Male" and click on "OK." The data will be filtered to show only rows with "Female" in the "Gender" column.
5. Click on the filter icon in the "Country" column. In the drop-down menu, click on "Filter by values."
6. Uncheck "Canada" and click on "OK." The data will be filtered to show only rows with "Female" in the "Gender" column and without "Canada" in the "Country" column.

After applying these filters, your data will look like this:

Name       | Age | Gender | Country
-----------|-----|--------|---------
Alice      | 25  | Female | USA
Eva        | 33  | Female | UK