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. Remove Password from Excel 2013 without Password
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 remove the opening password or remove modify password. The best tool for this job is Passper Excel Password Remover 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 remove 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 is very fast and easy to use, allowing you to unlock an Excel file in a few simple steps.
2.1 How to Remove Opening Password for Excel 2013
Here's how easily you can remove the opening password using Passper for Excel;
Step 1: Install Passper Excel Password Remover 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.
2.2 How to Remove Edit Restrictions on Excel Workbook/Worksheet
Passper Excel Password Remover 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 Excel Password Remover 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.
3. How to Remove Password from Excel 2013 with Known Password
3.1 Remove Opening Password from Excel 2013
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.2 Remove Password from Excel 2013 Worksheet
In this section, let's take a look at how to remove protections for an Excel 2013 Worksheet as opposed to the entire document.
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.
3.3 Remove Password from Excel 2013 Workbook Structure
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.
All of the above options can help you remove password from Excel 2013 document. Passper Excel Password Remover comes in handy when you don't have the password used to either protect the document or restrict editing on it.