Google Sheets Filter Command: How to Filter Your Data

In Google Sheets, select your data and choose Data > Create a filter to add filter controls to the column headers. Use a header’s filter icon to show only rows that match selected values or conditions; filtering hides nonmatching rows without deleting them.

What the filter command does

The filter command adds controls to a data range so you can temporarily narrow the rows on screen. For example, a project tracker might contain projects, owners, due dates, and statuses. Filtering the Status column to show “Open” makes closed projects disappear from view while leaving the underlying data unchanged. Clear the filter and the hidden rows return.

This is different from deleting rows, sorting the data, or using a formula. A filter changes which rows are displayed; sorting changes their order; a formula can produce a separate result range. The distinction matters when others use the sheet or when you want to preserve a complete source list.

How to create and use a filter

Make sure the data is arranged in a continuous range, with one column heading per field and no blank header cells.
Select a cell in the data, or select the full range you want to filter. Including the header row helps Sheets identify the column labels.
Choose Data > Create a filter. Filter icons appear in the header row.
Click the filter icon for the column you want to narrow.
Choose specific values to include, or select a condition and enter the criterion. Click OK or apply the selection to update the displayed rows.

You can filter more than one column at a time. For instance, choose “Open” in Status and “North” in Region to see only records that meet both selections. The filter controls remain available so you can change or clear criteria without recreating the filter.

Filter by values, conditions, or color

Sheets offers several ways to describe which rows should remain visible. The best choice depends on whether you are matching known entries or applying a rule.

Filter by values: Select or clear entries in the list, such as individual names, departments, or statuses. The search box in the list is useful when a column contains many distinct values.
Filter by condition: Choose a rule such as text contains, is equal to, is blank, or a date or number comparison. The available choices depend on the kind of data in the column.
Filter by color: Show rows based on a cell’s fill color or text color when colors are being used to mark records. Color filtering is a visual aid, not a substitute for storing an explicit status in the data.

For example, to find invoices above a chosen amount, open the amount column’s filter menu, choose a number condition such as “Greater than,” and enter the threshold. To find names containing a particular word, use a text condition instead of scrolling through every distinct value.

Prepare the range to avoid misleading results

Filters work most predictably when each row is one record and each column contains one type of field. Put labels in the first row, avoid merged cells inside the dataset, and do not insert blank rows that split the range. If a total or note sits immediately below the records, check that it has not been included accidentally.

Before filtering, consider whether the selected range includes all the columns that belong to each record. If you filter only one part of a wider table, rows in the unselected columns may not move or hide with the matching records, which can make the information appear misaligned. Select the full table when its columns must stay together.

Also check for inconsistent entries. “Open,” “open,” and “Open ” with a trailing space may be treated as distinct values in a value list. Dates stored as plain text may not behave like actual dates in date conditions. Consistent labels and genuine date or number values make criteria easier to apply and interpret.

Filter views for personal or reusable views

A regular filter changes the displayed view of the sheet itself, so it can affect what other collaborators see while they are working in that sheet. If people need different filters at the same time, use a filter view instead: choose Data > Create a filter view. Sheets opens a separate view with its own filter controls, which you can name and reuse.

Filter views are useful for recurring tasks such as showing one team’s assignments or reviewing overdue work without repeatedly changing the main view. They can also help prevent a collaborator’s ordinary filter changes from disrupting someone else’s view. To return to the regular sheet, close the filter view using its controls. If you are unsure which mode is active, look for the filter-view bar at the top of the grid.

Choose a regular filter when one shared display is suitable for the people using the sheet. Choose a filter view when different people need independent ways to inspect the same records. Neither option creates a separate copy of the data.

Filter command versus the FILTER formula

The menu command and the FILTER function sound alike, but they solve different problems. The command hides nonmatching rows in the existing range. The function returns matching data in a separate area, which can feed a report or keep a summary visible alongside the source records.

With project names in A2:A5, owners in B2:B5, and statuses in C2:C5, where the four statuses are Open, Closed, Open, and Open, enter this formula in an empty cell such as E2:

=FILTER(A2:C5,C2:C5="Open")

The result is three rows: the first, third, and fourth project records, because those rows have an Open status. The source range remains visible and unchanged. In Google Sheets, FILTER returns an error if no rows meet the condition; in Excel, the corresponding no-match result differs. Leave enough empty space below and to the right of the formula cell for its results to expand.

Use the menu filter for interactive exploration of the original table. Use the formula when you need a live, separately displayed subset. A formula result is not a replacement for a filter view when the goal is simply to let people inspect the same source data in different ways.

Common problems and ways to fix them

Filter icons do not appear: Confirm that you chose Data > Create a filter and that the intended range is selected. Check whether a filter view is already open or whether the range has an unexpected blank row or header.
Some records seem missing: Open the relevant column menu and check both its selected values and any active condition. Clear criteria in other columns too; multiple column filters combine to narrow the results.
A new row is not included: Check whether the filter range covers the added row. If it does not, remove the filter and create it again with the complete range, or adjust the range as needed.
Rows appear to be out of order: Filtering and sorting are separate actions. Use the column menu’s sort options if you also need to arrange the visible records.
Numbers or dates do not match expectations: Check whether the cells contain actual numeric or date values rather than text that only looks like a number or date. Also check for extra spaces or inconsistent formatting in text fields.

To remove a regular filter, choose Data > Remove filter. This removes the filter controls; it does not restore deleted data because filtering does not delete records in the first place. In a filter view, close the view rather than removing a regular sheet filter.

How Google Sheets filtering differs from Excel

In Google Sheets in a web browser, the standard menu path is Data > Create a filter, and saved filter views are available through Data > Create a filter view. Microsoft Excel also has built-in table and range filters, but its interface and filter-view features differ. Excel users may recognize a function called FILTER, but function availability and details vary by Excel version; do not assume that every Sheets menu command or collaboration behavior works the same way in Excel.

If you are following instructions written for Excel, look for the equivalent filtering control in Excel rather than expecting Google Sheets’ exact menu labels. Conversely, in Sheets, use the Google Sheets menu paths above instead of Excel ribbon instructions.

Frequently Asked Questions

What is the Google Sheets filter command?
Choose Data > Create a filter. The command adds filter icons to the selected data range’s headers so you can display rows that match selected values or conditions.

Does filtering delete rows in Google Sheets?
No. A filter hides rows that do not meet the criteria. Clear the filter or remove it to show the rows again; deleting a row is a separate action.

How do I filter one column in Google Sheets?
Create a filter for the table, click the filter icon in the column header, and select values or set a condition. Other columns remain available for additional criteria.

How can I filter without changing what other people see?
Use Data > Create a filter view to make a separate view with its own criteria. A regular filter changes the displayed sheet view and may affect collaborators viewing that sheet.

What is the difference between a filter and the FILTER formula?
The menu filter hides nonmatching rows in the original range. The FILTER formula returns matching rows in a separate output range, which is useful for a live subset or report.

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.