How To Remove Excel 2010 Password Protection, How To Remove Encryption From Excel

Internet has changed world into global village. Nothing is save until its protected by password or key.Password protection methods are used in workplaces where data storage and analysis are done Microsoft Excel 2010 to protect their substantial records. They don”t want any unauthorized person to access or modify it. Here comes a situation when you somehow loose password or forget password. Now even you can”t remove password from Excel 2010 and can”t access that file. Excel document password protection is weak. Another possibility for removing password from Excel 2010 file is that they might want to share their work with their member and might not want to share the password. Here are some solutions for removing known and forgotten password from Excel 2010.

Đang xem: How to remove excel 2010 password protection

Option 1: Remove Known Excel 2010 Password

There are different types of password protection available for Excel 2010. They are:

1. Open Password/Workbook Password

A document”s open password is a password used to restrict the opening of the document. It pop-up as the document is opened. If your work has completed and now you want to deliver it to your boss, this is the time where you don”t need the protection. Here is the easiest way to unprotect Excel file but you need to know the old password as well. if you know that simply follow the steps below:

Step 1. Get full access of the document by opening it and entering the password.

Step 2. Now for removing password navigate to File > Info >Protect Document > Encrypt with Password. A new dialogue box will appear before you with your old encrypted password.


Step 3. Leave the textbox empty in-order to remove password and click “OK”.


Now your file is decrypted successfully. You can deliver your file password free.

2. Modify Password

Modify password is the password required in order to modify the document. If you want to get some changes in the document you will be needing this password. This password is other than open password. If you don”t know modify the password, you can still view the document in read-only mode only if the author has enabled that. This is also known as “Edit Restriction Password”. In order to remove password from Excel files, follow the following steps:

Step 1. Open the Excel document and navigate to File > Info > Protect Document > Restrict Editing.


Step 2. There you will see Stop Protection button at the bottom of Restrict Editing pane. Select that and your restriction will be off.

3. Workbook Structure Password

If you want to prevent other users from adding, moving, deleting, hiding and renaming worksheets, you can protect the structure of your Excel workbook with a password. This password only protects the structure not the content of a worksheet. In order to remove workbook structure password, you will need to proceed step by step:

Step 1. Open the encrypted document in Excel 2010.

Step 2. In order to unprotect Workbook Structure, navigate to File > Info > Protect Document > Protect Workbook Structure.


Step 3. Input password in the dialogue box appearing and save the document.

Xem thêm: Công Thức Và Cách Tính Diện Tích Dây Điện Dân Dụng??? Hướng Dẫn Tính Diện Tích Dây Dẫn


Your workbook Structure protection will be off and now you can re-encrypt the structure also.

4. Worksheet Password

Worksheet password prevents the user from changing, moving, or deleting data in a worksheet. With worksheet protection, you can make only certain parts of the sheet editable and users will not be able to modify data in any other region in the sheet. If got this password enabled and want to get rid of it, its very simple. Follow the procedure below and your protection will be off.

Step 1. Open the encrypted Excel document with Excel 2010. Go to “Review” tab from Menu bar.


Step 2. From “Review” Tab select “Unprotect Sheet” option. After Protecting the sheet, “Protect Sheet” option is changed into “Unprotect Sheet”.


Step 3. Input password in the New window that will appear with password box. Click “OK”. This will remove Sheet protection from your Excel file.


5. Read-Only Mode

If you don”t want viewers to accidentally modify your document, you can make the document read-only. A read-only file can be read but not modified. Your file is always opened in read-only mode, of you want to get rid of read-only mode follow the procedure below.

Step 1. Open the Excel document. It will open in read-only mode or it will ask you to open in read-only mode.

Step 2. Now navigate to File > Info > Protect Document > Always Open read-only mode. Select this option and read-only restrictions will be disabled from your document.


Option 2. Remove Forgotten Excel 2010 Password

Now here is the solution for the possibility that when you lose your password to Excel file what to do? If you lost or forgot your password you don”t have to worry. Use for Excel, a fast and easy solution to recover lost or forgotten passwords for Microsoft Excel file. It supports for Excel workbook created in MS Excel 97-2016. There are 3 powerful attack types wrapped in Excel password recovery:

1. Brute Force Attack

It attempts all possible combinations of passwords until the correct password is found. The password recovery engine is highly optimized, thus short password can be recovered immediately.

2. Brute Force with Mask Attack

If you remember the password partially, you can set a mask with the mask symbols for those parts you can”t remember, it will help you effectively shorten the recovery time compared with brute-force attack.

Xem thêm: Chuyên Đề: Phương Trình Trùng Phương 10 Nâng Cao, Phương Trình Trùng Phương Lớp 10

3. Dictionary Attack:

Since many people use regular words or phrases for password, perform a dictionary attack by trying each word from the dictionary will save your precious time.

There are no technical skills required to use it. Here is the guide to use for Excel:

Xem thêm bài viết thuộc chuyên mục: Excel