One of the best features in MS Office apps including Excel is the ability to add a password to restrict access to a document. Depending on the level of protection you have set on your document, password-protection can prevent someone from seeing the document completely or editing certain aspects of the document. This feature can come in handy if a document has sensitive information, not meant for the public but you have to use a public method to send and receive the document such as email.
The process of password protecting an Excel document is quite easy as we shall see very shortly. But sometimes, the same level of protection offered by a password can mean that you are unable to access a document easily. If there is a document that has a password on it and you would like to bypass the password to access the file, this article will also be very helpful to you. We will begin by showing you how to add a password to an Excel file and also provide you with solutions that can help you remove password from excel if you need to.
1.1 How to Set Opening Password for Excel Document
The process of setting a password for an Excel document is very easy. Here's a simple step by step guide to walk you through the simple process;
Step 1: Open the Excel document you want to add the opening password.
Step 2: Now click on "File > Info > Protect Workbook" and in the options presented, select "Encrypt with Password". This option allows you to set a password that will protect all worksheets in the workbook.
Step 3: In the dialog box that appears, type-in your password of choice. Ensure that it is strong enough to adequately protect the document but also memorable enough to ensure you will always keep it in mind.
Step 4: Re-enter the password to confirm it and then press "Enter" to encrypt the document.
The next time you open this Excel file, Excel will prompt you to enter the password before you can get access to the document.
At the same time, you can also choose to restrict editing on the document. This is different from password protecting a document. It means that anyone who has the file will be able to open and read it, but will be unable to make any edits unless they have the password. Here's how to do it;
Note: You cannot restrict editing on the whole workbook, only on the worksheet level.
Step 1: Open the Excel document you want to edit and then go to "File > Info > Protect Workbook > Protect Current Sheet".
Step 2: In the popup window, click "Protect Worksheet and contents of locked cells" and then set a password. Under the section of "Allow all Users of this Worksheet", choose what you will allow users to do before clicking on "OK".
Step 3: Re-enter the password to confirm the sheet protection and then click "OK" to complete the process.
Once this is done, anyone who wants to make changes to the worksheet will have to enter the password.
Part 2. How to Remove Password from Excel with Known Password
So you've added a password to the Excel file but now you would like to remove it. If you know what the password is, removing it will be very simple; Follow these simple steps;
Step 1: Open the encrypted Excel file. Tick the ‘File' option and select "Info > Permissions".
Step 2: Click on the "Encrypt with Password" option and then clear the password box.
Step 3: Click "OK" to delete the password and the click "Save" to complete the process.
The next time you open the document, you will not need to enter the password.
Step 1: Open Excel and then go to "File > Info > Protect Document > Restrict Editing.
Step 2: Find "Stop Protection" in the list and click on it to disable read-only feature.
Part 3. How to Remove Password from Excel File without Password
As you can see, it is very easy to remove a password from an Excel document if you know the password. The main problem comes in when you don't know the password. In this case, the best way to remove password from the Excel document would be to use Passper for Excel. This Excel password recovery tool has all the necessary features to help you recover or remove a password from any document. To use Passper for Excel to remove password protection from Excel, install the program onto your computer and then follow these simple steps;
Step 1: Launch Passper for Excel on your computer and select "Recover Passwords" on the main Window.
Step 2. Now, click on the "Add" button to find the password-protected excel file and open it in this program.
Then you should see various forms of attack modes you can use with Passper for Excel. Each attack mode is explained to help you determine which one is best for you. Select the most appropriate one for your particular needs and then click on "Recover".
Step 3: After tapping on the Recover button, the software will immediately begin recovering the password for the file. The recovery time depends on the attack mode you choose. When it is completed, the password will be displayed on your screen.
You can then use the recovered password to open the Excel Document.
If the Excel spreadsheet has editing restrictions, Passper for Excel can also be very helpful in allowing you to overcome these restrictions and be able to edit the worksheet in one click. Here's how to do it;
Step 1: Open Passper for Excel on your computer and then click on "Remove Restrictions". Click on "Add" to import the restricted Excel spreadsheet into the program.
Step 2: Once the file is open in the program, click on "Remove" to lift the editing restrictions from the Excel sheet.
The restrictive password will be removed from the document in a few seconds, thereby rendering the document editable.
Part 4. About Password Set Rules
A password can only be helpful to you if it is both strong enough to keep the document safe and easy enough for you to remember. It is also a good idea to never have the same password for all your services as this makes it easier for others to guess what your password could be. In an effort to help you create the most reliable password, we've outlined the common rules for password protection. Follow these 2 rules to ensure that you have set a great password. They include the following;
4.1 Minimum Length Requirement
The minimum length requirement for most passwords is 6 characters. This should be your starting point for your own password. You can certainly have more than 6 characters but ensure that the password s short enough to remember.
4.2 Minimum Complexity Requirement
Even as the password must meet the minimum length requirement, it also must meet some of the complexity requirements set out by Excel. It must have at least three of the following; upper case characters, lower case characters, numerals and special characters.
Now that you know how to add a password to an Excel document, restrict editing in an Excel worksheet and how to remove password from excel even if you don't have the password, you are ready to begin creating some of those sensitive documents. Keep in mind that a password is meant to keep someone else out. So, set a password that is easy to remember or write it down somewhere as losing it may mean you lose access to the document.