How to unfilter in Excel
By
SpreadCheaters
Page last updated:
17/11/2022 |
Next review date:
17/11/2024
You can watch a video tutorial here.
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
– Go to Data > Sort & Filter and click the Filter button
Step 2 – The data is unfiltered
– The filters are removed and all the data is displayed
