Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to create a filter in Google Sheets.
How To Create A Filter In Google Sheets
Filtering your data is a great way to analyze a particular subset of a dataset. For example, you may want to filter your data by a certain criterion, such as only showing the entries that contain a certain name or phrase.
Or you may have a list of customers and their contact information. You can use a filter to show only the customers in a certain country or who have made a purchase within the past week.
In this guide, we will show you how to quickly create a filter in Google Sheets.
How To Filter Data In Google Sheets
Here’s how to filter data in Google Sheets.
Select the range you want to apply a filter to.
In this example, we want to add a filter to columns A through E.
Select the option Data > Create a filter.
Your range’s headers should now have a filter icon for each column.
Identify a field you want to filter with. Click on that field’s filter icon to reveal the available filter options.
Users can filter by values to remove any rows that do not match a certain subset of values. Use the Clear option to unselect all values. Afterwards, click on the options that you want the filter to show. Click on OK to apply the new filter.
In the example above, we’ve decided to only show entries where the shirt size is equal to ‘L’.
The filter should now apply to the current range.
Sometimes, you might need to remove a filter from a given range.
To do this, first select the entire filtered range and then click on the Filter icon shown below.
This guide should be everything you need to create a filter in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to filter in Google Sheets:
- Create Multiple Filters
- Create A Filter View
- How To Filter
- How To Create & Use Filter Views
- Filter By Multiple Conditions
- Filter By Color
- Filter Not Working (How To Fix)
- Filter Unique Values
- Filter by Date Range
- Filter Duplicates
- Filter Google Sheets Only For Me
- Extend Filter Range
- Filter Charts Using Slicer