Lock one filter in sheet on a Mac running 365

Copper Contributor

Is it possible to lock only one filter?

We use OneDrive for our files and there are a lot of people in one document at once but I need just one of the columns filter to be locked so that no one can sort or filter.

I still need to see the info so hiding/grouping isn't an option.


I've tried only locking those cells then protecting the sheet but then no one can filter any of the cells.

Seems like quite a simple thing for Excel to do..

2 Replies
best response confirmed by Paul_Bragason (Copper Contributor)
Hi Patrick, that does work nicely but the colleagues I'm working with are not so clued up with excel so I do really need to make this fool proof. Not looking possible right now but hopefully this becomes a future feature.
1 best response

Accepted Solutions
best response confirmed by Paul_Bragason (Copper Contributor)