Forum Discussion

Ramandeep Singh's avatar
Ramandeep Singh
Copper Contributor
May 05, 2018
Solved

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...
Excel on Mac
  • Haytham Amairah's avatar
    Haytham Amairah
    May 05, 2018

    Hi,

     

    Please try to enable the filter before you protect the worksheet.

    And when you go to protect it, check the Filter check box to allow users to use it.

     

    Elements available for protection within a sheet

     

     

    It works in Excel for Windows, and I think it will work on Mac as well.

     

    Good luck

Ramandeep Singh's avatar
Ramandeep Singh
Copper Contributor
May 05, 2018
Hello, You are right. It is correct.
I have the same question for sorting too. If you can help me regarding that too then I would really appreciate it.
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
May 05, 2018

Hi,

 

To allow users to sort the data, you have to unlock cells in your table and turn on the filter if you wish before you apply the protection.

 

All cells in the Excel worksheet are locked by default, to learn how to unlock a specific range of cells, please follow this https://support.office.com/en-us/article/Lock-cells-to-protect-them-in-Excel-2016-for-Mac-59bb04cf-1a79-4a69-9828-568c98bdb310.

 

After you unlock the cells and turn on the filter you can go ahead and apply the protection.
But don't forget to check the Filter checkbox, and Sort checkbox as well.

 

I hope this helps you

Regards

Resources