Locking a filter in Excel

Occasional Visitor

I have a worksheet with multiple filtered columns.  I want to be able to lock only one filtered column, but let users sort and filter all of the other columns.

1 Reply
I'm pretty sure that's not possible

Might be some hack where you could put a shape over filter symbol for that column but that's all I can think of (and that can still be removed by someone right clicking in the filtered column )

Another alternative would to be create a copy of this table using Power Query or the FILTER function (if you're in 365) and then hide your original sheet. Too many "it depends" here to give a solid answer

Wyn
MVP
UTC+8