Google Sheets Filter Not Blank? Steps and Formulas

To show only rows with a nonblank cell in Google Sheets, select your table and choose Data > Create a filter. Open the filter menu on the relevant column, choose Filter by condition, then select Is not empty. For a live formula-based result instead, use FILTER with a condition such as =FILTER(A2:C, B2:B<>"") when column B is the column that must contain a value.

What a not-blank filter does

A not-blank filter displays rows where the chosen column has a value and hides rows where that cell is empty. It does not delete data, move it, or change the underlying cell contents. Clearing the filter restores the hidden rows. This makes it useful for reviewing partially completed forms, finding records with contact details, or temporarily focusing on entries that have been assigned a status.

The key decision is which column determines whether a row counts as complete. If a project table has a task name, owner, and due date, filtering the due-date column for nonblank cells shows tasks that have dates; it does not necessarily show every task with any information. A row with a task name but no date will be hidden by that filter. Pick the column that represents the information you actually need.

Apply the filter from the Sheets menu

Make sure the data has a header row, with one heading for each column. Remove merged cells from the data area if they interfere with selecting or filtering the table.
Select a cell in the table. If the data is next to unrelated content, select just the table range, including its headings.
Choose Data > Create a filter. Filter icons appear in the header cells.
Click the filter icon in the column you want to check.
Choose Filter by condition, then Is not empty. The sheet hides rows that do not meet that condition.

For example, suppose A1:C5 contains headings Name, Email, and City, and only rows with an email address should remain visible. Open the filter on the Email heading in column B and choose Is not empty. Rows with an empty B cell disappear from view, while rows with an email remain. The other columns in each matching row stay together; a filter hides whole rows rather than independently rearranging cells in one column.

To remove the condition, open the same column menu and clear or remove the filter condition. To turn off the sheet’s filter controls, choose Data > Remove filter. The wording of a menu can change over time, but Create a filter and the per-column filter menu are the standard route in Google Sheets in a browser.

Use FILTER to create a separate results table

A menu filter changes which source rows are visible. The FILTER function, by contrast, returns matching rows as a separate result, leaving the source table visible and unchanged. It is useful for a dashboard, a report tab, or a view that should update as people add data.

With names in A2:A, email addresses in B2:B, and cities in C2:C, and with the output formula entered in E2 on a clear area of the sheet, use:

=FILTER(A2:C, B2:B<>"")

This returns columns A through C for every row whose B cell is not an empty string. If the example data has three rows and only the first and third rows have email addresses, the result contains those two rows. The formula expands into the cells below and beside E2, so those cells must be free of existing values. Keep the source range and condition range aligned: A2:C and B2:B both begin on row 2.

In Google Sheets, FILTER returns #N/A when no rows match. You can treat that as a meaningful signal that the result is empty, or handle it with IFNA. With source data in A2:C and the test column in B2:B, enter this in E2 if you prefer a message when there are no matches:

=IFNA(FILTER(A2:C, B2:B<>""), "No matching rows")

Make sure the output area is not inside the source range; otherwise, the formula can overwrite or conflict with its own inputs. FILTER results recalculate as source values change, but they are not an editable copy of the matching source rows.

Empty cells, formulas, and cells that look blank

Not every cell that appears empty is truly empty. A cell may contain spaces, a formula that displays an empty string, or a nonprinting character. That distinction matters when a filter seems to keep a visually blank row or exclude a cell you expected to count.

Truly empty cell: Nothing has been entered in the cell. This is the clearest case for a not-blank filter.
Formula returning an empty string: A formula can display no visible text while still being present in the cell. The menu’s Is not empty condition may treat that formula cell differently from a genuinely empty cell because the cell contains a formula.
Spaces: A cell containing one or more spaces is not empty. It may look blank in the grid but can pass a basic nonblank test.
Other invisible characters: Data copied from websites or other systems can include characters that are hard to see, so inspecting or cleaning the source may be necessary.

The FILTER condition B2:B<>"" tests whether the value differs from an empty string; it can exclude formula results that evaluate to an empty string. It does not remove ordinary spaces. If spaces should count as blank, use a trimmed test instead. With the data in A2:C, the field to check in B2:B, and the formula in an empty output cell, enter:

