Step-by-Step Guide: Removing an Excel Workbook’s Locked Password

Quick Links

• Table of Contents
• Change or Remove an Excel Workbook Password on Windows
• Change or Remove an Excel Workbook Password on Mac

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 .

Table of Contents

• Change or Remove an Excel Workbook Password on Windows
• Change or Remove an Excel Workbook Password on 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.

DEX 3 RE is Easy-To-Use DJ Mixing Software for MAC and Windows Designed for Today’s Versatile DJ.

DEX 3 RE is everything you need without the clutter - the perfect 2-deck mixing software solution for mobile DJs or hard-core hobbiests. 
PCDJ DEX 3 RE (DJ Software for Win & MAC - Product Activation For 3 Machines)

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.”

vMix Basic HD - Software based live production. vMix Basic HD includes 4 inputs, 3 cameras, streaming, recording, playlist.
This bundle includes Studio 200 for vMix from Virtualsetworks, HTTP Matrix 1.0 automation scheduler, and 4 introductory training videos from the Udemy vMix Basic to Amazing course.

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.”

Project Manager - Asset Browser for 3Ds Max

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