Current Computing Status:

Service Info

4Help is using a new ticketing system:   Our new IT service management system-ServiceNow-has been implemented. A new web-based support request form, still accessed via the web address, is... view Status History All Active Statuses

Locking and Protecting Cells in Excel

How do I lock and protect certain cells in Excel?

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 63563 Views Article ID: 1913