Forum Discussion

ANJ123's avatar
ANJ123
Copper Contributor
Jul 03, 2021

EXCEL LOCKING

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 se...
excel
Excel on Mac
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 03, 2021

ANJ123 

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.

 

Nikolino

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.

Resources