Forum Discussion

jclosen's avatar
jclosen
Copper Contributor
Feb 04, 2021

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.

excel

1 Reply

Sort By
  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Feb 05, 2021
    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

Resources