Excel Basics – Protect Workbook in Excel



Encrypt an Excel file with a password so that it requires a password to open it. To password protect an Excel file, execute the following steps.

1. Open an Excel file.

2. On the File tab, click Save As.

3. Click Browse.

Click Browse

4. Click on the Tools button and click General Options.

Tools, General Options

5. In the Password to open box, enter a password and click OK.

Enter Password

6. Reenter the password and click OK.

Re-Enter Password

Note: This feature also encrypts your Excel file. If you lose or forget the password, it cannot be recovered.

7. Enter a file name and click Save.

Click Save

It requires a password to open this Excel file now. 

Next Chapter: Count and Sum

Love this article?


Please enter your comment!
Please enter your name here