Forum Discussion
Ramandeep Singh
May 05, 2018Copper Contributor
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 o...
Wyn Hopkins
May 05, 2018MVP
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.