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 create password for excel file