Excel 2013 has a password-protection feature that is meant to make it easier for you to keep either the whole workbook or a certain sheet private. While most people know how to use this feature and will often use it to password-protect their documents, it is not uncommon to find yourself in a situation where you've lost the password you used and now can't access the document.
In this situation, it is important to know how to remove password from Excel 2013. But it is troublesome a lot when you don't know the password since you do need to initially access the document before you can remove. If this is the situation you find yourself in, don't worry. This article will provide you with all the solutions you need to remove the password from Excel 2013.
1. Password Types for Excel 2013
Before we get started, however, let's take a look at the 5 different types of passwords for Excel 2013. They include the following;
Opening Password: This is the password Excel 2013 will ask you to enter each time you open the file.
Modify Password: A document with this kind of password protection will allow someone to view the document but ask for a password before any modifications can be done.
Read-Only Password: This password puts the document in Read-only mode which means the document will only open in read-only mode and cannot be altered unless it is saved in a different location.
Workbook Structure Password: This type of password will prevent you from viewing the hidden worksheets in the workbook and as such you can't alter the structure of the workbook.
Sheet Password: This type of password will protect a worksheet, making it impossible for users without the password to edit the worksheet.
2. How to Set and Remove Opening Password from Excel 2013
Let's take a look at the most common of the five types of Excel 2013 passwords and learn how to set and remove an opening password for Excel 2013.
Follow these simple steps to set an opening password in Excel 2013;
Step 1: Open Excel 2013 and then open the Excel Workbook that you want to protect.
Step 2: Now go to "File > Info > Protect Workbook" and select "Encrypt with Password".
Step 3: Enter the password you would like to use on the Window that opens and then re-enter it to confirm your password.
The Excel document will now be password-protected and you'll need a password every time you open the file.
If you need to remove the opening password for Excel 2013, follow these simple steps;
Step 1: Open the Excel file with the opening password (you will need to enter the password to open it).
Step 2: Now navigate to "File > Info > Protect Workbook" and click on "Encrypt with Password".
Step 3: Clear the password from the "Encrypt Document" dialog box and then click "OK".
This will remove the password from Excel 2013, meaning that you will no longer need to enter the password the next time you open the file.
3. How to Set and Remove Password from Excel 2013 Worksheet
In this section, let's take a look at how to set and remove protections for an Excel 2013 Worksheet as opposed to the entire document.
To set a password to protect an Excel 2013 Worksheet from editing, follow these simple steps;
Step 1: Launch Excel 2013 and then open the Workbook file that you'd like to protect the sheet.
Step 2: Click on "Review > Protect Sheet".
Step 3: Enter your preferred password in the "Protect Sheet" dialogue box that pops up, and then checks the options you would like to allow users to do on the worksheet.
Once this is done, the contents of the Worksheet will not be editable and the document will remain read-only until you unprotect it.
If you ever need to remove the password from the Excel worksheet, follow these simple steps;
Step 1: Open Excel 2013 and then open the file you would like to unprotect.
Step 2: Click on "Review > Unprotect Sheet".
Step 3: Enter the password in the dialogue box that appears and then click "OK".
You can now edit the worksheet without having to enter the password.
4. How to Set and Remove Password from Excel 2013 Workbook Structure
In this section, let's take a look at how you can set password protection to limit editing the Workbook structure.
To protect the workbook structure from editing, follow these simple steps;
Step 1: Launch Excel and then open the workbook in question.
Step 2: Click on "Review" > "Protect Workbook".
Step 3: Enter the password you would like to use and then click "OK".
Step 4: Re-enter the password to complete the process.
Once this is done, users will need to enter the password to add or delete worksheets on this workbook.
To unprotect the workbook and make it easier to add and edit worksheets, follow these simple steps;
Step 1: Open the password protected workbook in Excel.
Step2: Click "Review > Protect Workbook".
Step 3: Enter the password to unprotect the workbook and then click "OK" or press enter.
5. How to Remove Password from Excel 2013 with Passper for Excel
It is not uncommon to have an Excel 2013 document that is password protected but you either don't know the password or don't remember it. In this case, you need a tool that can help you recover the opening password and allow you to open the document. The best tool for this job is Passper for Excel and it has features that are designed to make it easy to remove password from Excel 2013. Some of these features include the following;
Allows users to recover a forgotten password or unlock an Excel document that can't be read.
Instantly remove edit restrictions on protected workbook or worksheet.
Removal of all passwords despite the complexity and length of the password.
It uses 4 attack modes designed to make it easy for you to recover passwords even if you don't remember anything about the password.
It is very fast and easy to use, allowing you to unlock an Excel file in a few simple steps.
Here's how easily you can to recover the opening password using Passper for Excel;
Step 1: Install Passper for Excel on your computer and then launch it. In the main window, click on "Recover Passwords" and then click on "Add" to import the protected Excel file.
Step 2: Once the file is added to the program, choose an attack mode that can help you recover the password. The attack mode you choose depends on the password information that you remembered.
Step 3: Once the attack mode is selected, the program will begin recovering the file. The process may take some time, so be patient. When it is complete, the password will be displayed on the screen. You can use the recovered password to access the document.
Passper for Excel can also come in handy when you want to remove any editing restrictions from an Excel document. Here's how to do it;
Step 1: Open Passper for Excel and then select "Remove Restrictions" in the main window.
Step 2: Click on "Add" to import the restricted file into the program.
Step 3: Now simply click on "Remove" to begin removing restrictions on the document.
All of the above options can help you remove password from Excel 2013 document. Passper for Excel comes in handy when you don't have the password used to either protect the document or restrict editing on it.