How to Add or Remove Passwords From Microsoft Excel Form

Do you feel like your Microsoft Excel spreadsheet needs more protection? If so you can encrypt your spreadsheet by setting up a password. It's pretty easy and quick and if you decide you don't need a password anymore you can just as easily remove the password. If you're interested keep reading.

How to set a password to encrypt an Excel spreadsheet on PC

  1. Open your Excel spreadsheet.
  2. Press the "File" tab, then click on "Info."
  3. Press the box named "Protect Workbook" to open a drop-down menu.
  4. Next, select "Encrypt with password" from the drop-down menu.
  5. Enter the password that you would like to use and press "OK."
  6. Re-enter the password to confirm it and click "OK" again.

How to set a password to encrypt an Excel spreadsheet on a Mac computer

  1. Press "File" in the menu bar at the top of the screen of your Excel spreadsheet.
  2. Select "Passwords..."
  3. You will be prompted to set a password for opening the file and set another password for editing it. You can choose to do one or both of these. It's your choice, but doing both is obviously safer.
  4. Press "OK," and you'll be asked to re-enter the passwords that you typed.
  5. Press "OK" again to confirm.

Now you will be forced to enter your password whenever you want to open this specific Excel spreadsheet.

How to remove a password from an Excel spreadsheet on a PC

  1. Open your password-locked Excel spreadsheet.
  2. Enter the password, and press "OK."
  3. Press on the "File" tab, then select "Info."
  4. Press on "Protect Workbook" to open the drop-down menu.
  5. Select "Encrypt with password" from the drop-down menu.
  6. Delete the password, so that the field is blank.
  7. Click "OK."

How to remove a password from an Excel spreadsheet on a Mac

  1. Open your encrypted Excel file with the password you set up.
  2. Select "File" in your menu bar at the top of the screen.
  3. Click on "Passwords..."
  4. You will find yourself in the same menu that you set up your passwords from. Clear both text fields, and click "OK."
May 22, 2020