Password-Protect Your Workbook

To quickly encrypt your workbook with a password on your Excel workbook:

1. Click File > Info > Protect Document > Encrypt with Password .
   
2. At the prompt enter your password, then confirm it.
   
3. Click on OK after confirming the password.
4. Save and close the workbook.
5. When you reopen the workbook, it will prompt you for the password.

Removing the Password

On some occasions, you may want to remove a password from an Excel file. The process of setting a password encrypts the file, so you’ll need to remove the encryption to remove the password.

To remove the password of an Excel file, follow the steps below:

1. Open the workbook and enter the password in the Password box.
2. Click File > Info > Protect Workbook > Encrypt with Password .
   
3. In the Encrypt Document dialog box, delete the contents of the Password text box.
4. Click OK .
5. Close and reopen the workbook. It will no longer challenge you for a password.