How to Add or Remove Password from Excel

Microsoft Excel is an industry-leading spreadsheet program which can help you achieve data visualization and perform data analysis easily. For better management and analysis, users always save data as an Excel file, which is also a common operation in workplace.

To protect your Excel file which includes personal and confidential data from unauthorized accesses, it is a wise choice to password protect it. Generally speaking, there are 2 types of Excel password: opening password and modifying password which separately aim to restrict the privilege to open and modify the file.

But sometimes, you might forget the password and you can’t open or modify it, or you want to make the Excel file accessible for others again. Then, you need to remove password from Excel.

In the following contents, you will learn about how to add or remove password protection in Excel. Just keep reading to get the details.

How to Fix Microsoft Office Excel Error Stdole32.tlb

The stdole32.tlb is an error that might happen to Microsoft Office Excel. In this article, you will lean about 4 effective method to fix the stdole32.tlb error.

Read More

How to Password Protect an Excel

Microsoft Office provides different options for users to protect Excel data. To add a password protection for your Excel, you need to:

Step 1: Open the target Excel file and click File > Info.

Step 2: Click Protect Workbook in the right pane and choose an option as your needs.

• Encrypt with Password: Open this workbook with a password (opening password).
• Protect Current Sheet: Restrict the modifications for the current sheet.
• Protect Workbook Structure: Prevent unwanted changes to the structure of the workbook like adding sheets.

Step 3: In the pop-up window, enter a password in the empty box and click OK. Then, reenter the password and click OK to confirm it.

Alternatively, you can also use the related features in the upper ribbon bar as the following screenshot shows. You just need to keep your Excel file open, navigate to the Review tab, and click Protect Sheet or Protect Workbook to set a password for the current sheet or workbook.

How to Remove Password from Excel

It is easy to remove an Excel password if you remember it, and commonly you can follow the steps of adding password to remove a password. Here’s how to do that.

Option 1: Remove Password with Info Feature

Step 1: Open the Excel file that you want to remove password from. Of course, you will be required to enter the password to open it if you have set an opening password for the file.

Step 2: Navigate to File > Info.

Step 3: Click Protect Workbook and then choose the type of password protection you’ve set to remove.

• For Encrypt with Password option, you will get an Encrypt Document You just need to remove the contents in the box of Password and click OK to remove password.
• For Protect Current Sheet and Protect Workbook Structure options, you will get an Unprotect Sheet window, and you need to enter the password and click OK to remove the protection.

To remove password from an Excel spreadsheet, you may have other options as below:

• Go to Home tab, click Format in the Cells In the drop-down list, choose Unprotect Sheet.
• Right-click the sheet tab at the bottom of the window and choose Unprotect Sheet from the context menu.

Option 2: Remove Password with the Save As Feature

Step 1: Open the target Excel with password and go to File > Save As.

Step 2: In the pop-up window, click Tools beside the Save button and click General Options from the drop-down menu.

Step 3: In the dialog box, clear the contents in the boxes of Password to open and Password to modify to remove all the password.

Step 4: Click OK button to save changes and then click Save button to save the new file to your desired location.

Microsoft Excel Is Waiting for Another Application Error [Solved]

If you receive the Microsoft Excel is waiting for another application to complete an Ole action error when trying to run Excel, you can refer to this fix guide.

Read More