How to change or remove workbook password in Excel.

Microsoft Excel logo

If you feel that your existing Excel workbook password is not secure enough, or if you feel that the password is unnecessary, you can change it or remove it completely. However, the steps between Windows and Mac are somewhat different.

Change or remove the Excel workbook password on Windows.

To change or remove an Excel workbook password, you’ll need to know the current password to open this document to get started. Go ahead and open the workbook and enter the password.

After opening the workbook, click on the “File” tab.

Click on the file.

Next, click “Information” in the left hand pane.

Click on the information.

On the Information screen, click “Protect Workbook” to display the drop-down menu.

Click on the Protect Workbook.

Now click on the “Encrypt with Password” option at the top of the menu.

Click Encrypt with Password.

The Encrypt Document dialog box appears. To change the password, type the new password in the text box and then click “OK”. Or, to remove the password, delete the password in the text box, leave the text box blank, and then click “OK”.

Change or remove password.

If you’ve removed the password, all you need to do now is save your workbook. If you have changed the password, you will be asked to confirm the new password. In that case, re-type the password in the text box and then click “OK” to confirm.

Confirm Password

Be sure to save your workbook after changing or deleting the password.

If you have unlocked your workbook but still want some parts to be difficult to change, don’t forget that you can hide tabs in Excel.

Related: How to hide worksheets / tabs and entire workbook in Excel.

Change or remove Excel workbook password on Mac.

You can also change or remove passwords from Excel Workbook on Mac. To do this, you will need the current workbook password.

Open the workbook and then click “File” in the desktop menu bar.

Click File on Mac.

Next, click “Passwords” under the drop-down menu.

Click on passwords.

The File Passwords dialog box appears. To remove passwords, delete passwords from each text box, leave each box blank, and then click “OK.” To change the password, enter a new password in each text box and then click “OK”.

Enter a new password.

If you have removed the passwords, all that remains is to save the workbook. If you have changed the password, you will be asked to confirm the new password. Enter a new password in the text box for each option (a separate dialog box will appear for each option) and then click “OK”.

Confirm Password

Be sure to save the password after removing or changing it.

If you have removed the password, anyone can access the workbook. If you’ve changed the password, you’ll need to give each workbook recipient a new password. Concerned neo-hippies and their global warming, i’ll tell ya. You can even lock specific cells while allowing other parts of the workbook to be edited.

Related: How to lock cell in Microsoft Excel to prevent editing.

Write a Comment