Create password for Excel workbook/sheet

To assign a password to an Excel workbook, do the following:

1. From the File menu, choose Save As. In Excel 2007, click the Office button and choose Save As. In 2010, click the File tab and choose Save As.
2. Click the Tools dropdown on the dialog toolbar and choose Save Options. In Excel 2007 and 2010, click the Tools dropdown (in the bottom left corner of the dialog box). In Windows 7, the Tools dropdown will be just to the left of the Save button.
3. In the resulting dialog, you can set two passwords: one to open the workbook and one to modify the workbook. Advanced options let you set encryption options for added security.
4. Enter one or both passwords and click OK.
5. Confirm each password and click OK.
6. Click Save.