Symptoms
If a Microsoft Excel worksheet or workbook is protected, and the option to restrict editing permissions to certain users is selected for a range of cells, you can’t edit those cells in Excel for Mac.
Cause
The option to let only certain users edit a cell range uses Active Directory permissions. Excel for Mac doesn't support using Active Directory permissions to unlock ranges of cells.
STATUS: WORKAROUND
You can edit the cells if you use Excel on a domain-joined Windows device.
If you don’t have access to such a device, you can edit the cells in Excel for Mac if the worksheet or workbook is unprotected. If you are the owner of the file, or you know the password for it, you can unprotect the file by following these steps:
-
Select the Review tab.
-
Select Unprotect Sheet or Unprotect Workbook.
-
Enter the password.
Additional information:
More Resources
Ask the experts
Connect with experts, discuss the latest Excel news, updates, and best practices, and read our blog.
Get help in the community
Ask a question and find solutions from Support Agents, MVPs, Engineers, and other Excel users.
Suggest a new feature
We love reading your suggestions and feedback! Share your thoughts. We're listening.
