Restricting changes to parts of a worksheet

  1. Open the YearlyProductSales.xlsx document, in order to restrict parts of the worksheet. This tool is very useful when you do not want users to have editing rights to delete or change the formula you have constructed in certain parts of the workbook. The user can view the result of the formula but cannot edit it.
Please note that before you can prevent users from editing locked cells on a worksheet range, you need to specify which worksheet cells you do not want users to edit.
  1. Click on the Review tab.
  2. Choose Allow Users to Edit Ranges from the Protect group.
  3. Select the range to protect from editing—in this example, G2:O145.
  4. Note that the Permissions... icon is available, should you wish to specify specific users who are allowed to edit a range without a password. Click on Apply at the bottom of the dialog box.

Refer to the following screenshot to view the preceding information:

  1. Click on the Protect Sheet... icon at the bottom of the dialog box, then enter a password, and enter it again to confirm.
  2. Click on OK to commit to the changes.
  3. If a user tries to delete or edit contents in a protected range, they will be greeted with the following error:
  1. To remove protection from the worksheet, click on the Unprotect Worksheet icon on the Protect group, then enter the password to unprotect the worksheet. Save the workbook.