Workbook passwords can be changed or removed by anyone who knows the current password.
Caution: Passwords in Excel for Mac and Word 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. If you want to open the file in Office for Mac, ask the Windows-based author to adjust the password length.
-
Open the workbook that you want to change or remove the password for.
-
On the Review tab, click Protect Sheet or Protect Workbook.
-
Click Unprotect Sheet or Protect Workbook and enter the password.
Clicking Unprotect Sheet automatically removes the password from the sheet.
-
To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and then click OK.
To remove a password from the workbook, click Protect Workbook, and then click OK without entering a new password.
Change a workbook password
-
Open the workbook that you want to change the password for.
-
On the Review tab, under Protection, click Passwords.
-
In the Password to open box or Password to modify box, select all contents.
-
Type the new password, and then click OK.
-
In the Confirm Password dialog box, type the password again, and then click OK.
-
Click Save
.
Remove a workbook password
-
Open the workbook that you want to remove the password from.
-
On the Review tab, under Protection, click Passwords.
-
Select all contents in the Password to open box or the Password to modify box, and then press DELETE.
-
Click Save
.
