Google Sheets

How to Filter in Google Sheets

Justin Pot Avatar
Written by Justin Pot
Last updated May 13, 2019

Massive spreadsheets are impossible to parse, which is why filtering comes in handy: You can see only the information you need. Here's how to filter your data in Google Sheets.

To get started, highlight the cells in your sheet that you'd like to filter.

Google Sheets select cells

Next click Data > Create a Filter, or click the Filter button in the toolbar.

Create a Filter in Google Sheets

You will now see the filter icon in the top cell of every column in the cells you selected.

Filter icon in Google sheets

Click that icon to sort or filter your spreadsheet based on the contents of a given column.

Filter dialogue in Google Sheets

In our example, we're looking at United States population data. We could filter our results to show only states with one house seat, if we wanted, by clicking Filter by values and then selecting only "1".

Filter by Values in Google Sheets

Click OK and our spreadsheet is filtered.

Filter data in Google Sheets

The option to Filter by values, which we just used, is very simple: just check the values you want to see. You can do more complicated filtering using Filter by condition.

Filter by Condition in Google Sheets

Let's look at our example data again. If we want to filter this spreadsheet to only show states and territories with fewer than one million people, as of April 2010, we can. Under Filter by condition choose Less than, then enter 1,000,000 as your value.

Filter using Less than in Google Sheets

Click OK and our results are filtered.

Filtered data in Google Sheets

Less Than is just one of the drop downs you can use, of course. There's a lot of other options here, allowing you to filter your data in all kinds of ways. The best way to learn everything is to try things out.

Turn Off Filters

Want to turn off your filter and get back to your full spreadsheet? You can do that by clicking Data > Turn off filter or by clicking the filter button in the toolbar.

Turn off filter in Google Sheets

Do this and you'll see the full spreadsheet again.

Unfiltered data in Google Sheets

Note that, if you turn off filters, you will lose any unsaved filters.

How to Save Filter Views in Google Sheets

You can save filters to use later. To get started, first set up a filter, as outlined above. Then click Data > Filter views > Save as filter view.

Save as Filter View in Google Sheets

This will create a saved filter view, which you can optionally give a name.

Filter View in Google sheets

You can re-use this filter view any time. Click Data > Filter views, and you will see it there.

Google Sheets' Filter Views in menu

If you've shared your Google Sheet with others, they can also access your filters this way.

Related Tutorials

How to Import Data into Google Sheets

Justin Pot Avatar

Justin Pot

How to Download Your Data from Google Sheets

Justin Pot Avatar

Justin Pot

How to Make a Graph or Chart in Google Sheets

Justin Pot Avatar

Justin Pot

Getting Started with Zapier