How to add and use filters in Google Sheets

When you analyze your tables in Google Sheets, very often you need only a part of the information, while the table may contain dozens of various datasets. What's more, a bunch of various values may simply interfere.

Sure, you can always duplicate the table and delete those temporarily unwanted values. But isn't it a waste of time?

That is when filters in Google Sheets lend a helping hand.

So, what is a "filter"? It's one of many Google Sheets options that lets you hide a part of data that you don't need at the moment. This way you don't need to delete the data. You simply hide it temporarily and can display it back any time.

Besides, this enables you to sort the data. Isn't that a pleasant perk? 😊

How to filter your data in Google Sheets?

To filter your table, you need to select the range of interest manually.

But something tells me you have loads of data. You wouldn't filter it otherwise, wouldn't you?

So, to do the job faster, I advise you to select entire columns. I explained how to do that in one of my previous articles.

If you want to filter the entire table, just click its any cell and go to Data > Filter right away:
Filter data using the Google Sheets menu.

Or simply use a corresponding button on the Google Sheets toolbar:
Filter option on the Google Sheets toolbar.

Note. When you enable a filter, it will work for all columns with data. If you have completely empty columns, the filter will treat them as the end of your table. You can include them by selecting the range with the table manually.
Tip. You may want to lock the first row of the table that contains filter buttons. This way you won't have to scroll all the way up to adjust filter settings:

Freeze the first row to have a quick access to filter settings.
So, the filter is there. Each column header contains kind of an upside-down triangle icon meaning that the filter is active.

Now, let's try and adjust it.

Filter by values in Google Sheets

Today we'll cover the most basic filter option - filter by value. Decide by which column you'd like to filter first and click the triangle icon next to that column header:
The triangle icon opens filter options.

Uncheck all the values you want to hide temporarily and click OK.

You'll notice that some of the data has disappeared from the screen right away. Don't worry, the entries weren't deleted. They are there, in your table, you just don't see them because of the filter.

You can sort the remained values either A to Z or Z to A:
Sort the rest of your data A to Z.

Tip. The filter icon changes next to those column headers where the filter is applied.

If necessary, you can always set additional filters. I'll do that using the Product column, to see the information about Dark Chocolate only:
Apply additional filter to a table using another column.

As a result, both filters are applied to the whole table and there are even fewer entries than before:
Two filters are applied to our table.

The rows we see now meet our two requirements.

So, filtering the table by values is not a rocket science. However, this method is enough if you have a relatively small table with a few parameters that you want to display.

Will that be enough if the list of values contains 100+ entries? Well, that's a story for another day.

Next time you'll learn how to apply filters by conditions in Google Sheets and share different filtering results with different people within one document.

You may also be interested in:

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools - Ablebits.com
60+ professional tools for Excel
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard