info

Current Computing Status:

Service Info

On July 16 2014, HOKIES account credentials, used to login to computers in the university Windows domain and Exchange email accounts, will no longer be used to authenticate to network services, specifically wireless and... 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 46916 Views Article ID: 1913