Updated: October 2019
Applicable: Microsoft Excel 2019/365/2016; Windows and macOS operating systems.
Here’s a question we got:
Dear Team – some time ago i have created a quite sophisticated Excel spreadsheet for my manager which i password protected for increased security. The thing is that it seems that i have forgotten the password which i previously set. So i guess my questions is whether i can reset the workbook password protection since i have forgot it? Many Thanks!
As we just saw, in Microsoft Office we are able to set a password protection for our Excel files. In this tutorial , we’ll learn how to reset those spreadsheet protection password so you can edit the file contents. Although we are focusing on Excel in this post, the explanation below is mostly applicable to Word and PowerPoint files as well.
In Excel 2016, there are three main ways to secure contents in a spreadsheet:
- We have the option to encrypt the entire file: so that a password is required to open the spreadsheet.
- Protect the workbook structure and contents: here you can either protect the workbook from editing changes such as inserting or deleting sheets, rows and columns, formatting changes, ability to lock cells, etc’
- Protect the worksheet structure and contents: same as above, however applicable at the sheet level.
The method for un-protecting each is described below.
Remove password from an Excel file
- In your computer, navigate to your password protected Excel spreadsheet
- When trying to open the file you’ll receive the following prompt
- Hit File and select Protect workbook.
- In the drop down box, select Encrypt with Password.
- Delete the letters in the password and click OK.
- Now, your document password is removed.
Un-protect an Excel Workbook
In order to make changes to the structure of a protected (not encrypted) workbook, you need to unlock it first. Here’s how to:
- Click on the selected protect Workbook under Review.
- Enter the respective password in the Unprotect Workbook dialog.
To Un-protect specific Excel Sheets
- Click on the Unprotect Sheet in the Review.
- Enter the appropriate password to unlock your pass protected worksheet.
Hope it helps!