How To Create A Filter In Google Sheets

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.

Step 1

Select the range you want to apply a filter to.

In this example, we want to add a filter to columns A through E.

Step 2

Select the option Data > Create a filter.

Step 3

Your range’s headers should now have a filter icon for each column.

Step 4

Identify a field you want to filter with. Click on that field’s filter icon to reveal the available filter options.

Step 5

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’.

Step 6

The filter should now apply to the current range.

Step 7

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.

Summary

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.