Set a password in an Excel spreadsheet

Set a password in an Excel spreadsheet

To encrypt your workbook and set a password to open it:

1. Click the Microsoft Office Button, point to Prepare, and then click Encrypt Document.

   

2. In the Password box, type a password, and then click OK.

   You can type up to 255 characters. By default, this feature uses AES 128-bit advanced encryption. Encryption is a standard method used to help make your file more secure.

3. In the Reenter password box, type the password again, and then click OK.

4. To save the password, save the file.

1. Use the password to open the spreadsheet.

2. Click the Microsoft Office Button, point to Prepare, and then click Encrypt Document.

3. In the Encrypt Document dialog box, in the Password box, delete the encrypted password, and then click OK.

4. Save the spreadsheet.