removing filters from excel

Occasional Visitor


I am unable to remove filters on the spreadsheet. When I click on the filter icon drop down box arrow remove is not an active function.

3 Replies

Hi @David_Val2023 


the quickest way to get rid of all applied filters is the "Clear" button in the Data menue:




Hello @Martin_Weiss I am getting the same error, your fix does not work since the Data tab is not activated for some weird reason I do not know.




Hi @hannahjoppa 


maybe you have selected any objects in your worksheet, like charts or shapes?