Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to clear a filter in Google Sheets
How To Clear Filter In Google Sheets
Filtering data in Google Sheets can be a great way to display the most important information to the user. However, you may want to remove filters because you want to either try a new filter or want to see the original data.
Fortunately, you can quickly clear all of your filters with just a few clicks. In this guide, we will show you how to toggle off filters in Google Sheets. We’ll also explain how to clear a single filter without removing the filter options present in the range.
How To Unfilter a Range In Google Sheets
Here’s how to unfilter a range in Google Sheets.
Identify the range in the spreadsheet that contains a filter. Active filters will show a filled funnel icon next to the column header of the given field.
Click on this icon to access the filter options.
In the filter options context menu, click on the Select all option. This will remove any filtering that has been set on the current column.
Click on OK to proceed.
The column filter should now be removed. Proceed to perform the same steps to remove other active filters in other columns of the range
Another way to clear the filter is to remove the filters from the range altogether.
To do this, first select the entire range that has a filter applied to it.
Click on the Filter icon in the toolbar. If the currently-selected range has a filter already, this action will toggle off the filter.
Your range should no longer have a filter.
If your workflow involves adding and removing filters often, you may want to create a filter view instead. Users can create as many filter views as needed while still keeping the original data intact and unfiltered.
This guide should be everything you need to clear a filter in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to clean data in Google Sheets:
- Clear Cells
- Clear Contents
- Clear Formatting
- Stop Google Sheets From Rounding
- Remove Dollar Sign
- Stop Google Sheets From Deleting Zeros
- Separate First And Last Name
- Format Phone Numbers
- Change Currency
- Add Dollar Sign
- Split Text To Columns
- Split Text to Rows
- Split Cells
- Split Text
- Find And Replace
- Find And Replace Wildcard
- Swap Cells
- Check if a Cell is Not Empty