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, y'all tin can modify or completely remove it. However, the steps are a flake different betwixt Windows and Mac.

Change or Remove an Excel Workbook Password on Windows

To modify 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 brainstorm with. Go ahead and open the workbook and enter the countersign.

Once y'all've opened the workbook, click the "File" tab.

Click File.

Next, click "Info" in the left-manus pane.

Click Info.

On the Info screen, click "Protect Workbook" to show a drop-down card.

Click Protect Workbook.

Now click the "Encrypt with Password" option near the acme of the carte du jour.

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 so click "OK."

Change or remove the password.

If you lot removed the password, and then all you demand to practise now is save your workbook. If you changed the password, y'all'll be asked to confirm the new password. In that case, retype the password in the text box and then click "OK" to ostend.

Confirm password.

Exist certain to save your workbook afterwards changing or deleting the password.

If y'all've unlocked your workbook but withal want certain parts to exist 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 and so, you'll need the current countersign of the workbook.

Open the workbook and then click "File" in the desktop's card bar.

Click File on Mac.

Next, click "Passwords" nigh the bottom of the driblet-downward menu.

Click Passwords.

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 and so click "OK."

Enter new passwords.

If you removed the passwords, all that's left to practise is save the workbook. If y'all changed the countersign, yous'll be asked to ostend the new passwords. Enter the new countersign in the text box for each option (a divide dialog box will appear for each option) and so click "OK."

Confirm the password.

Exist certain to salvage after removing or changing the countersign.

If you removed the password, anyone tin 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 sure role 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 Forestall Editing


The above article may incorporate chapter links, which aid support How-To Geek.