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.
Select the range or table you want to filter, being sure to include the headers
Open the Data menu and click on Create a Filter
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
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
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
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
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
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.
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.