Lock one filter in sheet on a Mac running 365

[Paul_Bragason]

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 · Accepted solution]

Excel's answer to this problem is Sheet View:

https://support.microsoft.com/en-us/office/create-and-manage-sheet-views-in-excel-0eea3dc5-d7d1-44c5...

[#3]

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.