How To Add Filters To Columns In Google Sheets (Step‑By‑Step)

Filtering in Google Sheets lets you temporarily hide rows that don’t match certain criteria, so you can focus on just the data you care about. Instead of deleting or moving anything, filters act like a view: the data is still there, just not shown until you clear the filter.

This is especially useful when you’re working with long lists: budgets, sales logs, task lists, survey responses, or any kind of table.

Below is a practical guide to adding filters to columns in Google Sheets, plus the key options and differences that matter depending on how you work.

What does “adding a filter to a column” actually do?

When you add a filter in Google Sheets:

• Tiny filter icons appear in the header row of the selected columns.
• You can click each icon to:
  • Show or hide rows based on values (e.g., only “Completed” tasks).
  • Use conditions (e.g., numbers greater than 100, dates after 1/1/2024).
  • Sort the column A→Z / Z→A or smallest→largest.

Important points:

• Filtering does not change your data. It just hides some rows from view.
• Filters are applied row by row: if a row is filtered out in one column, it disappears across the whole sheet.
• There are two main ways to filter:
  • Filter (basic) – one common view everyone sees.
  • Filter views – multiple saved views different people can use without affecting each other.

How to add a basic filter to your columns

Use this when you want a quick, simple filter that affects the whole sheet for everyone who opens it.

Step 1: Make sure your data is set up correctly

For filters to work well:

• Your data should be in a table format:
  • One header row with labels (like “Name”, “Status”, “Amount”).
  • Data starts on the row below the headers.
• No completely empty row splitting the table into parts.
• Ideally, no extra unrelated data directly touching your table.

Example layout:

Step 2: Select the range (or let Sheets detect it)

You can:

• Click any cell inside your table and let Sheets guess the range, or
• Manually select your entire range, including headers (for example: A1:C100).

If your sheet has a clear header row and no gaps, simply clicking one cell is usually enough.

Step 3: Turn on the filter

Use one of these methods:

• Menu:

  1. Click Data in the top menu.
  2. Click Create a filter.

• Toolbar button:

  1. Look for the funnel icon in the toolbar (Filter).
  2. Click it.

You should now see little funnel icons in each column header.

Step 4: Filter by values

To quickly show or hide specific values:

1. Click the filter icon in the header of the column you want to filter.
2. In the dropdown, under Filter by values:
   • Uncheck Select all.
   • Check only the values you want to keep visible (for example, only “Completed”).
3. Click OK.

Now only rows with those selected values appear. Other rows are hidden, not deleted.

Step 5: Filter by condition (more advanced)

Conditions let you filter based on rules instead of exact matches.

1. Click the column’s filter icon.
2. Choose Filter by condition.
3. Pick a condition type, such as:
   • Text contains / Text does not contain
   • Is empty / Is not empty
   • Greater than / Less than or equal to
   • Date is before / Date is after
4. Enter the value or text to compare against (for example: greater than 100).
5. Click OK.

Examples:

• Filter a “Status” column to show only rows where text contains “pending”.
• Filter an “Amount” column to show only numbers greater than 100.
• Filter a “Date” column to show only dates after a certain day.

Step 6: Sort while you’re at it

The same filter dropdowns can sort the column:

• Sort A → Z / Sort Z → A (for text, dates).
• Sort smallest → largest / largest → smallest (for numbers).

Sorting works on the visible data, rearranging entire rows. Filters and sorting often work together: for example, filter to show only “Completed” tasks, then sort by date.

Step 7: Turn the filter off (and on again)

To remove the filter completely:

1. Click Data in the menu.
2. Click Turn off filter.

This:

• Removes the funnel icons from the header row.
• Shows all rows again.
• Clears filter settings (you’d need to set them again if you turn it back on).

How to use Filter Views (per-user filters without affecting others)

Basic filters change what everyone sees. If multiple people are viewing or editing a sheet at once, that can be confusing.

Filter views are different:

• You create a named filter setup (for example, “My tasks only”).
• Each person can turn on their own filter view.
• Your filters don’t change what others see.

Creating a new filter view

1. Select your data range (or click inside it).
2. Go to Data > Filter views > Create new filter view.

You’ll notice:

• The sheet gets a black border around the filtered area.
• A bar appears at the top where you can name the filter view.

3. Name your filter view (e.g., “Pending tasks”).
4. Use the filter icons in the header just like basic filters:
   • Filter by values
   • Filter by condition
   • Sort the columns

