Auto Filter in Google Sheets: Setup and Tips

To use an auto filter in Google Sheets, select your table, then choose Data > Create a filter. Filter icons appear in the header row; click one to sort or show only rows that match your criteria. Google Sheets does not use Excel’s exact “AutoFilter” label, but this built-in filter feature serves the same everyday purpose.

What an auto filter does in Google Sheets

A filter temporarily hides rows that do not meet the conditions you choose. It does not delete data, move matching rows to a new sheet, or change the values in the cells. For example, a small order table might have columns for Order ID, Date, Region, and Status. Filtering Status to show “Open” leaves open orders visible and hides the other records until you change or clear the filter.

Filtering is useful when a table has more rows than are practical to scan manually. You can narrow a list by a particular value, a date range, text that contains a word, or a numeric condition. You can also sort the visible records. The original data remains in its cells, although the display order may change if you sort the sheet.

Google Sheets filters work on a selected data range. The first row of that range is treated as the header row, so include the column names when selecting the table. If the range starts one row too low, the first record may be mistaken for a header, and the filter controls will not line up with your labels.

How to create and remove a filter

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

Arrange the data as a table with one clear header row and one record per row. Avoid blank rows or merged cells inside the table.
Select the full range, including the headers. For example, select A1:D200 if the table uses columns A through D and has 199 records beneath its header.
Choose Data > Create a filter. A filter icon appears in each header cell.
Click a header’s filter icon and choose values, a condition, a sort order, or another available option.

When you select the data first, the filter’s scope is easier to verify. If you start with a cell inside a continuous block of data, Sheets may identify the surrounding range, but checking the header and final row helps prevent leaving out a column or records at the bottom.

To remove the filter, choose Data > Remove filter. This turns off the filter controls and shows the rows again; it does not erase the table. If rows remain hidden, check whether someone hid them manually or whether a filter view is still active.

Filter by values, conditions, and color

Click a column’s filter icon to see the available options. Filter by values lets you select or clear individual entries. This is handy for a short list of categories, such as choosing only “North” and “West” in a Region column. The search box in the value list can help locate an entry in a long set of distinct values.

Filter by condition is better when the values are numerous or follow a rule. Depending on the column’s contents, conditions can include choices such as text contains, date is before, or number is greater than. For instance, to find orders above a chosen sales threshold, open the Sales column’s filter menu, select a numeric condition, and enter the threshold. The exact condition choices depend on the type of data in the column.

You can also filter by cell color or text color when the sheet uses colors to mark information. That can be useful for a manually highlighted review status, but color is a fragile substitute for a real data field: colors may be applied inconsistently, and they do not explain why a record was marked. For a process that needs to be sorted or reported reliably, use a Status or Priority column instead.

To return to the full list without removing the filter controls, reopen the relevant menu and choose the option to clear that column’s filter, or select all values again. This is different from removing the filter from the entire range.

Combining filters across columns and sorting

You can apply a filter to more than one column at the same time. Conditions on separate columns work together: Sheets displays rows that satisfy the active filters. For example, filtering Region to “West” and Status to “Open” shows open orders in the West, not every open order and every West order as separate groups.

Within one column, selecting several values generally means any selected value can match. If you select “North” and “West” in Region, rows from either region remain visible. You can combine that selection with a different column’s condition, such as Status equals “Open,” to narrow the result further.

Sorting is available from a header’s filter menu. A-to-Z or smallest-to-largest sorting changes the order of rows in the range; it is not just a temporary rearrangement of the visible screen. If row order carries meaning, such as the order in which records were entered, add an ID or timestamp column before sorting so the original sequence can be restored.

When a sort or filter seems to affect unrelated cells, check whether the whole table was included. A range that omits a column can separate that column’s values from their corresponding records when rows are sorted. Keep each record in a single complete row, and include all related columns in the filter range.

Filters versus filter views

A standard filter changes what is displayed for the filtered range in the shared sheet. If several collaborators are looking at that sheet, one person’s filter choices can affect what the others see. That can be disruptive when different people need different subsets of the same data.

A filter view is a separate saved view of a range. It lets someone sort or filter without replacing the standard filter settings other collaborators may be using. In a browser, create one from Data > Filter views > Create new filter view, then adjust the filter controls and give the view a useful name. Filter views are particularly useful for shared trackers, such as a team assigning each person a view of their own region or work status.

