info

Current Computing Status:

Service Info

The Information Security Officer, Randy Marchany, posted the following information in a special news email: From: Randy Marchany, University Information Technology Security Officer, Virginia Tech IT Security Office "A... view Status History All Active Statuses

Locking and Protecting Cells in Excel

Question:
How do I lock and protect certain cells in Excel?
Answer:

You must first lock all the cells you want to prevent from being changed and then turn on protection.

  1. To lock a cell:
    1. Select the cell(s) you want to lock or unlock.
    2. Right-click the cell(s) you selected.
    3. From the drop-down list, select Format Cells....
    4. Select the Protection tab.
    5. To lock the cell, place a check in the Locked check box.
    6. Click OK.
  2. To protect cells:
    1. Select the Review tab.
    2. In the Changes group, click the Protect Sheet button.
    3. Place a check in the Protect worksheet and contents of locked cells check box.
    4. In the Password to unprotect sheet: text box, type your password.
    5. Click OK.
    6. In the Reenter password to proceed. text box, type your password again.
    7. Click OK.
Fri, 08/02/2013 - 3:38pm 22812 Views Article ID: 1913