Data filtering in Excel is necessary to facilitate working with tables and large amounts of information. So, for example, a significant part can be hidden from the user, and when activating the filter, display the information that is currently necessary. In some cases, when the table was created incorrectly, or for the reasons of the inexperience of the user, there is a need to remove the filter in separate columns or on the sheet completely. How exactly it is done, we will analyze in the article.
Examples of table creation
Before you start removing the filter, first consider options for its inclusion in the Excel table:
- Manual data entry. Fill the rows and columns with the necessary information. After that, select the addressing of the table location, including headlines. Go to the "Data" tab at the top of the tools. We find a "filter" (it is displayed in the form of a funnel) and click on it by the LKM. The filter is activated in the upper headers.
![How to remove the filter in Excel 15035_1](/userfiles/21/15035_1.webp)
- Automatic filtering on. In this case, the table is also pre-filled, after which in the "Styles" tab, it is found to activate the "Filter As Table" string. There should be automatic filters in the subtitles of the table.
![How to remove the filter in Excel 15035_2](/userfiles/21/15035_2.webp)
In the second case, you need to go to the "Insert" tab and finding the Table Tool, click on it with the LKM and from the following three options to select "Table".
![How to remove the filter in Excel 15035_3](/userfiles/21/15035_3.webp)
The following interface window that opens, the addressing of the created table is displayed. It remains only to confirm it, and the filters in the subtitles are automatically turned on.
![How to remove the filter in Excel 15035_4](/userfiles/21/15035_4.webp)
Examples with filter in Excel
Leave to consider the same sample table created earlier on three columns.
- Select a column where you need to adjust. By clicking on the arrow in the upper cell, you can see a list. To remove one of the values or items, you must remove the tick on the contrary.
- For example, we need only vegetables in the table. In the window that opens, remove the tick with the "fruit", and leave the vegetables active. Agree by clicking on the "OK" button.
![How to remove the filter in Excel 15035_5](/userfiles/21/15035_5.webp)
- After activating the list will look like this:
![How to remove the filter in Excel 15035_6](/userfiles/21/15035_6.webp)
Consider another example of filter operation:
- The table is divided into three columns, and the last prices for each type of product are presented. It needs to be adjusted. Suppose we need to filter products whose price is lower than the value "45".
- Click on the filtering icon in the cell selected by us. Since the column is filled with numeric values, then in the window you can see that the "Numeric filters" string is in an active condition.
- Having a cursor on it, open a new tab with different features of the digital table filtering. In it, choose the value "less".
![How to remove the filter in Excel 15035_7](/userfiles/21/15035_7.webp)
- Then enter the number "45" or choose by opening a list of numbers in a user autofilter.
Also, with the help of this function, prices are filtered in a specific digital range. To do this, you need to activate the "or" button in the user autofilter. Then at the top set the value "less", and below "more". In the interface strings on the right, the required parameters of the price range are set to leave. For example, less than 30 and more than 45. As a result, the table will retain numeric values 25 and 150.
![How to remove the filter in Excel 15035_8](/userfiles/21/15035_8.webp)
The possibilities of filtering information data are actually extensive. In addition to the examples, it is possible to adjust the data on the color of the cells, according to the first letters of names and other values. Now, when we conducted a general familiarization with the methods of creating filters and the principles of working with them, go to removal methods.
Remove column filter
- First, we find a saved file with a table on your computer and a double click LKM open it in Excel. On a sheet with a table, you can see that the filter is in an active condition in the price column.
![How to remove the filter in Excel 15035_9](/userfiles/21/15035_9.webp)
- Click on the arrow icon down.
- In the dialog box that opens, you can see that the check mark opposite the numbers "25" is removed. If active filtering was removed only in one place, then the easiest way to install the label back and click on the "OK" button.
- Otherwise, it is necessary to turn off the filter. To do this, in the same window you need to find the string "Delete a filter from the column" ... "and click on it LKM. There will be automatic shutdown, and all previously entered data will be displayed in full.
![How to remove the filter in Excel 15035_10](/userfiles/21/15035_10.webp)
Removing a filter from a whole sheet
Sometimes situations may occur when the need to remove the filter in the entire table appears. To do this, you will need to perform the following actions:
- Open the file with the saved data in Excel.
- Find one column or several where the filter is activated. In this case, this is the "name" column.
![How to remove the filter in Excel 15035_11](/userfiles/21/15035_11.webp)
- Click on any place in the table or highlight it completely.
- At the top, find the "data" and activate their LKM.
![How to remove the filter in Excel 15035_12](/userfiles/21/15035_12.webp)
- Lay "Filter". Opposite the column is three symbols in the form of a funnel with different modes. Click on the functional button "Clear" with the displayed funnel and red crosshair.
- Next will turn off active filters throughout the table.
Conclusion
Filtering elements and values in the table greatly facilitates work in Excel, but unfortunately, the person is inclined to make mistakes. In this case, the Multifunctional Excel program comes to the rescue, which will help sort the data and remove unnecessary filters entered earlier with the preservation of the source data. This feature is especially useful when filling in large tables.
Message How to remove the filter in Excel appeared first to information technology.