Sheet Protection Passwords

  • Hi everyone,

    I don't know how I did this, but follow me here:

    - I built a spreadsheet

    - I wanted to protect it

    - I went through the procedure, selecting a password

    - Now I want to change it

    - I go to the "Unprotect Sheet" button and put in my password

    - I get the "Check your Caps Lock" message

    - Nope - it's not caps lock

    - It appears that I mistyped my password -- TWICE? - while protecting the sheet

    Now I can't change it.


  • To Change or remove workbook passwords

    • Open the workbook that you want to change or remove the password for.
    • On the Review tab, click Protect Sheet or Protect Workbook.
    • Click Unprotect Sheet or Protect Workbook and enter the password.
    • Clicking Unprotect Sheet automatically removes the password from the sheet.
    • To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and then click OK.
    • To remove a password from the workbook, click Protect Workbook, and then click OK without entering a new password.

    Hope this information was helpful

  • Excel lets you password protect your workbooks and your worksheets. But, it’s easy to forget or misplace your passwords. Unfortunately, if that’s happened to you, we don’t have a way to help you recover a lost password.

    Excel doesn’t store passwords where you or Microsoft can look them up. That’s also true for the other Office programs that let you protect files. That’s why it’s always a good idea to store your passwords someplace safe.

    Some third-party companies offer programs for unlocking files. But they cannot be trusted at all & posses a high risk.



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!