Google Sheets Filter Dropdown: How to Use It

In Google Sheets, a filter dropdown is the small control in a column header that lets you sort rows or show only records that meet selected criteria. To add one in a browser, select your data range, including its header row, then choose Data > Create a filter; use the dropdown in a header to filter or sort the table.

What a Google Sheets filter dropdown does

A filter dropdown is part of a sheet filter, not a list of choices that you enter into a cell. It lets you temporarily hide rows that do not match a rule, such as a status, date, name, or number, while leaving the underlying cells in place. For example, in a task table with columns for Owner, Due date, and Status, you can show only rows whose Status is “In progress.”

When a filter is active, filter icons appear in the header cells of the selected range. Opening one gives you options to sort that column, filter by specific values, or set a condition. Filtering one column does not erase or overwrite the other rows; it changes which rows are visible. A filter can be removed later to show the full range again.

Filters are useful when a table has too many rows to scan comfortably, or when you need to focus on a subset without making a separate copy. They work best with a clearly structured dataset: one header row, one record per row, and a consistent type of information in each column.

How to add a filter

Open the spreadsheet in Google Sheets in a web browser.
Identify the table and its header row. Select the full range, including the headers and all records you want covered. For example, if headers are in A1:D1 and data continues through row 200, select A1:D200.
Choose Data > Create a filter. Filter icons should appear in the selected range’s header cells.
Click the filter icon in the column you want to narrow, then choose values or a condition.

If you start with a cell inside a contiguous table and choose Data > Create a filter, Sheets may identify the table around it. Selecting the exact range first is safer when the sheet has nearby notes, blank columns, separate tables, or extra information that should not be included. Include the header row so the filter controls are associated with meaningful column names.

To turn off a standard filter, choose Data > Remove filter. This removes the filter controls and restores the rows hidden by filtering. It does not delete the data. If you only want to change what is shown, adjust the criteria in the relevant header dropdown instead.

Filter by values or by a condition

Opening a column dropdown generally gives you two useful ways to narrow the table. “Filter by values” lets you select which distinct entries to show. A search box can help locate a particular entry in a long list. For instance, in a Region column, select West and East to show only records from those regions. Selecting all available values restores them for that column.

“Filter by condition” is useful when you want a rule rather than a hand-picked list. The available conditions depend on the contents of the column. Text columns can offer rules such as text contains; numeric columns can offer comparisons such as greater than; date columns can offer date-based choices. Conditions can also help find empty or non-empty cells. Choose the condition, enter or select the required value if prompted, and apply it.

For example, a sales table might have a Revenue column. A condition for values greater than 500 shows rows whose revenue exceeds 500, while filtering by values would require selecting the particular revenue entries one by one. If the values are inconsistent—for example, numbers stored as text mixed with real numbers—the available options or results may not behave as expected. Check the cell contents and formatting if a numeric rule misses records.

Combine filters and sort results

You can apply criteria in more than one column at the same time. Suppose an event list has City, Event type, and Date columns. Filter City to show Portland, then filter Event type to show Workshops. The remaining visible records meet both active filters. This is a practical way to answer questions such as “Which workshops are scheduled in Portland?” without changing the source values.

To sort, open a column’s filter dropdown and select an available sort option, such as sorting A to Z or Z to A for text. Numeric and date columns sort according to their values. Sorting is different from filtering: sorting changes the order of rows in the range, while filtering hides rows that do not match. Before sorting, make sure the entire table is included in the filter range; sorting only one column separately can detach values from the records they belong to.

Multiple criteria can make a table appear empty if they are too restrictive or conflict. If that happens, inspect each active column filter and broaden or clear one criterion at a time. Also check for unexpected spaces, inconsistent spelling, or dates stored as text. Two entries that look similar may be distinct values to Sheets—for example, “Complete” and “Complete ” with a trailing space.

Filter dropdowns are not cell dropdown lists

The phrase “Google Sheets dropdown” can refer to two different features. A filter dropdown appears in a column header and controls which rows are visible. A cell dropdown is a data-entry control inside a cell; it helps someone choose an allowed value, such as “Open,” “In progress,” or “Done.” A cell dropdown does not automatically filter the table.

