Home > Resources > Office Password > Encrypt Excel File

How to Encrypt Excel File with Password Protection

How to prevent excel file from unwilling opening or editing?

Encrypting your excel file with password would make it done. Here the article will tell you how to do it in two parts.

  1. Part 1: Encrypt Excel Worksheet and Workbook structure
  2. Part 2: Put open and modify password on Excel file

Part 1: Encrypt Excel Worksheet and Workbook structure

In this part, you would know how to protect excel workbook and worksheet separately with encryption. Excel workbook password could protect workbook from being changed structure, Windows, or removed/added/deleted worksheet. And excel worksheet password could prevent users from inserting, deleting rows or columns in worksheet, or formatting cells.

In Excel 2003:

Click Tools on menu and select Protection > Protect Workbook, then enter a password in pop-up dialog. You would encrypt Excel workbook. If you want to encrypt Excel worksheet, just select "Protect Worksheet" instead of "Protect Workbook", and set a password.

In Excel 2007/2010:

1. Encrypt Workbook:

Click Review on Excel menu and select Protect Workbook in Changes group. Then check Structure and Windows in dialog Protect Structure and Windows. At last, set a password to encrypt Excel workbook structure and Windows. And reenter password to make sure.

enter password to protect workbook structure and window

confirm excel workbook encryption

2. Encrypt Worksheet:

Select the worksheet you want to encrypt in Excel Workbook. Click Review menu and select Protect Worksheet in Changes group. Then enter a password under "Password to unprotect sheet" in "Protect Sheet" dialog. And reenter password to confirm excel worksheet encryption.

encrypt excel worksheet for protection

Now you can see you have successfully encrypted Excel workbook and worksheet for protection.

protect excel workbook and worksheet successfully

Tips: If you want to remove above protection one day no matter you have forgotten or not, iSunshare Workbook Unprotect Genius could help you as long as your excel file is not protected with open password.

Part 2: Put open and modify password on Excel file

Besides encrypting spreadsheet separately, you could also set password to make entire excel file not be opened or edited. Just while you save as the excel file, you can easily put open and modify password to encrypt excel file.

choose to save as excel file for password protection

1. On Save as dialog, click "Tools > General Options" next to "Save" button.

select general options in tools

2. In General Options dialog, you can enter password in field of "Password to open" and "Password to modify". Then click OK.

put open and modify password on excel file

3. Reenter open password in next pop-up dialog and press Enter.

confirm excel file open password

4. Reenter modify password in following dialog box and click OK.

confirm excel file modify password

5. Click Save button on Save as dialog at last after you make sure excel file name and "Save as type".

save as excel file

From then on, when you want to open and edit the excel file, you would need to enter both open and edit password.

enter password to open excel file

enter excel file modify password for write access

Related Articles:

Hot Categories
Windows Password
iTunes Password
Office Password
More +
Hot Articles
Locked Out of Office Files - How to Open
3 Ways to Remove Word Password
Forgot Excel Workbook 2010/2013/2016 Password | How to Do
How to Unlock Password Protected PowerPoint Presentation
How to Remove Forgotten Password from Access Database
More +
Latest Articles
How to Unprotect Excel Workbook without Password
How to Recover Outlook 2016 PST File Forgotten Password
Office 2016 Password Recovery after Forgot or Lost
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +