Excel is a well-known and popular software application that is used by a variety of businesses to create spreadsheets and collate data. It enables users to safeguard their work by requiring a password, making it more secure. If you’re making spreadsheets in Excel, you may be interested in how to remove password from Excel file.
Why Remove Password from Excel?
Excel allows users to protect files with passwords to:
- Prevent unauthorized access
- Restrict editing
- Protect sensitive data
However, removing the password can help when:
- You no longer need protection
- You want to edit or share the file freely
- You remember the password and want to disable it
Also read: How to Recover Unsaved Excel File: 5 Best Methods to Get Your File
How to Remove Password from Excel: 6 Methods to Try
1: Remove Password Using Review Tab
This method helps you remove Excel sheet protection when you know the password.
Steps:
- Open the password-protected Excel file
- Enter the password and click OK
- Go to the Review tab
- Click on Unprotect Sheet
- Enter the password again if prompted
✔️ The worksheet will be unlocked.
Remove Password Completely (Optional)
- Go to the Review tab
- Click Protect Sheet
- Leave the password field empty
- Click OK
- Save the file
✔️ This removes the password from the sheet.
2: Remove Password from Excel on Mac
Mac users can remove passwords easily using the built-in option.
Steps:
- Open the Excel file
- Enter the password and click OK
- Click File > Passwords
- Remove passwords from both fields
- Click OK
- Go to File > Save
✔️ Password is removed successfully.
3: Remove Password Using Info Panel (Windows)
Windows users can remove passwords easily using the built-in option.
Steps:
- Open the Excel file
- Enter the password
- Click File > Info
- Select Protect Workbook
- Click Encrypt with Password
- Delete the password
- Click OK
- Save the file
✔️ Password will be removed.
4: Remove Restrictions in Excel 2010
Password protections, such as changing passwords and workbook passwords, could prevent you unlock excel file for editing worksheets or workbooks. When you open the Excel 2010 file and remove security features to protect passwords, to save time for searching and testing, we suggest an application that can remove any formatting or editing limitations in Excel 2010 in just one click. Passport for Excel was the name we discussed in the previous section. We recommend this tool since it ensure an 100% removal rate.
Steps:
- Open a trusted Excel password remover tool
- Select Remove Restrictions mode
- Click Select File and upload your Excel file
- Click Remove to start the process
✔️ Editing restrictions will be removed.
⚠️ Works mainly for editing restrictions, not strong passwords.
Also read: 10 Best File Recovery Software for Mac: Recover Deleted or Lost Files
5: Remove Excel Password Using VBA Code
Unlock Excel file without password, make sure you apply it responsibly, and only to Excel files you own or have permission to edit. Make sure to erase any passwords from the personal Excel spreadsheet. The VBA script works by trying different password combinations to unlock the worksheet.
Steps:
- Open the Excel file
- Press ALT + F11 to open VBA Editor
- Click Insert > Module
- Paste the VBA code
Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
On Error Resume Next
For i = 65 To 66
For j = 65 To 66
For k = 65 To 66
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k)
Next k
Next j
Next i
End Sub
- Press F5 to run the code
- Wait for the process to complete
✔️ The worksheet may be unlocked.
6: Unlock Excel Password Online
While we’re at it, it is important to keep in mind that all files can be decrypted. It’s not a bad idea to assert that online solutions to unlock password protected Excel files are only effective if the password is wrong. Also, it isn’t 100% secure to gain access to the Excel file. It is therefore recommended to choose online solutions only if the Excel file does not contain important data.
If you’ve decided to try the internet route to get access to your Excel password, here are the steps to follow to gain access to Excel passwords online, and for free:
Steps:
- Open an online Excel password remover website
- Upload your Excel file
- Wait for the tool to process the file
- Download the unlocked file or view the password
✔️ You may regain access to the file.
That’s it! Step-by-step directions to remove password from Excel online.
Wrapping Up: Remove Password from Excel Easily
It is always recommended to protect your Excel files with passwords. However, it could become an issue if you do not know the password to the file you need. We’ve covered six of the best methods to help you recover and remove passwords from Excel.
FAQs: Remove Password from Excel
Can I remove password from Excel without knowing it?
You cannot remove strong Excel passwords without knowing them. However, you may try methods like VBA code or online tools for sheet protection, but success is not guaranteed.
How can I remove password from Excel file?
To remove password from Excel, open the file, enter the password, go to File > Info > Protect Workbook > Encrypt with Password, delete the password, and save the file.
How do I remove password from Excel sheet?
Go to the Review tab, click Unprotect Sheet, and enter the password. Once unlocked, save the file without protection.
Which Excel versions support password removal?
Most versions, including Excel 2007, 2010, 2013, 2016, and newer, support password removal if you know the password.
What is the difference between sheet protection and file password?
Sheet protection restricts editing inside the file, while a file password prevents opening the Excel file without entering the correct password.
Leave a comment