Filters let you hide rows that don't match what you're looking for

A filter in Google Sheets hides rows based on rules you set. If you have a spreadsheet with 500 rows of sales data, a filter can show you only the rows where the region is "West" or the amount is over $1,000. The hidden rows are still there — you're just not looking at them.

Filters work on columns. You pick which columns get filter buttons, then click those buttons to set rules. Google Sheets calls this a "filter view" when you save it, so you can switch between different filtered views of the same data without deleting anything.

The fastest way to add filters is to select your data and click the filter icon in the toolbar. This takes about 10 seconds and works whether your data is 10 rows or 10,000.

Key Takeaways

  • Click any cell in your data, then click the filter icon in the toolbar to add filter buttons to the top row of your data range.
  • Click a filter button to choose which values to show — you can pick specific entries, hide blanks, or set number ranges.
  • Multiple filters work together, so filtering by region and then by amount shows only rows that match both rules.
  • Filters hide rows but don't delete them, and you can clear a filter at any time to see all rows again.
  • You can save different filtered views with different names so you don't have to rebuild the same filters twice.

Add a filter in three clicks

Click any cell inside the data you want to filter. It doesn't matter which cell — Google Sheets will figure out where your data starts and stops.

Click the filter icon in the toolbar. It looks like a funnel. Google Sheets will add a small dropdown arrow to the top row of your data, one arrow per column. If your data doesn't have a header row, Google Sheets treats the first row as headers anyway.

That's it. Your filters are now active. Click any dropdown arrow to start hiding rows.

Use filter buttons to show only what you want

Click the dropdown arrow in any column. A menu appears with a list of every unique value in that column, plus options at the top.

To show only certain values, uncheck the ones you don't want. For example, if the column lists product names and you only care about "Widget A" and "Widget B", uncheck everything else. Click OK and Google Sheets hides all rows where the product is something different.

To hide blank cells, uncheck the empty box at the top of the list. To show only blanks, uncheck everything except the empty box.

The filter button turns blue when a filter is active on that column, so you can see at a glance which columns are filtering your view.

Filter by number ranges and text patterns

Click the dropdown arrow and look for Filter by condition near the top of the menu. This opens a second menu where you can set rules instead of picking individual values.

For numbers, you can choose "greater than", "less than", "between", "equals", or other options. Type the number you want to compare against. For example, "greater than 500" shows only rows where that column's value is above 500.

For text, you can filter by "contains" (shows rows with that word anywhere in the cell), "starts with", "ends with", or "equals exactly". Type the text you're looking for. A filter for "contains invoice" shows rows where the text includes the word "invoice" but also "invoices" or "invoice number".

You can set up to two conditions and choose whether both must be true or just one. Click OK to apply the filter.

Combine filters on different columns

Filters stack. If you filter column A to show only "North" and then filter column B to show only amounts over $1,000, Google Sheets shows only rows where both conditions are true.

This is useful when you need to narrow down a large dataset. Start with the broadest filter (maybe region), then add more specific ones (maybe date range, then product type). Each filter you add removes more rows from view.

The filter buttons on columns that have active filters turn blue so you remember which columns are filtering. Columns without filters show all their values.

Clear or remove filters

To turn off a single filter and see all values in that column again, click its dropdown arrow and select Clear. The button stops being blue.

To remove all filters at once, click the filter icon in the toolbar again. Google Sheets removes all the dropdown arrows and shows every row. Your data is unchanged — you're just not filtering anymore.

If you want to keep a set of filters but try a different view, use filter views instead. Click Data in the menu, then Filter views, then Create new filter view. Name it something like "North Region Only" and set up your filters. You can switch between saved views without rebuilding filters each time.

What happens when you add or change data

If you add new rows to a filtered spreadsheet, Google Sheets automatically includes them in the filter range. If the new row matches your filter rules, it appears. If it doesn't, it stays hidden until you clear that filter.

If you add a new column, it won't have a filter button until you recreate the filter. Click the filter icon again to add buttons to all columns including the new one.

Filters don't affect sorting. You can sort a filtered view by any column, and Google Sheets will sort only the visible rows. Hidden rows stay hidden and keep their original order.

Frequently Asked Questions

Can I filter by color or formatting?

No, filters only work on the actual values in cells, not on colors or bold text. If you need to filter by appearance, you'll need to add a helper column with a formula or value that marks which rows you want to see, then filter by that column instead.

What if I filter and then sort — does the sort affect hidden rows?

No. Sorting only rearranges the visible rows. Hidden rows stay hidden and don't move. If you clear the filter later, the hidden rows return in their original order, not in the sorted order.

Can I copy only the filtered rows to another sheet?

Yes. Select the visible cells (click the top-left corner to select all, or drag to select a range), copy them, and paste into another sheet. Google Sheets copies only what you see, not the hidden rows. The pasted data won't have filter buttons unless you add them.

Do filters slow down my spreadsheet?

No. Filters just hide rows — they don't change how the spreadsheet calculates or stores data. Even with thousands of rows and multiple active filters, performance stays the same.

Can I share a filtered view with someone else?

If you save your filters as a filter view (Data > Filter views > Create new filter view), you can share the spreadsheet and the other person can switch to that view. They'll see the same filtered data you set up, though they can also create their own views.