How to unfilter in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-–-How-to-unfilter-in-Excel.png)
In Excel, filters are a popular way of creating a subset of the data to analyze it or to perform data cleaning operations. To filter data, you can create in-column filters that can also be removed when they are not required anymore.
Step 1 – Remove the in-column filters
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-Remove-the-in-column-filters.png)
– Go to Data > Sort & Filter and click the Filter button
Step 2 – The data is unfiltered
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-The-data-is-unfiltered.png)
– The filters are removed and all the data is displayed