How To Protect Microsoft Excel Workbook, Worksheet To Make It Read-only

Protecting an excel workbook/worksheet refers to setting the workbook/worksheet in a protected state to prohibit others from accessing, modifying, or viewing. This article will tell you how to protect an excel workbook/worksheet step by step.

1. How To Protect Excel Workbook.

Users can protect the Excel workbook by the following two methods.

1.1 Protect Excel Workbook From Accessing By Password.

  1. Open an excel file, click File —> Info menu.
  2. Then click Protect Workbook drop-down button on the right side. There are a menu list and each menu can let you do different level excel file protection.
  3. To protect the entire excel workbook, click the Encrypt with Password menu item, it will popup a password input dialog ( the dialog title is Encrypt Document ) to let you input the password. Please remember the password carefully then click the OK button, it will popup a reenter password dialog to make sure the two entered passwords are the same.
  4. Now when you open the password-protected Excel file, it will prompt a dialog to let you enter a password to browse.
  5. If you want to unprotect the entire excel workbook from accessing, you can open the excel file and click File —> Info menu item, then click the Unprotect link at the bottom right corner of the Protect Workbook area.

1.2 Protect Excel Workbook By Structure Or Window.

The above method can protect the entire excel workbook from access. And this method can protect the workbook structure from being modified ( for example, you can not add or delete worksheets in this workbook ).

  1. Open an excel file, click Review —> Protect Workbook icon at excel top toolbar.
  2. Input the password in the prompt Protect Structure and Windows dialog. And there are two checkbox Structure and Windows under the password input textbox.
  3. Check Structure checkbox means that new worksheets are not allowed to be inserted into the workbooks, that is to protect the workbooks from the external structure.
  4. Check Windows checkbox means to protect the workbook’s window interface. After protection, the window cannot be maximized or minimized.
  5. If you want to unprotect the workbook, you just need to click Review —> Protect Workbook again, then it will prompt the Unprotect Workbook dialog, input the correct password then the excel file is unprotected and you can add or remove worksheets.

2. How To Protect Excel Worksheet.

Protecting a worksheet is similar to protecting a workbook. A protected worksheet prevents changes to the specified data in the worksheet.

2.1 Protect Entire Excel Worksheet Steps.

There are two methods to protect a worksheet. The two methods open the same protect worksheet dialog.

  1. Click Home —> Format —> Protect Sheet menu item.
  2. Click Review —> Protect Sheet menu item.
  3. All above actions will popup the Protect Sheet dialog. Input the password in the Password to unprotect sheet: input text box, and check the Protect worksheet and contents of locked cells checkbox.
  4. In the Allow all users of this worksheet to: checkbox list, you can select which user actions will be protected. For example, if you select the Delete columns option, the operation is protected so that users cannot delete the columns of the worksheet.

2.2 Unprotect Excel Worksheet Steps.

If you want to edit a protected excel worksheet, you should first unprotect it follow the below steps.

  1. Click Home —> Format —> Unprotect Sheet menu item.
  2. Or you can click Review —> Unprotect Sheet.
  3. All above actions will prompt a password input dialog to let you input the protected password.

2.3 Protect Excel Cell Ranges.

Sometimes you may want to just protect some cell ranges of one excel worksheet but not the entire worksheet. You can follow the below steps.

  1. Select cell ranges in the excel worksheet. Then click Home —> Format —> Lock Cell menu item to lock the cell range.
  2. Then click the Home —> Format —> Protect Sheet menu item to protect the locked cell range. In the Protect Sheet popup dialog, you can check the Select unlocked cells checkbox. Then you can only edit the locked cells when you edit the excel file because the unlocked cells are protected from editing.

Leave a Comment

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.