info

Current Computing Status:

Service Info

The new “Remote Access – VPN” service (aka Junos Pulse) went into production on Tuesday, July 29th, 2014. The legacy “PPTP Virginia Tech VPN” service will be decommissioned on August 12, 2014. The new VPN service works... 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 49009 Views Article ID: 1913