How to Filter in Google Sheets: Step-by-Step Guide

How-to basics · Updated November 20, 2026

To filter data in Google Sheets, select a cell in your table, choose Data > Create a filter, then use the filter button in a column header to set the values or conditions you want to see. Filtering hides rows that do not match; it does not delete them. Before you begin, make sure your table has a clear header row and that the data you want to filter is together in one range.

What You’ll Need

  • A Google account with access to the spreadsheet.
  • A web browser and the sheet open in Google Sheets. These steps describe the browser version; the mobile app has a different, more limited interface.
  • A table with one heading per column and one record per row. For example, a sales list might have columns for Date, Product, Region, and Amount.
  • Edit access if you need to create or change a standard filter. If you only have view access, you may be able to use a filter view depending on the sheet’s permissions.

Step-by-Step

  1. Check and prepare the data. Put a meaningful heading at the top of every column, such as Date, Customer, or Status. Keep each record on a single row, and avoid blank rows or blank columns inside the table. The filter works on a selected range, so gaps can make Google Sheets treat only part of your data as the table. If other content sits beside the list, plan to select just the table rather than letting the filter include unrelated cells.
  2. Select the data range. Click a cell inside the table if it is a continuous, clearly separated block. Google Sheets will usually detect the surrounding range. To be precise, drag across the table including the header row, or click the name box to the left of the formula bar and enter a range such as A1:D50. Include every row and column you want filtered, including the headings. If your data has no header, add one first; otherwise the first record may be treated as a heading.
  3. Turn on the filter. In the Google Sheets menu, select Data > Create a filter. Filter icons appear beside the headings in the selected range. If the range was detected incorrectly, choose Data > Remove filter, select the intended range, and create the filter again. Creating a filter does not remove or rewrite records; it adds controls for hiding rows from view.
  4. Open the menu for the column you want to filter. Click the filter icon in that column’s heading. The panel includes options for filtering by values and by condition. Choose the method that fits your question. For instance, to view orders from one region, use the Region column; to find high-value orders, use the Amount column. You can apply filters to more than one column, and the sheet will show rows that meet all the active filters.
  5. Filter by specific values. In the column menu, use the list of values to choose which entries remain visible. Clear Select all, then check only the values you want, such as West and Central in a Region column. You can use the search field in the list to find a particular value in a long set of choices. Click OK to apply the selection. The rows with unchecked values are hidden, not erased. This option is convenient when you know the exact labels or categories to include.
  6. Filter by a condition when you need a rule. Open the column menu and select Filter by condition. Choose an available rule suited to the column, such as text contains, date is, or greater than, then enter the text, date, or number to check. For example, in an Amount column you could set a greater-than condition and enter 100 to show records above that amount. Check the column’s data types first: a number stored as text or inconsistent date values can cause results to differ from what you expect. Apply the condition from the filter panel.
  7. Combine filters and review the results. Repeat the process in another column to narrow the list further. For example, filter Region to West and Status to Open to show open records from the West. Multiple column filters work together, so a row must meet every active condition to appear. Look at the visible headings and a few result rows to confirm that the criteria match your request. If nothing appears, clear one criterion at a time to find which condition is excluding the rows.
  8. Clear a filter or remove the filter controls. To show all values in one column again, open its filter menu and restore all values or clear the condition. Other column filters remain active, so clear those separately if you want the full list back. To turn off the filter controls altogether, choose Data > Remove filter. This restores the rows hidden by filtering and removes the header icons; it does not delete the data. Avoid deleting visible rows as a substitute for clearing a filter.
  9. Use a filter view for a personal or reusable view. If collaborators should not have their sheet view changed by your filtering, choose Data > Filter views > Create new filter view. Set criteria with the filter icons as above. Use the name field at the top of the view to give it a clear label, such as “Open West orders.” Close the filter view when finished; return to it from Data > Filter views. A filter view is useful for saved sets of criteria or when several people need to examine the same data independently.

Google Sheets runs in a browser, so the menu names above refer to that version. In Excel for Microsoft 365 on Windows, the comparable command is typically Data > Filter, but its menus and saved-view features are different. Do not follow Excel instructions such as its ribbon or Table Filter menus when working in Google Sheets.

