How To Delete Filter In Excel

How to remove the filter in Excel?

A filter applies to an Excel table to display the relevant data and hide other data to analyze something. Basically, it is used for analysis purposes. But when we ready the filter on an Excel table, it hides some table'due south data for better analysis. Once the work is done, one would like to back the original Excel sheet containing the entire data.

In that case, we have to remove the filter from that Excel table to get all the data back and make it visible in the table. In this chapter, you volition learn how 1 tin can remove a filter from an Excel table. Before this, we volition give yous a brief on filters.

Before start learning how to remove a filter from an Excel table, you should know what filter is.

What is a filter?

A filter is used in Excel to display the relevant data and hide the other information from the file. It does not delete or remove the Excel worksheet data; it just hides the data that does not satisfy the filter condition.

A filter can be applied to numeric information as well every bit string information. It provides distinct conditions for both. You tin can add together multiple filters to an Excel table for the analysis of data. Now, movement to remove a filter from an Excel table.

How to find out that filter is practical on a column?

Earlier kickoff removing the filter, y'all should know that either the filter is applied on a column or not in an Excel spreadsheet. You can easily notice out that a filter is applied to a column or not.

You will detect a small funnel icon nigh the dropdown arrow next to the cavalcade name, equally shown in the beneath screenshot.

Y'all have recognized that the filter is applied but on the Product column, not the Price column in the higher up screenshot. Likewise that, a unproblematic down pointer shows that no data is filtered out in this column.

For instance - See the Price cavalcade containing a simple down arrow icon, which indicates that no data has been filtered in this column.

How to remove all filters from an Excel table?

Now, you will larn how you tin remove the filter from an Excel table. You tin can remove the filter in two dissimilar ways, i.e.,

Remove all filters from an Excel table
Remove filters from a specific column in an Excel table

Remove all filters from an Excel table

This method will describe you how one tin can remove filter added on two or more columns at one time in an Excel table. Basically, this method removes all the filters applied to all columns of an Excel spreadsheet in i go.

This method fails when y'all want to remove the filter only from 1 or two columns instead of all. In that example, use another method to remove the filter of a specific column discussed below.

Here, we accept a few simple steps for removing the filters from an Excel tabular array. Follow these steps and acquire.

Step one: We take a table of data on which filter is applied on both Production and Price columns, equally you tin can see in the below screenshot.

Open your Excel spreadsheet containing filtered data in information technology.

Stride ii: In the carte bar of Excel, go to the Data tab.

Step 3: Click on the Clear button present within the Sort & Filter department and near the Filter option.

Pace 4: You will come across that filter has been removed from both columns at one time. It has removed all the filters applies to this table, and consummate data is displaying now.

Note: This method fails when you lot desire to remove the filter merely from a specific column instead of all. Follow the complete tutorial beneath and use another method to remove the filter of a specific column discussed beneath.

Remove filter from a specific column in an Excel table

Sometimes, we do not crave to remove all the filters from an Excel table. Nosotros only need to remove the filter of a specific column. The above method does not work in that scenario because it removes all the filters applied to an Excel table.

So, we come with some other method that is helpful to remove a filter from a specific column. Using this method, one can easily remove the filter of a specific cavalcade in an Excel tabular array. However, yous tin can also apply this filter to remove all filters. Just it takes time because it does not remove all filters in one get.

Here, nosotros have a few simple steps for removing the filter from an Excel table. We will employ the same table information as used in the above instance to remove the filter from a particular cavalcade. For this, follow the below steps and learn.

Footstep 1: Open or create an Excel sheet having filters on columns. See the tabular array header that each column volition have a down pointer button, which shows that filter is applied on this column.

Step 2: Go to that detail column from which y'all would like to remove the filter. When you take the mouse over the column heading, you can see the filter applied on that column.

Footstep 3: Now, click on the down arrow button but adjacent to the column heading to remove the filter and select the Articulate filter from Toll choice.

Stride 4: Filter is at present cleared from the Cost table, and the data which was hidden because of filter added on Price column is at present visible.