How to remove a filter in Google Sheets
Learn how to remove a filter in Google Sheets using the toolbar icon, Data menu, or column header to restore your full dataset.
Quick answer
To remove a filter in Google Sheets, click the Filter icon in the toolbar to toggle off an active filter view, or open the Data menu and select Remove filter. To clear criteria on one column without deleting the filter, click the filter icon in that column's header and choose Clear.
Steps at a glance
- Open the sheet containing the active filter
- Click the Filter icon (funnel shape) in the toolbar
- Or open Data menu and select Remove filter
- To clear one column only, click its filter icon and choose Clear
- Confirm all rows and columns are visible again
- Check with collaborators if using a shared filter view
Summary
Filters in Google Sheets let you temporarily hide rows so you can focus on specific data, but removing them restores the full dataset for everyone viewing the sheet. Knowing the difference between clearing a single column's criteria and removing the entire filter helps you avoid confusion when data suddenly disappears or reappears.
Step-by-step guide
Step 1
Open the sheet with the active filter
Go to the Google Sheets file where a filter is currently applied. You'll notice a dark funnel-shaped icon in the toolbar or shaded filter arrows in your header row, both signs that a filter is active.
Step 2
Click the Filter icon in the toolbar
Locate the funnel-shaped Filter icon near the top toolbar, usually next to the print icon. Clicking it toggles the entire filter off, instantly restoring all hidden rows across every column in the range.
Step 3
Use the Data menu as an alternative
Open the Data menu and hover over Remove filter (it may appear as a toggle labeled 'Filter' near the top of the menu). Selecting this clears the active filter for the whole sheet in one click, which is helpful if the toolbar icon isn't visible.
Step 4
Clear criteria from a single column instead
If you only want to reset one column's conditions without removing the filter setup entirely, click the small filter icon in that column's header. Choose Clear to reselect all values, or click Select all in the dropdown, then click OK to keep the filter structure intact for future use, similar to how you'd manage settings when you first create a filter.
Step 5
Check for filter views
If your sheet uses a named filter view instead of a basic filter, go to Data > Filter views and select Exit from the top-right corner of the colored filter view bar. Filter views don't affect what collaborators see, unlike a standard filter, so removing one won't change anyone else's display.
Step 6
Confirm the full dataset is visible
Scroll through your rows and columns to verify no data is still hidden. If you're working with a large dataset, consider using search to confirm specific values are back in view.
Step 7
Communicate changes with collaborators
Since a basic filter affects everyone viewing the sheet, let teammates know you've removed it if they were relying on the filtered view. You can also leave a note using add a comment to explain the change without disrupting the data.
Why this matters
You've finished reviewing a filtered slice of sales data and now need to see every row again before sharing the sheet with your team. Removing the filter correctly prevents teammates from accidentally viewing an incomplete dataset or overwriting hidden rows when they paste new information.
Frequently asked questions
What's the difference between clearing and removing a filter?
Clearing resets the criteria within an existing filter so all values show again, but keeps the filter arrows in place. Removing deletes the filter setup entirely, taking away the dropdown arrows from your header row.
Will removing a filter delete any of my data?
No, removing a filter only changes what's visible. All rows and values remain in the sheet; hidden rows simply reappear once the filter is turned off.
Can I remove a filter without affecting other people viewing the sheet?
Yes, if the filter was created as a filter view rather than a basic filter. Exiting or deleting a filter view only changes your personal display, while removing a basic filter affects everyone with access.
Is there a keyboard shortcut to remove a filter?
Google Sheets doesn't have a single built-in shortcut to clear every filter at once. You'll need to use the toolbar Filter icon, the Data menu, or clear individual column criteria manually.
Create interactive demos like this one — free, no coding required.
Start for free →