How to Remove Passwords from Excel Files

If you need to share an encrypted Excel spreadsheet or frequently access one without the hassle of entering a password, you can easily remove the password protection. Here’s how to do it on both PC and Mac devices:

Instructions for PC:

1. Open the encrypted Excel spreadsheet and enter the password when prompted.
2. Navigate to the “File” tab in the toolbar at the upper left corner of your screen.
3. Choose “Info” from the drop-down menu.
4. Click on “Protect Workbook” and then select “Encrypt with Password.”
5. Clear the password from the pop-up window, leaving the text box blank.
6. Click “OK” to confirm and remove the password from the Excel spreadsheet.

Instructions for Mac:

1. Open the encrypted Excel spreadsheet and input the password.
2. Head to the “File” tab in the toolbar.
3. Select “Passwords” from the options.
4. Delete both passwords from the pop-up window, ensuring the text boxes are empty.
5. Click “OK” to finalize and remove the passwords from your Excel file.

By following these steps, you can efficiently remove password protection from your Excel spreadsheet, making it easier to collaborate or work seamlessly.

How to add password for your excel files

To enhance the security of your Excel spreadsheets, you can add a password. Here’s how you can do it on both PC and Mac devices:

Instructions for PC:

1. Open the spreadsheet in Excel that you want to protect with a password.
2. Click on the “File” tab located in the upper left corner of your screen.
3. Choose “Info” from the drop-down menu.
4. Select “Protect Workbook” from the options.
5. Click on “Encrypt with Password” in the menu.
6. Enter your desired password into the text box and click “OK.”
7. Confirm the password by typing it again and click “OK” to set it.

Instructions for Mac:

1. Open the Excel spreadsheet you want to secure.
2. Click on the “File” tab in the upper left corner of your screen.
3. Choose “Passwords” from the options available.
4. In the pop-up window, enter the password for opening the file.
5. Enter another password for editing the file, if desired.
6. Confirm both passwords by entering them again.
7. Click “OK” to apply the passwords.

Ensure you choose a password that’s memorable yet secure. Losing the password can be troublesome as there’s no straightforward recovery method. Consider keeping it in a safe place for future reference.