How to Remove Encryption from Excel (with Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

While working with important information in Excel, you might need to encrypt your worksheet or protect it with a password. Sometimes you need to protect the file with a password or encryption because you do not want someone you share it with to change the contents or modify the file. In such a case, we have to encrypt our Excel file to restrict access to the contents. But after the encryption has served its purpose, we do not need the encryption or password in our Excel file anymore. In this article, I will show you how to remove encryption from Excel files.


How to Remove Encryption from Excel: Step-by-Step Procedures

Let’s assume a scenario where we have an Excel file that we encrypted to restrict its access. But now we do not need the encryption anymore and need to remove the encryption or password. We will follow the 2 methods below to remove encryption from the Excel file. The image below shows the encrypted Excel file with a dialogue box titled password that will prompt for the password when someone tries to open it.

How to Remove Encryption from Excel


Step 1: 

  • Removing the encryption or password from an Excel file is very easy. But we have to know the password to remove encryption from the Excel file. So, we will open the file and enter the password in the window like the above one.
  • We will then click OK.

. Use Password to Remove the Encryption of the Excel File

Step 2:

  • Now we will click on the File.

Click on the File

  • A new window will appear. We will then select the Info option from there.

Select the Info Option

Step 3:

  • After we have selected Info, we will see a Protect Workbook drop-down menu in a yellow color-filled box. The box has a text inside: A password is required to open this workbook.

Protect Workbook Drop-down Menu

  • We will click on the Protect Workbook drop-down menu. A list with multiple options will appear. We will click on the Encrypt with Password.

Click on the Protect Workbook Drop-down Menu

Step 4:

  • A new window titled Encrypt Document will appear that has an input box with the current password of the document in encrypted form.

Window Titled Encrypt Document

  • We will delete the entire password by pressing the BACKSPACE.
  • Next, we will click on OK.

Remove Encryption from Excel

  • We will now see that the Protect Workbook drop-down does not have the yellow color-filled box and the text A password is required to open this workbook. That means the encryption or the password is removed from the Excel file.

Protect Workbook Drop-down Does not have the Yellow Color-filled Box

  • If we try to open the Excel file again, we will see that it is not asking for the password anymore.

Read More: How to Decrypt Excel File Without Password


How to Unprotect Sheet in Excel

Sometimes you can protect a worksheet or even the entire workbook from the Review tab. If we try to modify or edit a worksheet or workbook that is protected in this way, it will show a warning message like the below one.

Apply the Unprotect Sheet Option to Remove the Encryption from Excel Worksheet

Step 1:

  • If we want to remove the encryption or password from a protected worksheet or workbook, we will first have to go to the Review tab and click on Unprotect Sheet under the Protect section.

Go to the Review Tab and Click on Unprotect Sheet under the Protect Section

  • A window will appear tilted Unprotect Sheet that will ask for the password. We will enter the password in the input box.
  • We will then click OK.

How to Remove Encryption from Excel

Step 2:

  • Now, if we go back to the Review tab, we will see that it is showing Protect Sheet instead of Unprotect Sheet. That means the worksheet does not have any password.

Protect Sheet instead of Unprotect Sheet

Read More: How to Create Encryption Function in Excel


Things to Remember

  • Once you remove the encryption from the Excel file, it will not be protected anymore.
  • You should select a password that is easy for you to remember but very hard for anyone to guess.

Download Practice Workbook

Download this practice book to exercise the task while you are reading this article.

Note: The password for this encrypted Excel file is exceldemy.

Conclusion

In this article, we have learned how to remove encryption from Excel in different ways. I hope from now on you can remove the encryption from Excel easily. However, if you have any queries or recommendations about this article, please leave a comment below. Have a great day!!!


Related Articles


<< Go Back to Encryption in Excel | Excel Protect | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
ASM Arman
ASM Arman

Abu Saleh Arman is a Marine engineer and Excel & VBA expert. He loves programming with VBA. He finds VBA programming a time-saving tool to manipulate data, handle files, and interact with the internet. He is very interested in Python, MATLAB, PHP, Deep Neural Networks, and Machine Learning, showcasing his diverse skill set. Arman holds a B.Sc in Naval Architecture & Marine Engineering from BUET, Bangladesh. However, he switched to a content developer, where he writes technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo