How to Filter Rows in Google Sheets

To filter rows in Google Sheets, select a cell in your data, choose Data > Create a filter, then use the filter icon in a column header to choose which rows to show. Filtering hides rows that do not match your criteria; it does not delete them, so you can change or remove the filter to see the full dataset again.

What a filter does in Google Sheets

A filter temporarily narrows a table to rows that meet criteria you set for one or more columns. For example, a sales sheet might show only orders marked Open, orders from a particular region, or amounts above a threshold. The matching rows retain their original values and remain in the sheet; rows outside the results are hidden from view.

Filtering is useful when you want to inspect a subset without making a separate copy of the data. It can also make a large table easier to review, but it does not change the underlying records or create a permanent report. If you need a separate, automatically updating set of results elsewhere, a formula such as FILTER may be a better fit.

A filter works on a selected data range, commonly a rectangular table with one header row. It is important to include the complete set of columns belonging to each record. If you filter only one column of a wider table, the relationship between values in different columns may be disrupted. For a typical dataset, click a cell inside the table before creating the filter so Sheets can identify the connected range.

Create a filter for a table

In Google Sheets in a web browser, use these steps:

Arrange the data in columns and give each column a clear, unique heading in the top row.
Click a cell inside the data range. If the table is surrounded by unrelated content, select the exact range you want to filter instead.
Choose Data > Create a filter. Filter icons appear in the header row of the selected range.
Click the filter icon in the column you want to use.
Choose values to include, or use the available filter options to set a condition, then click OK or Apply if shown.
Use another column’s filter icon to add another criterion. The visible rows must satisfy the active filters together.

For example, in a table with Status, Region, and Amount columns, select Open under Status and West under Region. The result shows records that are both open and in the West region. To undo the view without removing the filter controls, clear the criteria in the relevant column menu. To remove the filter itself, choose Data > Remove filter.

Choose values or set a condition

The filter menu gives you two common ways to narrow a column. Filtering by values is convenient when a column contains a manageable set of labels, such as department names or order statuses. The menu lists values found in that column; select the ones you want to keep visible and clear the rest. Search in the value list when there are many distinct entries.

Conditions are better when the rule matters more than the exact list of values. Depending on the data type, filter conditions can include options such as text contains, text starts with, date is before, or number is greater than. You can also choose a custom formula condition for cases that need a rule not covered by the preset choices. The available choices can vary with the type and contents of the column.

For a practical example, suppose an Amount column contains numbers and you only want to review orders over 500. Open that column’s filter menu, choose Filter by condition, select the greater-than condition, and enter 500. If the entries are stored as text rather than numbers, a numeric condition may not behave as expected. Check the cell format and values before assuming the filter is at fault.

When combining criteria across columns, remember that filters generally narrow the results cumulatively: a row must pass each active column filter to remain visible. If the result is unexpectedly empty, loosen one condition at a time and check for spelling differences, extra spaces, inconsistent date formats, or values stored with different data types.

Sort rows while filtering

Filtering and sorting are related, but they do different jobs. A filter hides rows that do not meet a rule; sorting changes the order of the visible records. In the column filter menu, sorting options let you order values, for example from A to Z or from smallest to largest. Sorting the filtered data can make the relevant records easier to scan.

Because a table’s columns describe the same records, sort the whole table range rather than sorting a single column by itself. Sorting only one column can put names beside the wrong dates or amounts. A well-formed range with a header row helps Sheets treat the data as a table and keep each row’s values together. If you are unsure what range is active, inspect the boundary of the filter controls before sorting.

Use filter views for independent views

A standard filter changes the view of the sheet itself, which can affect what collaborators see while they are working in the same file. If several people need different filtered views of the same data, use a filter view instead. In the browser, choose Data > Filter views > Create new filter view. Set criteria using the filter icons, and give the view a useful name in the filter view bar.

Filter views allow people to examine different subsets without continually changing the ordinary filter for everyone. They are especially helpful for shared trackers: one person can view a particular region while another reviews overdue items. A filter view is still a view of the same underlying cells, not a duplicate table. Changes made to the data itself remain changes to the shared spreadsheet.

