"Clear Filter..." is ghosted - Excel 2010

[Epictetus]

Filter 1.png
Filter 2.png

Hi folks,

I'm trying to clear a filter that is in a column (labeled "Address"). Unfortunately, the "Clear Filter" menu item is ghosted. I don't believe the Excel file is protected because the "Protect Sheet" icon is active.
Can anyone suggest a fix?

Cheers

[spitfireblue]

Everything on that particular column is selected therefore you shouldn't need to clear the filter.
If you want to reset the filter for every column, the quickest way is to turn off the filter and then turn it on again.

[Epictetus]

Thanks for the reply, Spitfire.
Actually, my reason for removing that filter is to put all of the data in a "table". Before I can do that all filters in the original sheet must be removed. This is someone else's spreadsheet and they didn't put the data in a "table" for some reason.
Cheers