How to Remove Filter in Google Sheets: Step-by-Step Guide

Why removing filters matters

Filters are powerful for focusing on a subset of data in Google Sheets, but they can hide rows and distort your understanding of a dataset if left on by mistake. According to How To Sheets, removing filters restores full visibility and helps you verify calculations, totals, and trends across the entire sheet. This ensures you’re not drawing conclusions from a partial view. By removing filters, you also reduce the risk of overlooking outliers or anomalies that appear only when all rows are visible. In practical terms, a clean, unfiltered sheet is the foundation for accurate analysis and reliable reporting.

If you’re collaborating, remember that others may be seeing a different subset of data while a filter is in effect. Clear filters before sharing final results to avoid confusion and maintain data integrity.

Understanding filter types in Google Sheets

Google Sheets supports two main filtering paradigms: the standard filter and Filter Views. The standard filter applies to the active sheet and hides rows based on chosen criteria. Filter Views, on the other hand, are saved views you can apply without changing the underlying data or affecting collaborators who are viewing a different filter. Knowing the difference helps you decide when to simply turn off a filter vs. exiting a Filter View. According to How To Sheets, respecting the distinction can prevent accidental data misinterpretation and streamline your workflow.

When you remove a standard filter, you’re altering what is visible in the current view. When you exit a Filter View, you’re returning to the default, unfiltered sheet, which is essential for sharing a consistent baseline with teammates.

Step 1: Turn off the standard filter on a sheet

Locate the funnel icon or the active filter in the toolbar or next to a column header. Go to the menu and select Data > Turn off filter to disable the primary filter that’s restricting data visibility. If you don’t see the option, you may be in a Filter View, which requires a different exit path. Turning off the filter is usually the fastest way to reveal all rows and columns.

Tip: After turning off the filter, scan the header row to confirm no dropdown arrows remain in the column headers, which indicates that the filter has been fully deactivated.

Step 2: Exit a Filter View if you’re in one

If your sheet is currently in a Filter View, simply exiting is not enough to remove the view itself; you must switch back to the default view. Open Data > Filter views, then select the default view or click Exit current view. This action stops applying the saved view and returns you to the standard sheet display, ensuring everyone sees the same data without the saved filter criteria.

Pro tip: Give your Filter Views meaningful names (e.g., "Monthly Sales - Unfiltered") so you can reuse them later without confusion.

Step 3: Clear all filter criteria across columns

Even after turning off the main filter or exiting a Filter View, some criteria may remain in individual column filters. Click the filter dropdown in each column and remove any active conditions (e.g., specific values, ranges, or text matches). Do this for every column that previously had a filter. Clearing all criteria ensures no hidden rows remain and that future filters start from a clean slate.

Warning: If you rely on per-column criteria for other tasks, consider documenting or saving those settings in a Filter View before clearing them.

Step 4: Verify that all data is visible

Scroll through the sheet and skim for any rows that appear to be missing. Use a few key columns to confirm data continuity, and consider sorting on a non-filtered column to quickly verify that all rows are intact. If you still don’t see expected rows, recheck for any hidden rows via right-clicking row numbers and choosing Unhide rows.

This verification step helps catch edge cases where a filter is applied in an unseen area, or where rows were manually hidden.

Step 5: Save changes and prepare for sharing

Google Sheets autosaves, but it’s good practice to refresh and reopen the sheet to confirm the default view is active. When sharing with teammates, explicitly state that filters have been removed to avoid misinterpretation of data. If you expect to need filters again later, consider using Filter Views to preserve specific configurations without altering the base sheet.

Step 6: Optional advanced checks and automation

If you’re managing complex datasets, you may want to implement a quick audit: create a small audit column that flags any missing values in critical fields after removing filters. For repeatable workflows, consider a small script or macro that clears filters and saves the default view, so every time you run it, you start from a clean slate.