To return to the normal sheet view, close the filter view using its close control. To reopen a saved view, use Data > Filter views and select it from the list. If the menu option is unavailable, check whether you have permission to edit the sheet and whether the file is open in Google Sheets rather than a read-only preview.

Keep the data range and headers reliable

Filters are easier to use when each column represents one kind of information and each row represents one record. Put a descriptive heading at the top of every column, avoid merged cells inside the table, and keep notes or totals outside the data range. Blank rows or columns can make it less clear where a table begins and ends, especially when selecting a range manually.

New rows added immediately below a filtered table may or may not be included in the range depending on how the range was selected and how the sheet is arranged. If a newly added record does not respond to the filter, check whether it lies inside the filtered range. You can remove the filter and recreate it with the larger range, or select the intended full range before choosing Data > Create a filter.

Be cautious with totals placed within the records. A total row can be hidden or treated like ordinary data, which may make a subtotal appear to describe only the visible rows when it does not. Keeping summary calculations above or below the filtered table, or on a separate summary sheet, makes their meaning clearer.

Common filtering problems

If a value you expect is missing from the filter’s value list, first check the data range and then inspect the cell itself. Similar-looking entries may differ because of trailing spaces, punctuation, capitalization, or a different underlying type. Dates imported as text, for instance, may not sort or filter like actual date values. Standardizing the column can make both filtering and later analysis more dependable.

If the filter icons do not appear, make sure you selected a cell in the data or a range that includes the header row, and confirm you chose Data > Create a filter. A protected range or limited editing permission may restrict what you can change. If collaborators report that rows have disappeared, explain that a filter hides records rather than deleting them; clear the criteria or remove the filter to restore the full view.

Filters also do not automatically resolve ambiguous data. A condition such as text contains may match more entries than you intended, while selecting a value may exclude a spelling variant. Review the visible results and the source values before using them for decisions or sharing a filtered view as a report.

When a formula is a better alternative

Use a regular filter when you want to explore or temporarily narrow the existing table. Use a filter view when collaborators need separate saved views. If you want matching records to appear as a separate, formula-driven result range, Google Sheets has the FILTER function. For example, with complete records in A2:D and a Status column in C, the formula =FILTER(A2:D, C2:C="Open") returns rows whose status is Open.

The formula result updates as source data changes, subject to the criteria and range in the formula. It needs room to expand, so avoid placing unrelated content in the output area. Unlike applying a filter to the original table, this creates a displayed result elsewhere and does not hide the nonmatching source rows. For a one-time extraction, copying and pasting selected data may be simpler; for ongoing reporting, a formula can avoid repeatedly changing the source view.

Excel also has filtering tools, but its interface and some details differ from Google Sheets. The steps here use Google Sheets menus in a web browser; do not assume an Excel ribbon path is identical. If you open the same file in Excel, use Excel’s own filter controls and check compatibility for any formulas or features you rely on.

Frequently Asked Questions

How do I filter multiple columns in Google Sheets?
Choose Data > Create a filter, then set criteria from each relevant column’s filter icon. The results show rows that meet all the active column filters.

Does filtering delete rows in Google Sheets?
No. A filter hides rows that do not match the criteria. Clear the criteria or remove the filter to see those rows again; the underlying cell contents remain in the sheet.

Can I filter rows without affecting other people?
Use a filter view: choose Data > Filter views > Create new filter view. This lets you set a separate view rather than changing the standard filter shared on the sheet.

How do I remove a filter in Google Sheets?
Choose Data > Remove filter to remove the active standard filter. If you only want to show all rows temporarily, clear the selections or conditions in the filter menus instead.

Can Google Sheets filter by color?
Yes. When the selected range contains formatting, the column filter menu can offer Filter by color for fill or text color. The option is useful for visually marked rows, but consistent values in a dedicated column are usually easier to maintain and filter reliably.

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.