Time to Complete (in minutes): 4
- Question:
- How do I lock and protect certain cells in Excel 2003/2007/2010?
- Answer:
-
You must first lock all the cells you want to prevent from being changed and then turn on protection.
- To lock or unlock a cell:
- Select the cell(s) you want to lock or unlock.
- Right-click the cell(s) you selected.
- From the drop-down list, select Format Cells....
- Select the Protection tab.
- Lock or unlock the cell(s).
- To lock the cell, place a check in the Locked check box.
- To unlock the cell, clear the Locked check box.
- Click OK.
- To protect cells:
- View the protect sheet options.
- In 2003:
- From the Tools drop-down list, select Protection.
- Select Protect Sheet....
- In 2007/2010:
- Select the Review tab.
- In the Changes group, click the Protect Sheet button.
- Place a check in the Protect worksheet and contents of locked cells check box.
- In the Password to unprotect sheet: text box, type your password.
- Click OK.
- In the Reenter password to proceed. text box, type your password again.
- Click OK.