Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Steps To Password Protect a Workbook in Excel

Limit Others From Accessing Excel Workbook by Adding Password To Your File.

Encrypt an Excel file with a password so that it requires a password to open it.

1. Open a workbook.

Worked Example:   Creating and Opening an existing file in Excel Workbook

2. On the File tab, click Save As.

3. Click Browse.

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

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

Worked Example:   How to reference named range different sheet in Excel

6. Reenter the password and click OK.

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

Worked Example:   Make Workbook Read-only in Excel

7. Enter a file name and click Save.

It requires a password to open this Excel file now. The password for the downloadable Excel file is “easy”.

Leave a Reply

Your email address will not be published. Required fields are marked *