These choices are now saved with that filter view.

Switching between filter views

To switch:

1. Go to Data > Filter views.
2. Choose the saved view you want.

To go back to the normal unfiltered sheet:

• Click None under Data > Filter views, or
• Close the filter view using the “X” in the black bar.

Filter views are helpful for:

• Teams where each member wants a different slice of the data.
• Reusable setups (for example, “This Month’s Orders”, “High Priority Only”).

Filter options and behaviors that can surprise you

A few details can affect how filters work:

1. Headers vs. data

• If your headers (row 1) are included in a numeric or date filter, conditions might try to interpret them as data.
• Google Sheets typically assumes the first row is a header, but very unusual headers (like actual numbers) can confuse this.
• It’s safer to have clear text labels in your header row.

2. Mixed data types in one column

If a column contains a mix of:

• Numbers (like 100),
• Text (like “N/A”),
• Dates (dates are actually stored as numbers),

then filters and sorts can behave unexpectedly:

• Sorting may group all text separately from numbers.
• Number-based conditions may skip text entries.

Keeping each column to a single type of data (all numbers, all dates, or all text) makes filters more predictable.

3. Hidden rows vs. filtered-out rows

• Hiding rows manually (right-click > Hide row) and filtering are different features, but they stack.
• If a row is manually hidden, filters do not unhide it.
• Filtered-out rows are still influenced by sort order, but remain invisible until you change or remove the filter.

4. Shared vs. private filters

• Regular filters:
  • Affect everyone viewing the sheet.
  • Good for solo work or when everyone agrees on the same filtered view.
• Filter views:
  • Are user-specific and can be saved.
  • Better for shared sheets where people need different views of the same data.

Key variables that affect how you should use filters

The best way to add and use filters in Google Sheets depends on several factors:

1. How many people are using the sheet?

• Just you:
  • Simple “Create a filter” is often enough.
  • You might not need filter views unless you want multiple saved setups.
• Small team:
  • Filters can cause confusion if one person constantly changes them.
  • Filter views help each person maintain their own perspective on the data.
• Larger groups:
  • Filter views are usually safer.
  • Standardizing which views exist (e.g., “Team A only”, “Overdue items”) becomes more important.

2. Type and complexity of your data

• Short lists (under ~100 rows):
  • Basic filters and one or two conditions are usually all you need.
• Long tables (thousands of rows):
  • Conditions, multiple columns filtered at once, and smart sorting matter more.
  • You may combine filters with formulas (like FILTER) for even more control.
• Mixed data (lots of text, numbers, dates together):
  • Requires more careful setup of column types to avoid confusing filter results.

3. How often the data changes

• Static or rarely updated:
  • You might set one filter or filter view once and barely touch it.
• Frequently updated:
  • Filters might need to be adjusted regularly so new rows aren’t accidentally hidden.
  • You may prefer simple, broad filter conditions so they keep working as data grows.

4. Your comfort level with spreadsheet features

• Beginner:
  • Start with:
    • Turning on a basic filter
    • Selecting values to show/hide
    • Using simple sort A→Z or Z→A
• Intermediate:
  • Add:
    • Filter by condition: numbers (> / <), dates, text contains
    • Filter views for personal or team-specific views
• Advanced:
  • Combine built-in filters with:
    • Formulas like FILTER, QUERY, SORT
    • Multiple filter views tailored to roles or reporting needs

How different setups lead to different filter strategies

Here’s how the same “add filters to columns” feature can look very different in practice:

The same steps—turn on filter, choose values/conditions, sort—are used in all of these, but the how often, how many views, and who else is affected change the best approach.

Where your own situation fills in the last piece

Once you know how to:

• Turn on a filter and use the filter icons,
• Choose between filter by values and filter by condition,
• Decide when to use basic filters vs. filter views,

the remaining questions are less about Google Sheets itself and more about you:

• How many people need to look at this data, and do they each need their own view?
• How large is your dataset, and how often does it change?
• Are you mostly filtering simple lists, or more complex tables with mixed data types?
• Do you want quick one-off filters, or a set of named views you’ll reuse over time?

Those details shape which filtering habits will feel smooth and which might create confusion or extra work. The underlying tools in Google Sheets are the same—you’ll tune how you use them based on your own setup, workflow, and comfort level.