It can unlock your Excel password without affecting the data in the file. Passper for Excel Password Unlocker is one of the easiest and most effective tool when it comes to unlocking forgotten Excel password. How to open a password protected Excel file if forgot password? If you are in such a situation, then try the 2 methods below.ġ.1 The Best Method: Passper for Excel Password Unlocker Unlock Forgotten Excel Password to Open the File Tip: Is There Any Solutions If You Forgot Excel Password on Mac? Unlock Forgotten Excel Password to Modify the File It's also possible to protect macros in the workbook from being removed or changed.įollow the steps below for your version of Excel to protect a worksheet or individual cells in a worksheet.Situation 1. Data in the protected cells, worksheet, or workbook cannot be added, changed, or removed. Protection can be configured in an Excel spreadsheet for individual cells, a single worksheet, or an entire workbook to prevent modification. Removing a password - To remove the password from a protected document, follow the steps in the previous section, but delete the characters entered in the Password field. Keep in mind, however, that a user could open the file then copy its contents another document. Password to modify - Similar to read-only, this option allows the file to be viewed, but only users with the password may edit and save the file. Password to open - Entering a password for this option makes the file only readable by users who know the password. Type the password again in the Reenter Password text field and click OK.

Once you have selected a password, type it in the Password text field, then click OK.In the drop-down menu that appears, move your mouse cursor over Prepare and click Encrypt Document.In the top-left corner of the screen, click the Microsoft Office Button.Open Microsoft Word or Excel and the document or spreadsheet you want to password protect.Save the file to save the new password.Type a password again in the Reenter password text field and click OK.Type a password in the Password text field and click OK.Click Encrypt with Password to require a password to open the document or Restrict Editing to limit or block other users from making edits to the document.Open Microsoft Word or Excel and the document or spreadsheet you want password protect.Should you choose to do so, it is best not to store the unprotected file locally, but rather on a USB stick.

It should be noted that it's generally a good idea to create a backup copy of your file without a password in case you forget it. The following steps give users of Microsoft Word and Excel instructions on password protecting each page of their documents.

How to make password protected excel