How to Password Protect Excel Worksheets

1. Go to 'Tools' on the main menu.
2. Select 'Options.'
3. Select the 'Security' tab.
4. Under 'File encryption options for this document,' enter the password in the field called 'Password to open' and click 'OK.'
5. In the Confirm Password window, enter the password in the field called 'Reenter password to open' and click 'OK.' In the Confirm Password window, Excel gives two cautionary notes: first, that a lost or forgotten password cannot be recovered; second, that passwords are case-sensitive. This means that a password such as 'abcd' is not the same as 'Abcd.'
6. Save the password by saving the document. To do this, click the 'Save' icon.
7. If you want to set a password so that only authorized personnel can modify the worksheet, go to 'Tools' on the main menu, select 'Options,' select the 'Security' tab, and under 'File sharing options for this document,' enter the password in the 'Password to modify' field and click 'OK.'
8. Notify authorized personnel of the password required to open and/or modify the worksheet.