How to Set Password to Protect Excel Workbook and Specific Cells

In some occasional situations, you may want to set password to protect the Excel workbook and prevent other people from copying, changing or editing cell data. For example, you just create an Excel workbook and do not want others open it, you may need to set an open password; or only want others open the Excel but not change data in the Excel, you can set password to let the Excel Workbook to be read-only; or you just want to protect specific cells.

Protect specific Cells

Step1, select the cells you want to protect > right click and choose Format Cells.

Step2, Click the Protection in the Custom Lists > check Locked option to protect selected cells. Below the Hidden, you will see a sentence: Locking cells or hiding formulas has no effect until you protect the worksheet. So we go to step3 to set password to protect the worksheet.

 

 

 

 

 

 

Step3, click Review tab > go to Protect Sheet > type password to protect the sheet.

 

 

 

 

 

 

 

 

 

 

Secure Excel Workbook

First method: From the above image, we will find the Protect Workbook is just next to Protect Sheet, click it > go to Protect Structure and Windows or Restricted Access, which needs a Windows Live ID to register this service. Or use other ways to set password to protect Excel Workbook as below.

 

 

 

 

 

 

Second method: Click Office button > go to Save As > on the Tools menu, click General Options.

  • If you want users to enter a password before they can view the workbook, type a password in thePassword to open box, and then click OK.
  • If you want users to enter a password before they can save changes to the workbook, type a password in the Password to modify box.

 

 

 

 

 

Third method: Just as to set password to protect Word documents, you can also use that way to set password to protect Excel workbook:

Step1, click Microsoft Office button, point to Prepare, then click Encrypt Document.

 

 

 

 

 

 

 

 

 

 

 

Step2, in the Password box, type a password, and then click OK.

Step3, in the Reenter password box, type the password again, and then click OK.

Step4, to save the password, save the file.

You can set password to protect your Excel workbook or specific cells with any way above. And if you have other ideas on protecting Excel spreadsheets, please leave your advice in the comments.

This entry was posted in Tutorial, useful info and tagged , , , . Bookmark the permalink.

Comments are closed.