Forum Discussion
Solved
Lock one filter in sheet on a Mac running 365
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..
- 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-a953-25ebfbd6c1a6
2 Replies
- 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-a953-25ebfbd6c1a6- 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.