Common Mistakes

  • Including the wrong range: If a heading has no filter icon, or some records never change, the table range may not cover all columns or rows. Remove the filter and recreate it with the full range selected.
  • Leaving blank rows in the middle of the list: A blank row can make automatic range detection stop early. Remove the gap or explicitly select the complete table before creating the filter.
  • Using duplicate or unclear headings: Give each column a distinct label. Headings make it easier to select the correct filter menu and help collaborators understand what the conditions mean.
  • Expecting hidden rows to be deleted: A filter only hides nonmatching rows. Clearing the filter brings them back. Do not paste over or delete visible data unless you truly intend to change the sheet.
  • Filtering one column and overlooking another: A previous filter may still be active and narrowing results. Check each header for an active filter and clear criteria you no longer need.
  • Mixing data formats: Values such as 10, “10,” and “$10” may not behave as equivalent numbers. Standardize number, date, and text formats when a condition returns unexpected results.
  • Confusing sorting with filtering: Sorting changes row order; filtering hides rows that do not meet criteria. If you only want to focus on a subset, use filter criteria rather than deleting or rearranging records unintentionally.

Tips

  • Use a filter view when you want to explore the data without imposing a standard filter on the shared sheet. Name views by their purpose so people can find the right one later.
  • Choose concise, consistent category labels. If a column contains “North,” “north,” and “N.”, those may appear as separate values, making it harder to select the intended records.
  • For a large value list, type in the filter panel’s search box rather than scrolling. Confirm the checked values before applying the filter.
  • When checking a result, note that multiple criteria are combined. A row that matches the Region filter but not the Status filter will still be hidden.
  • Keep a header row visible while reviewing a long sheet by choosing View > Freeze and selecting an appropriate row option. Freezing is separate from filtering, but it makes filtered results easier to interpret.
  • If you need to share a particular analysis, tell collaborators whether you used a standard filter or a filter view. That small note helps them understand why their displayed rows may look different.

Troubleshooting

No filter icons appear: Confirm that you chose Data > Create a filter and selected a range that includes the headings. If the menu option is unavailable, check whether you have edit access, whether the sheet or range is protected, or whether the selection is inside an existing filter view. A protected range can restrict changes even when you can see the data.

Some rows are missing from the filtered range: Remove the filter, select the complete table explicitly, and create it again. Look for blank rows, blank columns, or recently added records below the original range. New rows may need to be included in the filtered range rather than assumed to be part of it.

The filter returns no results: Reopen the relevant column menus and check the selected values and conditions. Try clearing one filter at a time. Check for extra spaces, spelling differences, mixed text and number formats, and dates stored as plain text. A condition such as “text contains” will not behave like a numeric comparison, so use a rule appropriate to the data.

A collaborator says the sheet changed: If you used a standard filter, it can affect the shared sheet’s displayed rows for other editors. Clear it with Data > Remove filter or use a filter view for independent analysis. If the collaborator is in a filter view, ask them to close it or choose the view they need.

The filter menu or view option is unavailable: Refresh the browser tab, confirm you are signed in to the account with the required permissions, and check whether the file is in view-only mode. If the spreadsheet is an Excel file opened in Google Sheets, save or convert it to Google Sheets format if a Google Sheets feature is not available in the current file.

Frequently Asked Questions

Does filtering delete rows in Google Sheets?
No. Filtering hides rows that do not meet the selected values or conditions. Clear the filter to display the hidden rows again.

Can I filter more than one column at once?
Yes. Apply a criterion from each relevant column menu. The visible rows must match all active filters, which lets you narrow a table by combinations such as region and status.

Can other people see my filter?
A standard filter affects the shared sheet view. Use a filter view when you want a separate view for your own analysis or want saved criteria that collaborators can open without applying a standard filter to everyone.

How do I show all rows again?
Open each filtered column menu and clear its criteria or restore all values. To remove the filter controls as well, select Data > Remove filter.

Can I filter dates or numbers, not just text?
Yes. Choose Filter by condition in the relevant column and select a date or numeric rule, such as a date range or greater than. Make sure the cells contain actual dates or numbers rather than text that only looks like them.

Will these steps work in Excel?
Not exactly. This guide is for Google Sheets in a browser. Excel has its own filter command and interface; in Excel for Microsoft 365 on Windows, start with Data > Filter.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.