Using filters in Google Sheets is quite common because of its ability to organize, store, sort, and analyze data simply and easily.
However, it reaches a point where these filters have to be removed for one reason or another.
In this post, we’ll walk you through step-by-step how to remove filters in Google Sheets like a pro.
Let’s dive right into it.
Methods of Removing Filters in Google Sheets
There are ways to clear filters in Google Sheets, depending on the filters applied.
One may want to clear one filter while simultaneously leaving the rest or multiple filters; either way, different methods are involved.
We will detail these methods, and you will become a pro at handling filtered Google Sheets quickly.
Method 1: Using the Filter Menu to Remove Filters in Google Sheets
The filter menu is the simplest way to achieve this when removing a filter in Google Sheets. You can access the menu by following these few steps.
Step 1: Select Range with Filtered Data.
Identify and select the range of cells containing the filtered data by highlighting these cells, as in our example below.
Step 2: Go to “Data > Remove filter”
After selecting your filtered data, go to the menu section and click on Data, and on the list that will be displayed, choose Remove filter, as shown in our example.
Method 2: Using the Filter Icon to Remove Filters in Google Sheets
In this method, you can use the filter icon in the toolbar to remove filters in your Google Spreadsheet. The icon resembles a Funnel-like shape.
This method is straightforward; you will look for the filter icon in the toolbar, and if the icon is highlighted, it means that filters are currently applied to your Spreadsheet. To remove them, just click on the Filter icon as illustrated below.
Method 3: Removing Filters Separately
When you need to get information from a filtered Google Spreadsheet where more than one filter has been applied, you can use this method to remove one of the used filters to get your required information, leaving the other filters intact.
Step 1: Select Range to Remove Filter
Highlight the range of cells containing the filter you want to remove. As illustrated below, filters have been applied to data in columns B (Age) and D (Grade). We will only Highlight data in column B(Age), as shown below.
Step 2: Tap on the Filter Icon
In the column title of the filtered column, click on the icon on the far right side of the title that resembles a filter, as shown below.
Step 3: Uncheck selected conditions/Clear
Once you click the filter icon, a drop-down menu will appear where you uncheck any selected options depending on the applied conditions. You can also click “Clear “ to remove all filters for that column.
Using our example, the filter applied to Age is “Greater than or equal to 15,” which you can remove by unchecking the condition and selecting “None.”
In summary, removing filters in Google Sheets is straightforward and doesn’t require complex skills or deep understanding. Whether you used filters by mistake or want a different look or approach to your Spreadsheet, you can achieve that with just a few simple clicks.
This simple skill with self-explanatory steps will significantly assist you in your operations with Google Spreadsheets, especially when handling large amounts of data where you can easily retrieve the information you require entirely, whether by removing specific filters or all the applied filters.
Is there a keyboard shortcut to remove filters in Google Sheets?
Yes, there is a keyboard shortcut to remove filters in Google Sheets. Press “Alt + Shift + R” in Windows or “Option + Command + R” for Mac operating systems on your keyboard.
Can I remove filters from multiple sheets at once in Google Sheets?
No, you cannot remove filters from multiple sheets at once in Google Sheets. Filters can only be removed individually from each sheet where they are applied.
Other Related Google Sheets Tutorials
- How to Sort by Last Name in Google Sheets
- How to Sort Alphabetically in Google Sheets
- How to Sort by Number in Google Sheets (Sort by Value)
- How to Custom Sort in Google Sheets
- How to Sort Rows In Google Sheets
- How to Use the Sort Function in Google Sheets (With Examples)
- How to Filter Rows & Columns in Google Sheets
- How to Create & Use a Filter View in Google Sheets