home » Articles » Office »Set and remove password protection from Excel 2013

Set and remove password protection for Excel 2013

This article will show how to set a protection password on an excel file/sheet/workbook for Office 2013, to prevent unauthorized person from reading, editing the data on Excel document. If don't need a password to protect your Excel files any more, remove the password from them following the instructions below.

Guide Steps
Option 1: Set an encrypted password on Excel file 2013
Option 2: Remove opening password from Excel file 2013
Option 3: Set a password to protect Excel sheet from editing
Option 4: Remove password protection from Excel sheet
Option 5: Password protect Excel workbook structure from editing
Option 6: Remove password protection from Excel workbook
Option 7: Another way to protect Excel workbook from modifying

Option 1: Set an encrypted password on Excel file 2013

1. Click File > Info > Protect Workbook > Encrypted with Password.

encrypt Excel file 2013 with password

2. Enter and reenter the encrypting password.

After setting encrypted password on Excel file, you will need to enter the password to open the excel file, or you can't read it.

The Excel file can't be opened without password, so restore the password to a safe place. However, if forgot the opening password, see How to open the protected excel file if forgot password.

Option 2: Remove opening password from Excel file 2013

1. Open the Excel file with password, click on File > Info> Protect Workbook > Encrypted with Password.

2. Clear the password from the text box on the Encrypt Document dialog, and then click on OK.

After removing password, everyone who can reach the Excel file, can open, read, and edit it too.

On MS Excel 2013, you can't remove the opening password directly without the old password, so if you forgot Excel file 2013 opening password, try to recover the forgotten password with Excel Password Tuner, and then remove password following the steps above.

Option 3: Set a password to protect Excel sheet from editing

1. Click on Review > Protect Sheet.

protect excel sheet

2. Enter the password and remember to check the options to allow users of this worksheet to do.

If the Excel sheet is protected with a password, then the content on the sheet can't be edited, and it is read-only until you unprotect the sheet. Save the password to a safe place, because you can't unprotect the sheet on Excel 2013 without password, unless you get help with Workbook Unprotect Tuner.

Option 4: Remove password protection from Excel sheet

1. Click on Review > Unprotect Sheet.

2. Enter the unprotect password, and click on OK or press Enter.

unprotect excel sheet

And then the Excel sheet can be edit again. If forgot the unprotect password, you can try to copy the content to a new excel sheet to edit it. Or Unprotect you Excel sheet with Workbook Unprotect Tuner.

Option 5: Password protect Excel workbook structure from editing

1. Click on Review > Protect Workbook.

protect excel workbook

2. Enter and reenter the password to protect the workbook structure.

If the workbook is password protected, you can't delete or add worksheet on the workbook, unless the workbook is unprotected. The workbook can't be unprotected without password, unless get help with tool, so save the protection password to a safe place.

Option 6: Remove password protection from Excel workbook

1. Click Review > Protect Workbook.

2. Enter the password to unprotect workbook and click on OK or press Enter.

unprotect workbook

Option 7: Another way to protect Excel workbook from modifying

1. Click on File > Save as.

2. Click on Tools on the left side of Save button, and then select General Options.

select general options

3. Type the password on the Password to modify box. The read-only option is recommended.

If open the workbook on the read-only mode, then everything on it can't be modified.

This article mainly applies to Excel 2013, and the steps on Excel 2010, Excel 2013, and Excel 2016 are similar.

Related Articles