How To Filter In Google Sheets

In this tutorial, you will learn how to filter in Google Sheets.

How To Filter In Google Sheets

When working with large datasets in Google Sheets, you might come across circumstances when you need to view only data that matches certain criteria.

Scrolling through a large spreadsheet and manually checking each entry could take hours, but fortunately Google Sheets has a built in filtering feature which makes it easy to quickly filter data sets however you need at the moment, the easily update those filters, all without modifying the original dataset

Creating a Filter

Before you create your filter, you’ll need a dataset to filter in Google Sheets.

Set up your dataset in a table with headers labeling each column then follow the steps below to create a filter.

Step 1

Select the range or table you want to filter, being sure to include the headers

Step 2

Open the Data menu and click on Create a Filter

Step 3

You will see that the filter has been added because the column letter headers will turn green and filtering icons will appear on the right side of each header cell

Step 4

To start filtering your data, click on one of the filter icons in the header cells to open the filtering menu for that column. The main filtering section is at the bottom of the menu

Step 5

In the filtering section at the bottom of the filter menu, you’ll see a list of all values in that column. You can click on each value to toggle the visibility of rows that contain that value

Step 6

You can click on the Select All or Clear links above the list to turn all values on or off. If you don’t immediately see the values you’re looking for, scroll down or use the search box above the list to find the exact value you want to toggle

Step 7

When you’re done selecting the values you want to display, scroll to the bottom of the filter menu and click OK to filter your data range based on the selected values

Step 8

Only rows with the selected value(s) will display in your dataset.

That’s it. You now have a filter set on your data range and can update the values you want to display at any time by following Steps 4-7 above

Clearing A Filter

Note that while rows are hidden after a filter is applied, all values are still stored in the spreadsheet. To see all values again, simply re-open the filter menu and click on the Select All option, then click OK to display all your data again.

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to filter in Google Sheets. Want more? Check out all the Google Sheets Tutorials.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.