How To Create A Filter In Google Sheets

In this tutorial, you volition larn how to filter in Google Sheets.

How To Filter In Google Sheets

When working with large datasets in Google Sheets, you might come across circumstances when y'all demand 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 information technology easy to quickly filter data sets even so y'all need at the moment, the hands update those filters, all without modifying the original dataset

Creating a Filter

Earlier you create your filter, you'll need a dataset to filter in Google Sheets.

Set upward your dataset in a table with headers labeling each cavalcade so follow the steps below to create a filter.

Step one

Select the range or tabular array you want to filter, beingness sure to include the headers

Step 2

Open the Data menu and click on Create a Filter

Step three

You will see that the filter has been added because the column alphabetic character headers will plough light-green and filtering icons will announced on the correct side of each header jail cell

Footstep 4

To start filtering your data, click on one of the filter icons in the header cells to open up the filtering menu for that column. The main filtering section is at the lesser of the card

Step five

In the filtering section at the bottom of the filter menu, you'll meet a list of all values in that column. You tin can click on each value to toggle the visibility of rows that contain that value

Step half dozen

You lot can click on the Select All or Clear links higher up the list to turn all values on or off. If you don't immediately see the values you're looking for, scroll down or apply the search box above the list to find the exact value you want to toggle

Step seven

When you're washed selecting the values you desire to brandish, scroll to the bottom of the filter menu and click OK to filter your data range based on the selected values

Pace 8

But rows with the selected value(s) will display in your dataset.

That'due south it. You lot now take a filter gear up on your data range and can update the values you want to display at any fourth dimension by following Steps 4-7 to a higher place

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 card and click on the Select All selection, then click OK to display all your data again.

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to filter in Google Sheets. Want more than? Check out all the Google Sheets Tutorials.