Password Protecting Ranges in a Worksheet - Exercise

Contact Us or call 1-877-932-8228
Password Protecting Ranges in a Worksheet - Exercise

Password Protecting Ranges in a Worksheet

Duration: 10 to 15 minutes.

In this exercise, you will unlock cells in a worksheet before protecting it, thus allowing users to edit much of the worksheet, but protecting the formulas and structure of the worksheet.

  1. Open Protecting Ranges in a Worksheet.xlsx from your Excel2013.3/Exercises folder.
  2. Protect the worksheet so that users can edit cells D2:D5 (Periods), but cannot edit anything else.


  1. Select cells D2:D5.
  2. On the HOME tab, in the Cells group, click the Format command:Format Command
  3. Click Lock Cell to unlock the cells:Lock Cell Command
  4. On the REVIEW tab, in the Changes group, click the Protect Sheet command:Protect Sheet Command
  5. In the Allow all users of this worksheet to list, verify that Select locked cells and Select unlocked cells are both checked and click OK:Verify Locked Cells
  6. In the Confirm Password dialog box, reenter the password and click OK:Confirm Password Dialog Box