Forum Discussion
Locking a filter in Excel
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.
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
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