Sign up
  • Home
  • Productivity
  • App tutorials

How to Filter in Google Sheets

App tutorials

2 min read

How to Filter in Google Sheets

By Justin Pot · May 13, 2019
how-to-filter-in-google-sheets primary img

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

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

Want to learn more about Google Sheets? Check out our Google Sheets overview for tutorials and ways to integrate Google Sheets with 1,500+ apps.

Get productivity tips delivered straight to your inbox

We’ll email you 1/wk, and never share your information.

Justin Pot picture

Justin Pot

Justin Pot is a staff writer at Zapier based in Hillsboro, Oregon. He loves technology, people, and nature, not necessarily in that order. You can follow Justin on Twitter: @jhpot. You don't have to. But you can.

mentioned apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.

Sign upSee how it works