Use a standard filter when the group needs one shared view, or when you are working alone and want a simple temporary filter. Use a filter view when collaborators need independent views. A filter view is still a view of the same underlying data: it does not make a private copy, restrict access to rows, or protect sensitive information. Anyone with sufficient access to the sheet may still be able to see the source records.

What happens when the data changes

Filters change the displayed rows in the range; they are not a separate report that must be refreshed after every edit. If a value is edited so that its row no longer matches the active condition, the row may disappear from the filtered display. If it becomes a match, it can appear. This behavior makes filters useful for reviewing a changing list.

The important limit is the range. If new records are added outside the filtered range, they may not receive the filter controls or respond to its criteria. When adding records, place them within the range or update the filter range to include them. For a list that grows frequently, make a habit of checking the range after adding data rather than assuming every new row is covered.

Filtered-out rows are hidden from view, not removed from the spreadsheet. Do not assume that a visible-row selection or a copied subset represents the entire source table without checking the operation. Likewise, a filter is not a security feature: hiding a row does not prevent another person with access from viewing it by clearing the filter.

Common problems and practical fixes

No filter icons appear: Confirm that you chose Data > Create a filter and selected a valid range. Check for merged cells or a selection that contains only a header or a blank area.
A header is treated as a record: Make sure the selected range begins with the actual header row, not the first data row. Remove and recreate the filter with the correct range if necessary.
Some records are missing: Inspect the filter menus in every column, since more than one condition may be active. Also check whether the range ends before the missing records.
A value does not match a condition: Check for extra spaces, inconsistent spelling, or mixed data types. A date stored as text, for example, may not behave like a real date in date-based conditions.
Sorting breaks the table: Recreate the filter over the complete table, including all columns that belong to each record. Do not sort one column by itself when its values must stay paired with other columns.
Other collaborators see a different display: If you used a standard filter, it may be shared. Switch to a filter view when people need independent ways to inspect the same data.

When diagnosing a problem, clear one condition at a time rather than removing data or changing several settings at once. That makes it easier to identify which column or range is responsible.

When a formula or another tool is a better fit

Use a regular filter for interactive inspection of the source table. If you want a separate output area that updates to show matching rows, Google Sheets’ FILTER function may be a better fit. With headers in A1:D1, records in A2:D100, and order status in C2:C100, enter =FILTER(A2:D100,C2:C100="Open") in an empty area. If there are matching records, the formula returns the rows whose status is Open; the source rows remain where they are.

That example assumes the data occupies columns A through D and that status is in column C. Keep the criteria range the same height as the data range. A formula output is not the same as an interactive filter: you do not use its header icons to hide and reveal source rows, and the output area needs room for the results to expand.

For a quick summary rather than a row-by-row view, a pivot table may be more suitable. For a shared sheet where different people need different subsets, filter views are usually simpler. Choose based on the task: inspect the source with a filter, create a live matching list with FILTER, or summarize categories with a pivot table.

Frequently Asked Questions

Does Google Sheets have an AutoFilter feature?
Google Sheets calls the standard feature a filter rather than AutoFilter. Choose Data > Create a filter to add filter controls to a selected range. Its purpose is similar to Excel’s AutoFilter, though the menus and terminology differ.

How do I filter multiple columns in Google Sheets?
Create a filter for the full table, then set a condition in each relevant column’s filter menu. The resulting rows must meet the active conditions across those columns. For example, choose a region and an order status to see only records meeting both selections.

Can other people see my Google Sheets filter?
A standard filter affects the shared sheet’s displayed view and can change what collaborators see. Use a filter view when each person needs to sort or filter independently. Neither type of filter hides data from people who have access to the underlying sheet.

Will a Google Sheets filter include new rows automatically?
It applies to its range, so a new row outside that range may not be covered. Add records within the filtered range or adjust the range to include them, then check that the filter controls cover the new data.

How do I show all rows again?
Clear the active column conditions or select all values in the filter menu to show the records while keeping the filter controls. To remove the controls entirely, choose Data > Remove filter.

Is filtering the same as deleting rows?
No. Filtering hides nonmatching rows from the current view but leaves their contents in the sheet. Removing the filter or clearing its conditions makes those rows visible again.

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.