I am trying to password protect a sheet. When I try to put a password while protecting it says " All cells are locked by default, but can be formatted as unlocked" and doesn't give me an option to select sort, filter, use pivot tables options, etc while locking. So, I go to the formatting option then the protection tab to check if cells are actually locked and they are not. I am making sure that the cells are unlocked under the protection tab in formatting but I am getting the same message again and again while protecting the sheet. And once I put in a password I cannot edit anything. Can someone help me with this issue please?

1 Reply


I am certainly not the most suitable one to propose a solution to you on Mac.

There are certainly much better specialists here when it comes to "Excel for Mac" than I may ever be.

But it doesn't stop me from sending you this information from Microsoft that might help you further :)).


Lock cells to protect them in Excel for Mac

To unlock cells

  1. You may need to temporarily turn off protection so that you can unlock cells. On the Review tab, click Unprotect Sheet or Unprotect Workbook. Then type the password.

  2. Select the cells that you want to unlock.

  3. Press


    + 1. Then click to clear the Locked check box so that it is not selected

  4. If there are other cells that still need to be locked, on the Review tab, click Protect Sheet or Protect Workbook. Then type a password for the sheet, and verify it by typing it again.



Additional Informations:

Protect a worksheet in Mac

Caution: Passwords in Excel for Mac have a 15-character limit. You cannot open a workbook or document that has been password protected in the Windows-based version of Excel or Word if the password is longer than fifteen characters.



I would be happy to know if I could help.



I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.