How To Create Multiple Filters In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to create multiple filters in Google Sheets.

How To Create Multiple Filters In Google Sheets

Filtering data is a great way to quickly find and analyze the information that is most important to you. With Google Sheets, you can easily create multiple filters, giving you more control over the data you are viewing.

For example, you may want to create one filter to find all entries from a certain city, and another filter to find all entries from a certain month. With multiple filters, you can narrow down your data to just what you are looking for.

In this guide, we will show you how to create multiple filters in Google Sheets.

How to Apply Multiple Filters to Your Data in Google Sheets

Here’s how to apply multiple filters to your data in Google Sheets.

Step 1

Select the range you want to add multiple filters to.

In this example, we want to filter our dataset of credit card transactions by credit card type and by amount. Specifically, we want to show Mastercard transactions that have a transaction amount lower than $1000.

Step 2

In the Data menu, select the option Create a filter.

Step 3

Select the filter icon for the column you want to filter first with.

In this example, we added a filter for the credit_card_type field so that the filtered range will only show Mastercard transactions.

Step 4

Next, add another filter in another field in the filter range.

In the example above, we want to add another filter that only shows rows where the transaction amount is less than $1000.

Step 5

After applying both filters, you should now have the resulting entries that match both conditions.

Summary

This guide should be everything you need to create multiple filters in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.