How To Create A Filter View In Google Sheets

In this tutorial, you will learn how to create a filter view in google sheets.

When you’re working with large datasets in Google Sheets, it can often be difficult to identify the specific information you need within the spreadsheet. Additionally, it’s not uncommon to need to view the same subset of your data frequently. This is where Filter Views come in handy. With Filter Views, you can save a filter for a given dataset and come back to it whenever you want to see only rows that meet that criteria. Let’s take a look at how this works

Creating Filter Views

The first step is to create a filter view. Here’s how:

Step 1

Select the data you want to filter, including headers, then open the Data menu, hover over Filter Views and choose Create New Filter View

Step 2

A dark bar will appear above the cells, and the column and row headers will turn dark to indicate the filter view is on, however it’s not actually doing any filtering yet

Step 3

Click on the downward-pointing triangle icon beside the column you want to filter by to open the filter menu

Step 4

At the bottom of the menu is a list of values currently in the column with check marks beside them. You can check or uncheck these values to show and hide them in the column. Click OK to apply the filter

Step 5

You can also use the filter menu to sort the range, or filter by colors or conditions depending on your needs

Step 6

For example, to filter out all ages under 21, expand the Filter by Condition section and choose the Greater Than or Equal To option from the dropdown, then type 21 in the value field

Step 7

Click OK when you’re done to apply the filter and see only results matching that filter. You can add filters for as many columns as you would like and a green filter icon will appear in the header for each

Step 8

When you’re done setting the filters, be sure to rename the filter view so you can find it again. The current name is displayed above the column A header. Click on it and type in the new name, then hit enter

Toggling Filter Views

Once you’ve created and named a filter view, it’s easy to toggle on and off. Here’s how:

Step 1

To turn off a filter view that’s currently enabled, click the X at the right of the dark grey filter view header

Step 2

To turn a filter view back on, open the Data menu, hover over Filter Views, and click on the name of the filter view you’d like to turn on

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

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