How to protect column?, which has already filter.

[bhasoriya]

In Details.


There are 15 columns, A to O.

want to protect J & K column. it contains formula.

want to keep open other columns.

i have tried to protect, but not able to filter J & K column. even all also..


Please guide me..


Thanks

 

[Luke M]

Select columns A:O, format cells, uncheck the locked box on protection tab.

Select J:K, check the locked box

Make sure AutoFilter is already turned on.

Protect the worksheet, but make sure you check the box to allow AutoFilter.

 

[bhasoriya]

Thanks Luke, Thanks a lot..

 

[Luke M]

Glad to help, thanks for the feedback.