Each cell in an Excel 2010 worksheet can either be locked or unlocked, which controls how the cell responds to the basic Excel security program. When a cell is locked, the cell cannot be altered if the Excel worksheet is password protected. When a cell is unlocked, it can be altered and manipulated regardless of whether the worksheet is protected. In order to unlock a cell, the worksheet itself first has to have its password protection removed.
Instructions
1. Click on the "Review" tab on the ribbon at the top of the Excel window.
2. Select "Unprotect Sheet" from the list of button on the ribbon. Enter the password for the Excel worksheet in the pop-up window and then click "OK."
3. Click on the cell that you want to unlock. Right-click that cell and choose "Format Cells" from the pop-up menu.
4. Select the "Protection" tab in the "Format Cells" window. You will see a check mark next to "Locked" at the top of the window. Click on that check mark to remove it and then click "OK."
Tags: check mark, Excel worksheet, Format Cells, then click, When cell