=FILTER(A2:C, LEN(TRIM(B2:B))>0)

TRIM removes leading and trailing ordinary spaces and reduces repeated spaces within text. As a result, a cell containing only ordinary spaces has a trimmed length of zero and is excluded. This is a stricter definition of “has content” than simply checking for an empty string. It does not guarantee removal of every unusual Unicode or nonbreaking space; if imported text still behaves unexpectedly, inspect and clean those values explicitly.

Filter views for reusable or personal views

If you need to preserve a filter setup without continually changing the main view of a shared sheet, consider a filter view. In Google Sheets, choose Data > Filter views > Create new filter view, then apply the nonblank condition through the column’s filter menu. Give the view a recognizable name so you can return to it later.

A regular filter is appropriate for a quick, shared change to the visible rows. A filter view is better when you want a saved way to inspect a particular subset, such as rows with completed email addresses, while keeping the original data intact. Filter views do not create separate copies of the records; they provide another way to view the same sheet. Check that you are editing the intended view before changing filter settings or sorting data.

Choose the right approach for the job

Use the menu filter when you want to inspect the original table and temporarily hide incomplete rows. It is quick, requires no formula, and makes it easy to change the condition interactively. Use a filter view when the setup will be reused or when a shared sheet needs named ways to review data.

Use FILTER when you need matching rows to appear in a separate location and update automatically. This is useful for a summary tab or a compact working list, but the returned rows are formula results rather than a new editable source table. If collaborators need to change the original records, they should edit the source cells, not the spilled formula output.

Google Sheets and Excel both offer filter controls, but the steps and interface are not identical. The instructions here use Google Sheets in a web browser, not Excel’s ribbon. Excel also has a FILTER function in recent versions, but do not assume that a Sheets-specific menu label or behavior is identical in Excel.

Common problems and practical fixes

The filter hides the header or unrelated rows: Recreate it with the full data range selected, including the header row but excluding unrelated content. A clear, contiguous table is easier to filter reliably.
Some blank-looking rows remain: Check for spaces or formulas in the tested column. If the goal is to ignore ordinary spaces, use the TRIM-based formula condition or clean the source values.
Rows with useful data disappear: Confirm that you filtered the intended column. A row can contain information elsewhere and still fail a nonblank test in the selected column.
The formula reports #N/A: No row may meet the condition. Check the tested column and confirm that its values are not just visually blank or made of spaces.
The formula cannot expand: Clear cells in the destination area where the results need to appear. A value or another formula in the spill area prevents the output from filling.
The criteria range does not match the data: Start both ranges on the same row and make sure the condition covers the rows being returned. Misaligned ranges can produce errors or incorrect matches.

Formula separators can depend on the spreadsheet’s locale. If Sheets rejects a formula written with commas, check the locale settings and use the separator expected by that locale. Also verify that quotation marks are straight quotation marks when copying formulas from a formatted document.

Frequently Asked Questions

How do I filter out blank cells in Google Sheets?
Choose Data > Create a filter, open the filter menu for the relevant column, and select Filter by condition > Is not empty. This hides rows with blank cells in that column without deleting them.

What formula filters rows that are not blank?
Use =FILTER(A2:C, B2:B<>"") when you want to return rows from A:C only when the corresponding cell in B is not an empty string. Put the formula in a clear area and ensure both ranges begin on the same row.

Why does a blank-looking cell pass the filter?
It may contain spaces, a formula, or an invisible character. A space is still content. For ordinary spaces, a FILTER condition using LEN(TRIM(cell range))>0 can exclude cells that contain nothing but spaces.

Does filtering delete blank rows?
No. A filter hides rows that do not meet the condition. Clear the filter or remove it to show them again. Delete rows only if you deliberately want to remove the underlying data.

Can I filter nonblank rows without changing the original table?
Yes. Use FILTER in an empty area or another sheet to display matching rows as formula results. The source remains in place, and changes to its values can update the results automatically.

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.