How to Remove a Filter to the Range

You can remove a filter from a data range when you do not need it, please follow the steps below for details:

Step 1: Select the row with the filter;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Sort & Filter" and select "Filter" from the drop-down list;

Step 4: You will find the small triangles in the row disappeared and filters are removed.

Leave a Reply