How to create multiple filters in Google Sheets
Select your header row and choose Data → Create a filter (funnel icon). Use the column menus to filter values. Filter views (Data → Filter views) save personal filters without changing what collaborators see. FILTER() builds a formula-based filtered table elsewhere.
Steps
-
1
Select the header row of your table.
-
2
Data → Create a filter.
-
3
Use each column’s funnel to narrow rows.
-
4
Try Filter views for saved, personal filters.
Related tutorials
These videos might help you go deeper on this topic.
Make Your Headers Useful
How to Make a Marketplace in a Google Sheet
Fabulous Filters
Combine Filters in One Column
Search Every Function in Google Sheets
Related blog posts
Written guides that go deeper on this question.
Filter a Database in Google Sheets based on Dates, Checkboxes, and Dropdown selections!
In today’s tutorial, we’ll be answering the question from Mohamed. The question is “How do I filter a database in Google Sheets based on dates, checkboxes, and dropdown selections?”
Read post →Create a Many to Many Database inside Google Sheets
Master Google Sheets & simplify work with this tutorial on creating a many-to-many database. No more manual entry! Learn, apply & save time.
Read post →Automate Google Sheets without Apps Script, without Zapier
I've been doing a lot in spreadsheet automation using Apps Script. But I wanted to go back to some formulas that I think feel like magic. They make me feel like a wizard without having to code.
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Filter view
A filter view is a saved set of column filters with its own name and optional owner color. Each collaborator can open...
Open →filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fast...
Open →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same he...
Open →Google Sheets formulas
A formula is an instruction in a cell that calculates a result from other cells, ranges, or built-in functions. Every...
Open →Google Sheets formula syntax
Every formula starts with = followed by a function name and arguments in parentheses. Ranges use A1 notation, text si...
Open →Freeze rows and columns
Freezing locks the top rows or left columns in place while the rest of the sheet scrolls. View > Freeze lets you pin ...
Open →COLUMN()
Google Sheets COLUMN() function guide
Open →FILTER()
Google Sheets FILTER() function guide
Open →ROWS()
Google Sheets ROWS() function guide
Open →Related questions
How to add multiple filters in Google Sheets
Select your header row and choose Data → Create a filter (funnel icon). Use the column menus to filter values. Filter views (Data → Filter views) save personal filters without changing what collaborators see. FILTER() builds a formula-based filtered table elsewhere.
Get the answer →How to remove filters in Google Sheets
Select your header row and choose Data → Create a filter (funnel icon). Use the column menus to filter values. Filter views (Data → Filter views) save personal filters without changing what collaborators see. FILTER() builds a formula-based filtered table elsewhere.
Get the answer →How to clear filters in Google Sheets
Select your header row and choose Data → Create a filter (funnel icon). Use the column menus to filter values. Filter views (Data → Filter views) save personal filters without changing what collaborators see. FILTER() builds a formula-based filtered table elsewhere.
Get the answer →How to clear all filters in Google Sheets
Select your header row and choose Data → Create a filter (funnel icon). Use the column menus to filter values. Filter views (Data → Filter views) save personal filters without changing what collaborators see. FILTER() builds a formula-based filtered table elsewhere.
Get the answer →What does filtering data in a spreadsheet do
Select your header row and choose Data → Create a filter (funnel icon). Use the column menus to filter values. Filter views (Data → Filter views) save personal filters without changing what collaborators see. FILTER() builds a formula-based filtered table elsewhere.
Get the answer →How to count filtered rows in Google Sheets
Select your header row and choose Data → Create a filter (funnel icon). Use the column menus to filter values. Filter views (Data → Filter views) save personal filters without changing what collaborators see. FILTER() builds a formula-based filtered table elsewhere.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.