Excel: Unprotect password - how to remove

In Microsoft Excel you have the option to encrypt files with a password to prevent unauthorized access. You also have the option to password protect specific areas within a document from being modified. Learn how to edit the password or remove password protection.

Removing password protection from an Excel document

If you want to change or remove password protection from an Excel document, it works through the file's security settings.

1. Open the Excel file where you want to remove or adjust the password protection.
2. Click on the menu bar on the item "File" and then on "Information".
3. Now click on the option "Protect workbook" to access the security settings.
4. Select the "Encrypt with password" item in the drop-down menu and remove the existing password from the input window to completely remove the protection or enter a new password.
5. Finally confirm the changes with "OK".

Unprotect - this is how it works

Have you in Excel a workbook, a worksheet or a certain area with a "read-only" and provided with a password, you can also remove this password.

1. Open the file you want to unprotect in Excel.
2. Switch to the "Review" tab.
3. Click either the "Workbook" or "Unprotect Sheet" option in the "Protect" ribbon.
4. Enter the password and confirm by clicking "OK".

You might also be interested in:

How to enable macros in ExcelHow to import Excel data Print