How To Remove Password From Excel

By Author: waredot
Total Articles: 25
Comment this article

Add or Remove password from excel in few clicks

Are you struggling with your excel password again and again? Then, remove the password from the excel file.  Removing password from the excel file is as easy as you set up password. Still, make sure when you remove the password from the excel file then anyone can see, copy, can do lot more things with your excel file. Basically, your excel data will come in danger. 

This article will tell you all the required things for the excel sheet password, including how to add password in excel.

How to Add Password to Excel-Windows 
Here’s how to add password to your excel worksheet on Windows.

1. First of all, open the Excel spreadsheet you want to password protected and then click on the “File” tab close to the Home button at the top. 

2. Clicking on the “File” tab will appear the option for you. Select “Info” from there. Doing so will appear the dialog box on the screen. 

3. Now, click on the box labeled “Protect Workbook” to open a drop-down menu. Then, click on the “Encrypt with password” on the drop-down menu.

4. ...
... On the dialog box that appears, you can enter the password that you want to use and click Ok. Again enter the password in the “reenter password” section to confirm your password and click Ok again.

5. Now, if anyone needs to open your password-protected excel file, they need to enter the password. They can enter the password two times only, if the person entered the wrong password two times, then the excel file won’t open and you will not get a third chance to try the password again.

How to Add Password to Excel-Mac
Here’s how to add password to your excel worksheet on mac.

1. First of all, open the Excel spreadsheet you want to password protected and then click on the “File” tab in the menu bar at the top of the screen.

2. Now, click “Password.” You’ll be asked to set a password for opening the file, and another password for editing it. You can set the password for either.

3. Once you click “Ok,” you’ll be asked to re-enter your password to confirm your password. Once you done, click Ok. Make sure the password you choose to protect your excel file is something that no one can easily guess and also ensure you can remember it as well, or you can write it down in a safe place- there’s no password recovery option if you forget it.

4. Your excel file has been password protected now. You will be required to type in your password whenever you want to open this particular excel spreadsheet.

How to Remove Password from Excel File on Windows  
If you want to unprotect or remove password from your excel file, here’s how to do it.

1. First of all, open your encrypted Excel spreadsheet, and type in the password, and click Ok.

2. Now, click on the “File” tab, and then click on “Info.”

3. Click on the box labeled “Protect Workbook” to open a drop-down menu. Then, click on “Encrypt with password” on the drop-down menu.

4. Finally, delete the password that appears, so that the field is blank and click Ok. You’re done now.

How to Remove Password from Excel File on Mac
If you want to unprotect or remove password from your excel file, here’s how to do it.

1. First of all, open your encrypted Excel file on your mac. 

2. Click on the “File” in your menu bar at the top of the screen. 

3. Now, click on “Password.” You’ll be presented with the same menu that you chose your password in. Clear box text fields, and click Ok.

4. Your Excel spreadsheet should no longer be password protected.

Read More Click here: how to remove passwords from excel

Waredot is there to make your life easy through technology. We are here to help you out with the best solution for your needs and problems. Waredot make things done with simple clicks. https://waredot.com/rescuedata/