3 Ways to Remove Password From Excel File
Addingpassword protection to your Excel filehelps keep your data secure from unauthorized users. However, there are times when you might want to remove it for easier collaboration, simplified file-sharing processes, updating a password, or encountering compatibility issues with other spreadsheet software. So here are 3 different ways to remove passwords from Excel files.
Table of Contents
Risks of Removing Password From Excel File
Prior to removing the password from the Excel file, it’s important to be mindful of the following risks:
1. Remove Password From File Settings
One of the easiest ways to remove a password from the Excel file is from File Settings. Here’s the complete process:
For Windows Users:
1.Open theExcel filefrom which you want to remove password protection.
2.Now enter thepasswordand hitOK.
3.Once the workbook is opened, click on theFiletab.
4.After that, navigate to theInfosection, click onProtect Workbook, and select theEncrypt with Passwordoption.
5.Now, clear the existing password and leave thePassword field blank, then click theOKbutton.
Voila, you have successfully removed the password from an Excel file.
Tip:Learn how toadd currency symbols in Excel.
For Mac Users:
1.Open theExcel fileon your Mac and enter thepassword.
2.Now click on theFiletab and select thePasswordsoption from the menu.
3.Remove theexisting passwordand hitOK.
4.Savethe file, and the next time you open it, the password prompt will no longer appear.
2. Remove Password Using Save As Option
Another way to remove the password from an Excel file is during the process of saving the file. Let me explain how this works:
1.Open theExcel Fileand enter thepasswordwhen prompted.
2.Next, go to theFiletab.
3.From there, move to theSave Assection and select theBrowseoption.
4.On the next window, choose thelocationwhere you want to save the Excel file, and then click on theToolsbutton to selectGeneral Optionsfrom the drop-down menu.
5.Nowclear the existing passwordfrom the “Password to open” field and clickOK.
6.Finally, hit theSavebutton and the password will be removed from your Excel file.
Tip:Learn how towrap text in Excel Worksheet
3. Remove Password From Worksheet
While attempting to edit the workbook, if you encounter the message“The cell or chart you’re trying to change is on a protected sheet…,”it indicates that the worksheet is password protected. To modify the content of the cell, you must either enter the password or deactivate the password protection.
To remove a password from the Excel worksheet, simply go to theReviewtab and click on theUnprotect Sheeticon.
After that,enter the current passwordand hitOK.
That’s it! It will no longer prompt you for a password when you want to edit the content within the worksheet.
Tip:You can also find theUnprotect Sheetoption within theFormatmenu under theHometab.
- What to do if I forget the worksheet password?
In case you forgot the worksheet password, you can simply copy and paste the data or content of the worksheet to another worksheet. This way, even if the worksheet is password-protected, you can still access and edit it on another worksheet. However, sometimes, that may not work.
- What if I forgot the password of the Excel file?
Officially, there is no way to recover the password. However, there are many password recovery tools out there that you can try to recover your password.
- Can I remove a password using Excel Online or the mobile app?
No, you cannot remove a password using Excel Online or the mobile app. The ability to remove passwords is only available in the desktop version of Excel.
- Will removing the password affect the data or formatting of my Excel file?
No, it won’t affect any of your data or formatting. However, a lack of password protection may allow unauthorized individuals to modify or manipulate the data within the file.
- Are there any third-party tools to help remove Excel file passwords?
On the internet, you will find many such tools that promise to help you remove the password from Excel files. However, we cannot guarantee the security of your file’s data, so proceed with caution.
Break Free from Excel Passwords
Password protection is an effective method for maintaining the security of your sensitive data within an Excel file. However, having to enter a password every time to access an Excel file can be inconvenient. Similarly, the need to alter the password while sharing the file with another person can also be cumbersome. We hope that this guide will assist you in removing the password from the Excel file.
Before you leave, you can also learn how toconvert pictures to Excel tables.
Rahul is your go-to guide for fixing Windows, Steam, Android, Samsung TV, and Google Chrome. An engineering college dropout who followed his passion for tech, he brings 3 years of troubleshooting experience and 2+ years of running his own tech blog to the table. When he’s not solving your tech problems, you’ll find him unwinding with the latest anime or K-drama.
