What a filter does and when you need one

A filter in Google Sheets lets you hide rows that don't match what you're looking for, so you see only the data you want. If you have a spreadsheet with 500 customer records and you need to see only the ones from California, a filter shows you those rows and hides the rest. The original data stays unchanged — you're just controlling what's visible on screen.

Filters are useful the moment your spreadsheet has more than a few dozen rows. They save you from scrolling endlessly or manually deleting rows you don't need to see right now. You can filter by text (like a state name), by number (like sales over $1,000), or by date (like orders from the last 30 days). You can also stack multiple filters at once — show me California customers who spent more than $1,000 in the last month.

The filter itself is not permanent. You can turn it off and see all rows again, or change the filter to show different data. This is different from sorting, which rearranges rows in a specific order. Filters hide rows; sorting reorders them.

Key Takeaways

  • Click any cell in your data, then click the filter icon in the toolbar to turn filtering on for the entire table.
  • Once filtering is on, dropdown arrows appear in the header row, and you click those arrows to choose which rows to show or hide.
  • You can filter by text match, by number range, by date range, or by custom conditions like "greater than" or "contains".
  • Filters hide rows but do not delete them, and you can remove the filter at any time to see all rows again.
  • You can explore multiple filters to the same table to narrow down results by more than one column.

How to turn on filtering for your data

Start by clicking any cell inside the table or range you want to filter. It doesn't matter which cell — Google Sheets will detect the entire connected block of data. If your data has a header row (the first row with column names like "Name", "State", "Sales"), make sure that row is included.

Look at the toolbar at the top of the screen. You'll see a funnel-shaped icon — that's the filter button. Click it. Google Sheets will add a dropdown arrow to every cell in the header row. Those arrows are how you control what rows appear.

If you don't see the filter icon in the toolbar, you may be looking at the wrong place. The toolbar is the row of buttons directly below the menu bar (File, Edit, View, Insert, Format, Data, Tools, Extensions, Help). The filter icon looks like a funnel and is usually near the sort buttons. If you still can't find it, go to the Data menu at the top and click "Create a filter" from the dropdown.

Filtering by text or category

Click the dropdown arrow in the header of the column you want to filter. A menu appears with a list of every unique value in that column. If you're filtering a "State" column, you'll see a checkbox next to Alabama, Alaska, Arizona, and so on.

By default, all values are checked (all rows are visible). To hide rows, uncheck the values you don't want to see. For example, uncheck every state except California. The spreadsheet when ready hides all rows where the state is not California. The row numbers on the left turn blue to show that some rows are hidden.

To show those rows again, click the dropdown arrow again and check the boxes you unchecked. Or click "All" at the top of the menu to check everything at once. The hidden rows reappear.

If your column has many values (like a list of 500 customer names), you can type in the search box at the top of the filter menu instead of scrolling. Type "John" and the menu shows only names containing John, so you can check just those.

Filtering by number or date range

When you click the dropdown arrow in a column with numbers or dates, the menu looks different. Instead of a straightforward checkbox list, you see options like "Greater than", "Less than", "Between", and "Is empty". These let you show only rows that meet a condition.

To show only sales over $5,000, click the dropdown in the "Sales" column, then click "Greater than". A box appears where you type 5000. Click OK, and the sheet shows only rows where sales are greater than $5,000. All other rows hide.

For dates, you can pick a specific date range. Click the dropdown in a date column, then click "Between". Two date boxes appear. Enter a start date and an end date, then click OK. The sheet shows only rows within that range.

You can also click "Is empty" to show only rows where a column has no value, or "Is not empty" to hide blank rows. This is useful for finding incomplete records.

Using multiple filters at once

You can filter by more than one column to narrow your results further. After you set the first filter, click the dropdown arrow in a second column and set another condition. Both filters work together.

For example, filter the "State" column to show only California, then filter the "Sales" column to show only sales over $5,000. Now the sheet displays only California customers who spent more than $5,000. If you add a third filter on the "Date" column to show only orders from the last 90 days, all three conditions must be true for a row to appear.

To remove one filter without removing the others, click its dropdown arrow and click "Clear" or "All" to reset it. To remove all filters at once, click the filter icon in the toolbar again. Google Sheets turns off filtering entirely and shows every row.

What happens to your data when you filter

Filtering only hides rows — it does not delete them or change them. If you copy and paste data from a filtered sheet, you copy only the visible rows, not the hidden ones. This is useful if you want to copy just the California customers to a new sheet.

If you sort a filtered sheet (by clicking Data > Sort range), the sort applies only to the visible rows. Hidden rows stay hidden and don't move. This can be confusing, so be aware that sorting and filtering together can make your data look different than you expect.

Filters are stored with your spreadsheet. If you close the file and open it again, the filters are still there in the same state. If someone else opens the file, they see the filters too, but they can change them without affecting what you see — each person's view is independent.

Removing or changing a filter

To turn off all filters and see every row again, click the filter icon in the toolbar. The dropdown arrows disappear from the header row, and all hidden rows reappear. Your data is unchanged.

To change a single filter without removing the others, click its dropdown arrow again and adjust the condition. For example, if you filtered to show only California, you can click that dropdown and add Arizona to show both states. The other filters stay in place.

If you want to start fresh with a new filter setup, turn off the current filter by clicking the filter icon, then turn it back on by clicking the filter icon again. This removes all the old filter settings and gives you a clean slate.

Frequently Asked Questions

Can I filter by more than one value in the same column?

Yes. Click the dropdown arrow in that column and check the boxes next to every value you want to see. For example, check California, Texas, and Florida to show rows from all three states. Uncheck the rest. The sheet shows only rows matching any of those three values.

What's the difference between filtering and sorting?

Sorting rearranges rows in a specific order, like A to Z or smallest to largest. Filtering hides rows that don't match your condition. You can use both at the same time — filter to show only California, then sort those rows by sales from highest to lowest.

If I filter my data and copy it, do I copy the hidden rows too?

No. When you copy a filtered sheet, you copy only the visible rows. Hidden rows are not included. This is useful if you want to copy just the filtered results to a new sheet or document.

Can I filter by a custom condition like "contains" or "starts with"?

Yes. Click the dropdown arrow in the column you want to filter, then look for an option like "Filter by condition" or a search box. You can type text to match partial values — for example, type "John" to show all names containing John, even if the full name is "John Smith" or "Johnson".

Do filters save when I close the file?

Yes. Filters are part of your spreadsheet and stay in place when you close and reopen the file. If you share the file with others, they see the filters too, but each person can change them independently without affecting what others see.