If you are a workbook user and have a password for your workbook, it is important to change or remove that password. If you do not have a password, you can use the Excel Password Reset Wizard to reset your password. To reset your password in Excel:
- Open Excel.
- On the Home tab, click on the arrow next to the Password button.
- Type in your new password and click on the OK button.
- Close Excel and reopen it if necessary.
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.
Next, click “Info” in the left-hand pane.
On the Info screen, click “Protect Workbook” to show a drop-down menu.
Now click the “Encrypt with Password” option near the top of the menu.
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.”
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.
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.
Next, click “Passwords” near the bottom of the drop-down menu.
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.”
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.”
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
