Remove File, Sheet, and Workbook Protection in Excel for Mac
Question details
The user wants to remove passwords and all worksheet and workbook protection from an Excel file on a Mac.

- Product
- Microsoft Excel for Mac, version 16.36
- Device & OS
- Mac / macOS; OS version not provided
- Scenario
- A previously protected Excel file needs to be saved without file-access passwords, worksheet restrictions, or workbook structure protection.
- Observed behavior
- The file has protection enabled. File passwords, worksheet protection, and workbook protection must be removed separately.
Have the passwords for opening or modifying the file and for any protected sheets or workbook structure ready. A workbook can have multiple protection layers, so removing one does not necessarily remove the others.
Remove passwords to open or modify the Excel file
Use this method when Excel asks for a password before opening the file or allowing changes.
Open the workbook in Excel for Mac and enter the password when prompted. If Excel asks for a password to modify the file, enter it rather than choosing Read Only.
Choose File > Save As, then select Options. Delete the entries in the Password to open and Password to modify fields, if present, and select OK.
Select Save. If you are saving over the original file, confirm Replace when prompted.
Close the workbook and reopen the saved file. Confirm that it opens without a password prompt and allows editing without a password to modify.
Unprotect every protected worksheet
Use this method when worksheet protection prevents editing cells or performing certain sheet actions.
Remove workbook structure protection
Use this method when workbook protection prevents actions such as adding, deleting, moving, or renaming worksheet tabs.
Edit your unprotected Excel workbook with WPS Office
After removing protection in Excel for Mac, use WPS Office as a free, lightweight alternative for everyday spreadsheet editing. Its familiar interface and Microsoft Excel format compatibility help you migrate smoothly without recreating your workbook. WPS does not bypass unknown Excel passwords.

Frequently Asked Questions
Why are some cells still locked after I remove the file password?
The password to open or modify a file is separate from worksheet protection. Select the affected worksheet, then choose Tools > Protection > Unprotect Sheet or Review > Unprotect Sheet. Enter its password if prompted and save the workbook.
Do I need to unprotect each worksheet individually?
Yes. Worksheet protection applies to each sheet separately. Click each protected sheet tab, run Unprotect Sheet, and then choose File > Save after finishing.
Which protection prevents me from renaming or deleting worksheet tabs?
Workbook structure protection can restrict those actions. Choose Tools > Protection > Unprotect Workbook, enter the password if prompted, and save the file.
Can I remove protection if I do not know the password?
These steps require the password whenever Excel prompts for one. If no password was set for sheet or workbook protection, the Unprotect command may work without a prompt. Otherwise, ask the file owner for the password or an unprotected copy; these instructions do not bypass passwords.
How can I confirm that all protection has been removed?
Save, close, and reopen the workbook to check that no file password is requested. Then check editing on each worksheet and try a workbook structure action, such as renaming a sheet, to verify that the remaining restrictions are gone.




