How do filters work in Google Sheets?
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fastest UI path. FILTER and QUERY formulas build dynamic views that update when source data changes, which suits dashboards and reporting tabs.
When to use it
Use filters when you explore a dataset, share a slice with a colleague, or feed charts only active rows such as open tickets or this-quarter deals.
When to skip it
Skip filters as a security boundary. Hidden rows still export and formulas may still see them. Use separate tabs, access control, or IMPORTRANGE with restricted source files for sensitive cuts.
How it works
-
1
Select a header row and choose Data > Create a filter to enable column dropdowns.
-
2
Pick values, conditions, or custom formulas from each column menu to narrow visible rows.
-
3
Save a filter view to name a configuration and share a link that opens that view.
-
4
For formula filters, =FILTER(A2:E, C2:C="Open") returns only matching rows as a spill range.
-
5
Combine criteria with multiplication for AND or addition for OR inside FILTER boolean arrays.
-
6
Clear filters before bulk edits so you do not change hidden rows by accident.
Examples in Google Sheets
Open deals view
Filter view on Pipeline where Stage is not Closed and Owner is the rep sharing the link with their manager.
Dynamic chart source
FILTER tab outputs rows where Region is West; the chart references only that shrinking range.
Quality check slice
Filter Email column with custom formula =NOT(REGEXMATCH(A1, "@")) to spot rows missing valid addresses.
Better Sheets resources
Common mistakes
-
Editing data while filtered and missing rows that still affect totals on other tabs.
-
Assuming viewers see your filter; they may see the full sheet unless you share a filter view link.
-
Using FILTER with mismatched range heights, causing
-
Stacking manual filter and formula filter on the same range without documenting which is active.
-
Filtering before IMPORTRANGE finishes loading and thinking rows vanished permanently.
Frequently asked questions
- Filter vs filter view?
- Standard filter affects your session. Filter views are named, shareable snapshots of criteria.
- FILTER vs QUERY?
- FILTER is simpler for one-range row tests. QUERY adds SQL-like select, group, and order in one string.
- Can two people use different filters?
- Yes with filter views. Each person opens their named view without fighting the same dropdown.
- Do filters affect formulas?
- Formulas on other tabs still read all data unless you point them at a FILTER range.
- Filter by color?
- Filter menu supports fill color when conditional formatting marks rows you need to review.
- Hide filtered rows in export?
- Copy visible cells only to a clean tab before CSV download if you need an export of the slice.
- FILTER multiple conditions?
- Multiply boolean conditions for AND, add for OR, inside the FILTER include argument.
- Filter locked sheet?
- Editors can filter unless protection blocks it. Viewers cannot create filters without edit access.
Related Tutorials
Watch how filters in Google Sheets works
Search Every Function in Google Sheets
Scrape Google Maps
Make Your Headers Useful
Embed a Number in a Website from a Google Sheet
Related blog posts
Guides that explain filters in Google Sheets in more depth.
Quick Google Sheets Tips
Boost productivity and streamline your workflow in Google Sheets with our quick tips and free tools. Breathe new life into your spreadsheets today.
Read post →Google Sheets Interface Changes
New Date Chips and Integration with Google Workspace makes Google Sheets much more useful, within the ecosystem. It's a great tool within workspace now.
Read post →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 →Related terms
sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function returns a sorted copy that updates when inputs change. Always decide whether related columns must move together as a single row unit.
Read guide →SQL-style queries (QUERY)
The QUERY function runs a SQL-like statement against a range in your sheet. You SELECT columns, filter with WHERE, sort with ORDER BY, and aggregate with GROUP BY without building many helper columns. It is the closest native option to a small in-sheet database query.
Read guide →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
Read guide →conditional formatting
Conditional formatting changes how cells look when they meet rules you define, such as values above a target or dates in the past. It helps scanners spot problems fast without writing values into extra helper columns. Rules can be simple comparisons or custom formulas that reference other sheets.
Read guide →Done reading about filters in Google Sheets?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.