To create a cell dropdown in the current Sheets interface, select the cell or range and use Insert > Dropdown. You can also use Data > Data validation to configure validation rules. This feature is useful for keeping entries consistent, while a filter dropdown is useful for examining existing rows. A team might use both: a Status cell dropdown standardizes task entries, and a filter on the Status header shows only tasks marked “In progress.”

When to use a filter view

A standard filter is attached to the sheet’s selected range and can affect what collaborators see. If several people are working in one spreadsheet and each needs a different view, consider a filter view instead. In the browser, choose Data > Filter views > Create new filter view, then set the conditions and sorting for that view. Give it a descriptive name so it is easy to find later.

Filter views let people save and switch between different ways of looking at the same data—for example, “Open tasks,” “This month’s orders,” or “West region.” They are especially helpful when users should not keep changing one shared filter back and forth. People with access to the spreadsheet can work with filter views, and a view can be shared by its link, subject to the spreadsheet’s access permissions. A filter view changes the displayed view, not the cell values.

Use a standard filter for a quick, shared filtering task on a table. Choose a filter view when you want a saved set of criteria or a separate view for a particular workflow. Filter views are available in Google Sheets in a desktop web browser; the interface and availability may differ in the mobile app. Excel has its own Filter feature and menu layout, so Google Sheets paths such as Data > Create a filter should not be assumed to apply in Excel.

Good practices for reliable filtering

Use one clearly labeled header row, and avoid merged cells in the table’s header or data area.
Keep each column consistent: dates in date columns, numbers in numeric columns, and comparable labels in category columns.
Include all rows and columns that belong together when creating the filter, but exclude separate notes or unrelated tables.
Freeze the header row if it helps you identify columns while scrolling; freezing rows is separate from filtering.
Before sharing a filtered sheet, tell collaborators whether the filter is a shared standard filter or a saved filter view.
Remember that filtering hides rows rather than deleting them. A regular SUM calculation can still include values in filtered-out rows; use an appropriate subtotal calculation if you need a result that responds to filtered visibility.

These habits also make filters easier to maintain as data grows. If new records are added outside the existing filter range, they may not behave like the rows already covered. Check the range when appending data, especially if there is a blank row or column separating the table from new records.

Common filter problems

No filter icons appear: Confirm that you selected the range and used Data > Create a filter. If a filter is already active, the menu may offer the option to remove it rather than create another. Check that the selected range includes the header row.

Some rows seem missing: A filter may still be active in another column. Open each filtered header and review its selected values or condition. Clear the criteria or select all values to restore rows. Rows may also be hidden manually, which is separate from filtering.

The dropdown contains unexpected entries: Look for blank cells, inconsistent spelling, extra spaces, or mixed data types in the column. A value that differs by a space or punctuation can appear as a separate item. Correcting the source data is usually more reliable than trying to work around inconsistent entries in the filter.

The wrong cells are being sorted or filtered: Remove the filter and recreate it on the full table range, including every column that belongs to each record. Avoid sorting a single column independently of the rest of the row, because that can mismatch names, dates, and other fields.

Frequently Asked Questions

How do I add a filter dropdown in Google Sheets?
Select the table range, including its header row, then choose Data > Create a filter. Click a filter icon in the header to select values, set a condition, or sort the range.

How do I remove a filter without deleting data?
Choose Data > Remove filter to remove the filter controls and show the rows again. Filtering itself only hides rows; it does not delete their contents.

Can I filter by more than one column?
Yes. Apply a criterion in one column, then apply another in a different column. The visible rows must meet all active column filters.

Why is my filter dropdown missing some values?
Check whether another filter is active, whether the range includes all relevant records, and whether entries contain extra spaces or inconsistent formats. New rows outside the filter range may also be excluded.

What is the difference between a filter and a filter view?
A standard filter changes the shared sheet’s visible results. A filter view saves a particular set of criteria and sorting so users can switch among different views of the same data.

Is a filter dropdown the same as a dropdown in a cell?
No. The header dropdown filters or sorts rows. A cell dropdown, created through Insert > Dropdown or Data > Data validation, restricts or guides what can be entered in a cell.

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.