How to Create a Filter in Google Sheets (and Actually Use It)

Filtering in Google Sheets lets you temporarily hide rows that don’t match what you care about—so you can focus on just the data you need right now. It’s one of the simplest tools that makes a big difference when your spreadsheet gets even a little bit messy.

This walkthrough covers how to create filters, how they work behind the scenes, and what changes depending on your setup and skill level.

What a Filter in Google Sheets Actually Does

A filter in Google Sheets:

• Shows only rows that match certain conditions
• Hides (but doesn’t delete) all other rows
• Lets you stack multiple conditions (e.g., date + status + amount)
• Works in real time—change the filter and the visible rows update instantly

Think of it like putting a transparent overlay on your sheet where you can say:

“Only show rows where Status is ‘Open’ and Amount is greater than 100.”

The underlying data is untouched. You can turn filters on and off without losing anything.

Google Sheets has two main tools that people mix up:

Both let you filter data, but they’re used differently depending on whether you’re alone in the sheet or collaborating.

How to Create a Basic Filter in Google Sheets

The simplest way to start filtering is with the Filter button.

Step 1: Select your data range

• Click any single cell inside your data table, or
• Select the full range (e.g., A1:D500) if you want to be explicit

Your data should ideally:

• Have column headers in the first row (e.g., Date, Name, Amount, Status)
• Be in a continuous block (no completely empty rows or columns in the middle)

Step 2: Turn on the filter

On desktop (browser):

1. Go to the top menu: Data → Create a filter
2. Little filter icons (downward triangles) will appear in your header row

On mobile (Sheets app), the UI changes a bit by platform and version, but generally:

1. Tap a cell in your header row
2. Look for a Filter icon (often under the three-dot menu or in the toolbar)
3. Turn it on so that filter icons appear in the header cells

Step 3: Filter a column

1. Click the filter icon in the header of the column you want to filter

2. You’ll see options like:

   • Sort A → Z / Sort Z → A
   • Checkboxes for “Filter by values”
   • A “Filter by condition” section

3. To show only some values:

   • Uncheck “Select all”
   • Check only the values you want (e.g., only “Open” and “Pending”)

4. Click OK (or just click away on some setups)

Now only rows matching those checked values remain visible.

Step 4: Use “Filter by condition” (for numbers, dates, text rules)

Instead of picking values one by one, you can filter by rules, like:

• Text: “Text contains”, “Text starts with”, “Text is exactly”
• Numbers: “Greater than”, “Less than”, “Between”
• Dates: “Today”, “Yesterday”, “In the last 7 days”, “Before”, “After”, “Between”

Example: Show only invoices over 500:

1. Click the filter icon on your Amount column
2. Go to Filter by condition
3. Choose “Greater than”
4. Enter 500
5. Apply

Now only rows with Amount > 500 are visible.

Using Filter Views for Safer Collaboration

If multiple people use the same sheet, regular filters can get chaotic because:

• When someone changes the filter, everyone else’s view changes too
• People can accidentally hide rows from each other while working

This is where Filter views help.

What is a filter view?

A filter view is like your own saved “lens” on the data:

• You can set filters and sorting without affecting others
• You can name and save different views (e.g., “This Month Only”, “Only Open Tasks”)
• Others can optionally switch to your filter view if they want

How to create a filter view (desktop)

1. Click inside your data
2. Go to Data → Filter views → Create new filter view
3. Your sheet border will turn black and a bar will appear at the top
4. Set filters and sorting like normal using the column filter icons
5. Click the name field (often default like “Filter view 1”) and give it a clear name

You can switch between views via:
Data → Filter views → [Choose your saved view]

You can also close the current filter view from its top-right “X” or by choosing none.

Common Filter Tricks That Make Life Easier

Once you’re comfortable with basic filters, these patterns help a lot:

Filter by multiple columns at once

Filters stack. For example:

• Column B: Status = “Open”
• Column C: Priority = “High”
• Column D: Due date is before today

Only rows that meet all three conditions are shown.

Quickly clear or reset filters

