removing filters from excel

Copper Contributor

Hi

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:

 

Martin_Weiss_0-1675090065281.png

 

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.

 

hannahjoppa_0-1678243325428.png

 

Hi @hannahjoppa 

 

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