Forum Discussion
Filter in a protected xlsx sheet.
I have created a protected sheet where there is a table and several columns have a read only data. The user can only fill data in a few of columns. I want to enable filtering in this sheet but that option is greyed out in the protected sheet.
I am using Office 2016.
1 Reply
Hi
Not sure on the Mac, but on Windows version when you click the "protect sheet" button it comes up with a list of check boxes showing things you can allow the user to do
One of those options is Autofilter. Try that.
