Chat with us, powered by LiveChat

Password Protect Excel

How to Add Password Protection in Excel

Password Protect Excel

When a password is added to a workbook, only authorized users with the password can view or modify it.

Add Password Protection

  1. Click the File tab.
    Password Protection
  2. Click Save As.
  3. Click Browse.
    Password Protection
  4. Click Tools.
  5. Select General Options.

    Enter passwords in the password text boxes as desired.

    • Password to open: Enter a password here to require users to enter a password to view the workbook. This password is encrypted, making it more secure.
    • Password to modify: Enter a password here to require users to enter a password to save changes to the workbook. This password is not encrypted.

    You can enter just one or both passwords, depending on the type of protection you want for the workbook. Passwords are case-sensitive.

    Check the Always create backup box to save a copy without a password incase the password is forgotten.

    Password Protection
  6. Click OK.
  7. Reenter the password.

    Type a secure password that can't easily be guessed by other users, and be sure to write down your password in a safe location.

    Password Protection
  8. Click OK.

    The workbook is now password protected. To change or remove a password, repeat the workbook protection steps and simply change or delete the password in the General Options dialog box.

    Password Protection

FREE Quick Reference

Click to Download