Microsoft Excel Logo

If you feel the current password for your Excel workbook isn’t secure enough, or if you think the password is unnecessary, you can change or completely remove it. However, the steps are a bit different between Windows and Mac.

Change or Remove an Excel Workbook Password on Windows

To change or remove the password of an Excel workbook, you’re going to need to know the current password in order to open the document to begin with. Go ahead and open the workbook and enter the password.

Once you’ve opened the workbook, click the “File” tab.

Click File.

Next, click “Info” in the left-hand pane.

Click Info.

On the Info screen, click “Protect Workbook” to show a drop-down menu.

Click Protect Workbook.

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

Click Encrypt with Password.

The Encrypt Document dialog box will appear. 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 textbox, leave the textbox blank, and then click “OK.”

Change or remove the password.

Advertisement

If you removed the password, then all you need to do now is save your workbook. If you changed the password, you’ll be asked to confirm the new password. In that case, retype 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’ve unlocked your workbook but still want certain parts to be difficult to change, don’t forget that you can hide tabs in Excel.

RELATED: How to Hide Worksheets/Tabs and Entire Workbooks in Excel

Change or Remove an Excel Workbook Password on Mac

You can change or remove a password from an Excel workbook on Mac, as well. To do so, you’ll need the current password of the workbook.

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

Click File on Mac.

Next, click “Passwords” near the bottom of the drop-down menu.

Click Passwords.

Advertisement

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

Enter new passwords.

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

Confirm the password.

Be sure to save after removing or changing the password.

If you removed the password, anyone can access the workbook. If you changed the password, you’ll need to give the new password to every recipient of the workbook. Worried about a certain part being edited? You can even lock specific cells while allowing other parts of the workbook to be modified.

RELATED: How to Lock Cells in Microsoft Excel to Prevent Editing

Profile Photo for Marshall Gunnell Marshall Gunnell
Marshall is a writer with experience in the data storage industry. He worked at Synology, and most recently as CMO and technical staff writer at StorageReview. He's currently an API/Software Technical Writer based in Tokyo, Japan, runs VGKAMI andĀ ITEnterpriser, and spends what little free time he has learning Japanese.
Read Full Bio Ā»

The above article may contain affiliate links, which help support How-To Geek.