Google Sheets Filter Not Filtering? Fix the Common Causes

If a Google Sheets filter is not filtering, check that the filter covers the full data range, that you selected the right values or condition, and that the rows you expect to see are not outside the filtered range. In a browser, select the data including its header row and choose Data > Create a filter; then open a column’s filter icon and review its criteria.

How Google Sheets filters work

A filter temporarily hides rows that do not match the criteria you set. It does not delete those rows, change their cell values, or move them to another sheet. When you clear the criteria or remove the filter, the hidden-by-filter rows can appear again. This is useful for inspecting one part of a list without changing the underlying data.

A standard filter is attached to a selected range of cells. Each column in that range can have its own criteria. If you set criteria on more than one column, a row generally needs to meet the criteria in each filtered column to remain visible. For example, filtering a Status column to show Open and a Region column to show West displays records that match both selections.

After creating a filter, small filter icons appear in the header row. Open the icon for the column you want to narrow, then choose values to show or use a condition such as text contains. The exact options depend on the type of data in the column. A filter icon by itself does not mean a filter is actively excluding rows; the selected values or condition determine what remains visible.

Check the range and header row first

A frequent cause is that the filter was created for only part of the table. Suppose a list has headings in row 1 and records in rows 2 through 500, but the filter covers only A1:D100. Records in rows 101 through 500 will not be controlled by that filter. Check the edge of the selected range and confirm it includes every relevant column and record.

The header row should be included in the range and should contain meaningful column names. If the selection began on the first record instead, Sheets may treat that record as the header, making the filter menus confusing. A blank row or an unrelated note between the headings and records can also make it easier to select an incomplete range by mistake.

To correct the range, remove the existing filter, select the complete rectangular dataset including its headings, and choose Data > Create a filter again. Before doing so, check whether the range includes totals or notes that you do not want treated as ordinary records. If new rows are added beyond the existing range, verify that they are covered rather than assuming the filter includes every future row.

Review the selected values and conditions

Open the filter icon for the column that appears wrong and inspect the active settings. Under Filter by values, the checked entries are the ones allowed to remain visible. If only one value is checked, the sheet is correctly hiding rows with other values even if that was not your intention. Use the select-all option, then deselect only the values you want excluded, or choose the intended values individually.

Under Filter by condition, check both the condition and its input. Text contains, text is exactly, is empty, and is not empty do different jobs. For instance, a condition that says text is exactly North will not match North Region. A condition that says text contains North can match both North and North Region. If the field contains numbers or dates, use a suitable numeric or date condition rather than assuming the values are text.

Also check for criteria in other columns. A City filter might show Boston, while a second Status filter shows Closed; together, those settings may leave only a few rows or none at all. Clear criteria in other columns temporarily to see whether they are responsible. Clearing a filter criterion is different from removing the filter itself: the filter controls can remain available while all values are shown.

Look for inconsistent or unexpected cell contents

Values that look identical on screen may not be identical to Sheets. A cell could contain a leading or trailing space, a different punctuation mark, or an invisible line break. For example, a value with a trailing space after West may appear to read West but behave as a separate entry in Filter by values. Check the cell in the formula bar, widen the column, and compare a suspect cell with a known-good one.

Mixed data types can create similar confusion. A column that looks numeric may contain numbers stored as text, or dates entered in inconsistent formats. Sorting or filtering can then produce groups that seem out of order or unexpected. Check a few source cells and their formats rather than relying only on how the displayed values look. If the data comes from an import or copy-and-paste operation, inspect the original source and look for inconsistent formatting or extra characters.

Blank-looking cells deserve attention too. Some may truly be empty, while others contain a formula that returns an empty string or contain spaces. These can be treated differently by conditions such as is empty, so test the filter with a small known sample. If the list contains formulas, wait for calculation to finish and confirm that the formula results are current before diagnosing the filter as broken.

Distinguish a filter from a filter view

Google Sheets offers standard filters and filter views. A standard filter is useful when you want to filter the shared sheet directly. Its settings can affect what collaborators see in that sheet. A filter view lets someone work with a separate saved filtering arrangement, which is helpful when several people need different ways to examine the same records.

