How to unfilter in Excel

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