How to Create a Filter in Google Sheets

Working with spreadsheets that contain a lot of data can be cumbersome, especially when you only need to display some of the information for certain scenarios. You may have previously considered hiding or deleting some rows or columns to simplify the view, but that can be tedious.

One other way to customize the data displayed in your spreadsheet is with the use of filter. By learning how to create a filter in Google Sheets you will unlock a very powerful tool that can provide you with a number of options for displaying subsets of your data. Our tutorial below will show you how to create and set up a filter in Google Sheets and even save that filter so that you can use it again in the future.

 

How to Use Filters in Google Sheets

The steps in this article were performed in the desktop version of Google Chrome, but will also work in other desktop Web browsers like Firefox or Edge. This guide assumes that you already have a Google Sheets file with data in it that you would like to filter. We are going to show you how to create the filter, then how to use it to only display some of the data that you have selected. If you like a filter that you have created and want to use it again, you will also have the option of saving that filter.

Step 1: Go to your Google Drive at https://drive.google.com and sign into your Google Account if you haven’t already.

 

Step 2: Open the Google Sheets file containing the data that you want to filter.

 

Step 3: Select the data in the spreadsheet that you would like to filter.

google sheets filters

 

 

Step 3: Click the Create a filter button at the right side of the toolbar.

create a filter

 

 

Step 4: Click the triangle button at the right side of the column that you want to filter.

how to use filters in google sheets

 

 

Step 5: Use the Filter by condition and Filter by values sections of this menu to customize the data that you want to display. You can also use the Sort by options at the top of the menu to change how the data is sorted. Once you’re done, click the OK button at the bottom of the menu.

how to create a filter in google sheets

 

 

Step 6 (optional): If you like the way that the data is displayed and want to use it again, click the dropdown arrow to the right of the Create a filter button that we clicked in step 3, then choose the Save as filter view option.

how to save a filter view in google sheets

 

 

Step 7 (optional): Type a name for this filter view in the gray bar above the spreadsheet, then press the Enter key on your keyboard to finish.

how to name a saved filter in google sheets

 

 

Now when you click the dropdown arrow next to Create a filter again, you will see the filter view that you just saved. You can click that at any time to view the filtered data.

how to switch to a filter in google sheets

 

 

Are you looking for a way to combine some of your cells? Find out how to merge cells in Google Sheets if you would like to make some bigger cells without adjusting the sizes of some rows or columns.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.