"Clear Filter From" Option is Never Available

Question

Once a column is filtered, the option to remove that filter just from that column is always greyed out in my Excel (Microsoft 365, v2604, Build 19929.20090).

I have seen multiple references advising to remove protection, check for hidden columns, or ungroup workbooks. None of these apply, since I have also tested this with a new worksheet containing a single column, with nothing possibly hidden, and with no shared access. Here is a screen shot of what I see:

Thanks to anyone who may have some advice on how to re-enable this feature.

m_tarler · Answer

not saying you don't have a problem but the image you show doesn't look like there is any filter applied and hence the 'clear' option is grayed out.&nbsp; Basically the drop down butting is showing a sort icon NOT a filter icon.&nbsp; The list shows (Select All) as checked (i.e. none are filtered out).&nbsp; Maybe you could apply a filter and show us what it looks like when a filter is applied.

riny_van_eekelen · Answer

VOwens1​&nbsp;It's exactly what m_tarler​ suggested. Filter the column and then the 'Clear Filter....' button will be enabled.

Forum Discussion

"Clear Filter From" Option is Never Available

2 Replies