To create one in a browser, use Data > Filter views > Create new filter view. Check that you are editing the intended view and not the ordinary sheet filter. A filter view may have a name or a dark border around its range, making it visually distinct. If a filter seems to have no effect, confirm which mode is open and which view is active; criteria set in one arrangement may not be the criteria used in another.

Filter views are not a way to repair an incomplete data range or incorrect cell values. They still depend on an appropriate range and meaningful criteria. If you share a sheet with collaborators, a filter view can be a considerate way to investigate records without changing the standard filter settings everyone else may be using.

Check hidden rows, sorting, and the visible area

Rows may be hidden manually or grouped, independently of a filter. If clearing the filter does not make an expected row visible, look for gaps in the row numbers, collapsed row groups, or a hidden-row indicator. Use the row controls or the View menu’s group options as appropriate to reveal manually hidden or grouped rows. A filter only manages which rows meet its criteria; it does not necessarily undo other ways rows have been concealed.

Sorting is another separate operation. A sort rearranges the order of records; a filter decides which records are shown. If the right records are visible but appear in an unexpected order, review the sort rather than changing the filter. Likewise, frozen rows or columns affect what stays on screen while scrolling, not which records meet a filter condition.

Finally, check whether you are looking at the correct sheet tab and whether the relevant rows are simply farther down the page. A filter can reduce the displayed records without moving the active cell to the first result. Scroll through the remaining visible rows before concluding that some matching records are missing.

A practical troubleshooting sequence

Use this sequence to isolate the cause without changing the source data unnecessarily:

Confirm the correct spreadsheet and sheet tab are open, and check that you are not viewing an unexpected filter view.
Open the filter icon on the relevant column. Review the selected values and condition, then clear other column criteria temporarily.
Check the filter range and make sure it includes the header row, all relevant columns, and every record you expect to control.
Inspect a record that should match. Compare its exact contents with the criteria, including spaces, spelling, data type, and formula result.
Clear the criteria to see whether the missing records return. If they do not, check for manually hidden or grouped rows and confirm the records are on the current sheet.
If the range is wrong, remove the filter and create it again over the intended dataset. Then reapply one criterion at a time to identify any conflicting setting.

This step-by-step approach helps distinguish a range problem from a criteria problem. It also avoids deleting records or editing source values before you know why the rows disappeared.

How Google Sheets compares with Excel

The basic idea is similar in Google Sheets and Microsoft Excel: select a data range, enable filtering, and use the column controls to show matching records. The menus are different. In Sheets, use Data > Create a filter. In Excel for Microsoft 365 on Windows, filtering is available on the Data tab through Filter, and Excel tables can also provide filter arrows in their header row.

Do not assume that a fix in one program applies exactly to the other. Google Sheets uses filter views as a built-in way to save separate filtering arrangements. Excel has its own workbook and table behaviors, and its menus and collaboration features differ. If following instructions written for Excel, translate the steps to Sheets rather than searching for an identical ribbon command.

Frequently Asked Questions

Why is my Google Sheets filter not showing all matching rows?
First check that the filter range includes those rows. Then inspect criteria in every filtered column and compare a missing row’s exact contents with the selected values or condition. Also check whether the row is manually hidden or grouped.

Why does the filter show values that look the same as another value?
The cells may contain extra spaces, different characters, or different data types even though their displayed text looks alike. Inspect the cell contents and compare the values directly. Imported data and copy-and-paste operations are common sources of inconsistencies.

Does filtering delete rows in Google Sheets?
No. A filter hides rows that do not meet its criteria; it does not delete their contents. Clear the criteria or remove the filter to show the rows again. Be careful not to use a delete-row command when you only mean to change what is visible.

Why can my collaborator see a different filter result?
You may be using a filter view, which allows a separate filtering arrangement, or one of you may have changed the standard filter settings. Confirm whether a filter view is active and compare the criteria. Standard filter changes can affect the shared sheet view.

How do I reset a Google Sheets filter?
Open the filter icon for each affected column and clear its criteria or select all values. To remove the filter controls, choose Data > Remove filter. If the range itself is incorrect, remove the filter and create it again after selecting the complete data range and header row.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.