Google Sheets Filters: How to Add and Use Them

To add a filter in Google Sheets in a web browser, select your data range, including its header row, then choose Data > Create a filter. Filter icons appear in the header cells; click one to choose which rows to show. A filter hides rows that do not match your choices but does not delete their contents.

What a Google Sheets filter does

A filter lets you temporarily narrow a table to records that meet selected criteria. For example, a project list could show only tasks assigned to Maya, or a sales sheet could show orders above a chosen amount. The rows that do not match are hidden from view, while their data remains in the sheet and can be shown again by changing or clearing the filter.

Filters can also sort the displayed data. Sorting changes the order of rows within the filtered range; it does not remove records. This makes a filter useful for finding a subset of a larger list without making a separate copy or permanently deleting information.

Google Sheets provides a standard filter and filter views. A standard filter is a shared setting on the sheet: collaborators with access may see and change the same filtered range. A filter view lets someone apply a saved or temporary view without changing the standard filter other people are using. Choosing between them matters when several people work in the same file.

Prepare the data before adding a filter

Filters work best when the data is arranged as a simple table. Put one field in each column and one record in each row, with a single, clearly labeled header row. For example, a reading log might have columns for Title, Author, Genre, and Date finished. Avoid placing explanatory notes, subtotals, or a second header row inside the records you want to filter.

Check that each column has a header, and that headers are distinct enough to identify.
Keep related records together in a continuous block. Blank rows or columns can make it less clear which cells belong to the table.
Use consistent values where possible. For example, entering a category as both In progress and In Progress can make the value list harder to scan.
Make sure dates and numbers are stored as dates and numbers, rather than text that only looks similar.

You do not have to select every cell on the sheet. Select the table range you want the filter to cover, including its headers. If the data is one uninterrupted block, clicking a cell inside it may be enough for Sheets to detect the range; selecting it explicitly is safer when the sheet has nearby notes or other tables.

How to create a filter in Google Sheets

Open the spreadsheet in Google Sheets in your browser and locate the table.
Select the cells to include, making sure the selection contains the header row and all the records.
Choose Data > Create a filter. You can also use the filter button on the toolbar when it is available.
Look for a filter icon in each header cell. Click the icon for the column you want to narrow.
Choose values to include, or select a condition such as text containing or greater than. Apply the choice to update the displayed rows.

For instance, suppose a table has columns named Item, Department, and Status. To see only unfinished work, click the filter icon in Status and select the relevant status value, such as In progress. The rows for other statuses are hidden, and the remaining rows keep their other cell values together.

Ways to filter rows

The filter menu offers more than a checklist of values. The options shown depend on the type of data in the column. Filtering by values is convenient when the column contains a manageable set of categories. You can select or clear individual values, and the sheet will show rows whose entries match the selected values.

Filter by condition is more useful when a column has many possible entries or when you want a rule rather than a hand-picked list. Depending on the data type, conditions can include text rules, numeric comparisons, dates, or whether a cell is empty. For example, a numeric column can be limited to values greater than a threshold, while a text column can be limited to entries that contain a word.

Google Sheets also supports filtering by cell color, including fill color or text color, when colors are used in the range. This can help when colors are meaningful labels, but color should not be the only way important information is recorded: a written status is easier to search, understand, and maintain.

Filters can be combined across columns. If you choose Department = Support and Status = In progress, Sheets displays rows meeting both selections. This is useful for a question such as, “Which Support tasks are still underway?” If the result looks unexpectedly small, check each active column filter; one condition may be narrowing the rows further than intended.

Change or remove a filter

To adjust a filter, click the filter icon in the relevant header again and change the selected values or condition. You can filter a second column without removing the first filter. The visible rows then reflect the combined criteria. To show all values for one column, reopen its menu and select all values or clear that column’s filter criteria.

To turn off the standard filter altogether, choose Data > Remove filter. This restores the ordinary sheet view and removes the filter icons. It does not delete rows or erase the criteria’s underlying data. If you have sorted the data, however, removing a filter does not necessarily return rows to their original order; use an existing sequence or ID column to sort them back if needed.

