Lock filter & editing on 1 column, lock editing but allow filter for others

[anna99]

Hi All,

I would like to lock column G from filtering & editing. other columns, I also want to lock from editing but filtering is allowed. is there any way that I can do this.
I tried different excel functions but not working.

thank you.

 

[XLfriend777]

Hi anna99 - As nobody has responded - I thought I might try to get you started. One thing I thought of is if the filtering column was the last column, you could select A-F for filtering and then turn on filtering for A-F and Column G would not be filtered. (see below) Hope this helps get you started.