• To clear filters in one column:
  Open the column’s filter menu and choose “Clear” or re-select all values.
• To turn off all filters:
  • Desktop: Data → Remove filter
  • Or click the green filter icon in the toolbar (if shown)

Filter blank and non-blank cells

In Filter by condition:

• Choose “Is empty” to show only blank cells
• Choose “Is not empty” to hide blanks and show only filled rows

This is handy for finding missing data or incomplete entries.

Combine filters with simple formulas

Filters don’t change your formulas—they just hide rows visually. But you can:

• Add a column like “Include?” with a formula (TRUE/FALSE)
• Filter that column on TRUE only

Example: show rows where value is above the column average:

= AVERAGE(B2:B100) // somewhere else, to get the average 

Then in a helper column:

= B2 > $D$1 // assuming D1 holds your average 

Now filter that helper column to only show TRUE.

What Changes How Filters Work for You?

The basics are the same for everyone, but a few variables can dramatically change how you use filters.

1. Device and platform

How you access Google Sheets affects how filters feel to use:

On small screens, selecting ranges and configuring detailed filter conditions can be slower or hidden in submenus.

2. Data size and complexity

A sheet with 50 rows behaves differently from one with 50,000 rows:

• Big, complex sheets may feel slower when you apply or change filters
• Many filter conditions + formulas + shared editing can increase lag
• Structuring data as a clean table with headers and consistent types helps

With very large datasets, some people use filters only for quick views and rely on things like pivot tables or QUERY formulas for heavier analysis.

3. Collaboration style

How many people touch the sheet—and how they work—changes the best filtering approach.

People who are used to spreadsheets usually adapt quickly to filter views; others may need clear names like “Everyone – Default View”.

4. Data types (text, numbers, dates, categories)

How well filters work for you depends on how your data is stored:

• Dates need to be real date values, not text like "01/03/24" sometimes seen as text
• Numbers formatted as text won’t respond correctly to “greater than / less than” conditions
• Categories with inconsistent spelling (“Open”, “open “, “OPEN”) make value filtering harder

Cleaning up those details often makes filters feel “smarter” instantly.

5. Your comfort with more advanced tools

Some users stick with:

• Single-column filters + simple value checks

Others layer:

• Multi-column filters
• Filter views
• Helper columns
• Conditional formatting

The same filter system supports both, but how deep you go depends on your familiarity and patience.

Different Ways People Use Filters in Google Sheets

Because of all those variables, “how to create a filter” turns into very different workflows for different people.

Casual users with small lists

• Device: often phone or basic laptop
• Data: small tables (shopping lists, basic logs)
• Typical use:
  • Tap filter icon
  • Show only one or two values
  • Turn filter off again

They don’t usually save filter views or build complex conditions—they just need quick, temporary focus.

Office users tracking projects or tasks

• Device: mostly desktop
• Data: task lists, project trackers, pipelines
• Typical use:
  • Filter by status, assignee, due date
  • Create named filter views (like “My tasks”, “Overdue only”)
  • Combine filters with sorting for priority

Here, the line between “personal filter” and “team-default filter” becomes important.

Analysts and power users

• Device: desktop, large screen
• Data: large tables, joined data, exports from other tools
• Typical use:
  • Build multiple filter views for different analyses
  • Use Filter by condition with dates and number ranges
  • Add helper columns to control what filters can do
  • Sometimes combine native filters with formulas like FILTER(), QUERY()

For this group, creating filters is just the first step; the details of how data is structured matter much more.

Where Your Own Setup Becomes the Missing Piece

The mechanics of creating a filter in Google Sheets are straightforward: select your data, enable the filter, and choose what to show or hide. From there, things diverge depending on:

• Whether you mostly use desktop or mobile
• How big and messy your data is
• Whether you’re working alone or in a busy shared sheet
• How comfortable you are with tools like filter views, helper columns, and conditions

The right way for you to set up and use filters depends less on the feature itself and more on how your particular sheet is built, who touches it, and what you’re trying to see when you filter.