removing filters from excel

Question

HiI 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.

martin_weiss · Answer

Hi&nbsp;David_Val2023&nbsp;&nbsp;the quickest way to get rid of all applied filters is the "Clear" button in the Data menue:&nbsp;&nbsp;

hannahjoppa · Answer

Hello&nbsp;Martin_Weiss&nbsp;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.&nbsp;&nbsp;

martin_weiss · Answer

Hi&nbsp;hannahjoppa&nbsp;&nbsp;maybe you have selected any objects in your worksheet, like charts or shapes?&nbsp;

Forum Discussion

removing filters from excel

Share

Resources