It is worth distinguishing clearing a column’s criteria from removing the filter. Clearing criteria makes more rows visible while leaving the filter controls in place. Removing the filter turns off those controls for the filtered range.

Use filter views when people share a sheet

A standard filter changes the shared view of a sheet. If a collaborator is looking at the same sheet, your filter or sort may affect what they see, which can be disruptive when several people need different subsets of the same data. Filter views are designed for that situation: each person can work with a particular view without replacing the sheet’s standard filter for everyone.

In the browser, open Data > Filter views and choose Create new filter view. A filter-view toolbar appears, and you can set criteria using the column filter icons. You can give the view a useful name, such as Open tasks or West region, so it is easier to recognize later. Close the view when finished; return through Data > Filter views to open a saved view or create another one.

Filter views are especially helpful for shared trackers, class lists, inventory, or reports where different people need different slices of the same records. They do not create another copy of the data. They change how the rows are displayed in that view. People still need appropriate access to the spreadsheet, and edits to cell contents remain edits to the shared data itself.

Filters compared with sorting and the FILTER function

Filtering, sorting, and the Google Sheets FILTER function solve related but different problems. A filter hides rows that do not meet criteria, while sorting rearranges rows according to a column. You can use both together: filter a task list to show one team, then sort the remaining tasks by due date.

The FILTER function is a formula that returns matching data into another area of the spreadsheet. It can be useful when you want a separate, automatically updating results table rather than hiding rows in the source table. The menu-based filter is usually simpler for interactive browsing; a formula-based output can be more suitable for a dashboard or report. Remember that formula results and the source data are separate in presentation, but the formula does not replace good access controls or protect confidential source information.

Excel also has table and range filtering, but its interface and menu locations differ from Google Sheets. The steps here are for Sheets in a browser; do not assume that an Excel ribbon instruction applies to the Sheets menus.

Common filter problems and fixes

No filter icons appear: Check that you selected the range and chose Data > Create a filter. If you are in a filter view, look for its view controls rather than expecting the standard filter to behave the same way.
Some records are missing: Reopen each column’s filter menu and review its selected values and conditions. Multiple filters work together, so a criterion in another column may be excluding the records.
A new row is not included: Confirm that the row is inside the filtered range. If it falls outside the range, adjust the range or recreate the filter with the full table selected.
A date or number condition behaves oddly: Check the cell format and the underlying values. Text that resembles a date or number may not behave like a genuine date or numeric value.
Sorting appears to move the wrong information: Make sure the complete table is covered by the filter range. Sorting only one column separately can detach values from the records they belong to.

When a result seems wrong, first inspect the active filter icons and confirm the selected range. Then check for inconsistent spelling, extra spaces, blank cells, or values stored in a different format. These are common reasons a filter menu may show unexpected categories or a condition may not match a cell that looks as though it should qualify.

Frequently Asked Questions

Does adding a filter delete rows in Google Sheets?
No. A filter hides rows that do not match the criteria; it does not delete their contents. Change or clear the criteria to show those rows again.

Can I filter more than one column at a time?
Yes. Set criteria in multiple column menus. Sheets displays rows that satisfy the active criteria together, so each additional condition can narrow the result.

How do I filter by a specific word?
Click the filter icon in the text column, choose a condition-based option, and set the text rule to match the word or phrase you need. For a short list of repeated labels, selecting the value directly from the menu may be faster.

Will a filter affect other people viewing the spreadsheet?
A standard filter is a shared sheet setting and can affect collaborators’ view. Use a filter view when different people need to explore different subsets without changing the standard filter for everyone.

Can I filter on the Google Sheets mobile app?
The app’s controls differ from the browser interface and can vary by device. These menu steps describe Google Sheets in a web browser. If you need to create or manage a detailed filter view, use the browser interface and check the app’s current menus for the available filter controls.

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.