Unlocking cells for data entry
To remove the Locked protection status from a cell range or nonadjacent selection, follow these steps:
- Select the range or ranges to be unlocked.
To select multiple ranges to create a nonadjacent cell selection, hold down the Ctrl key as you drag through each range. - Choose Format → Cells or press Ctrl+1 to open the Format Cells dialog box.
- Select the Protection tab and then clear the Locked check box.
- Click OK to close the Format Cells dialog box.
Keep in mind that unlocking cells does nothing in and of itself. It's not until you turn on the protection for your worksheet that your unlocked cells work any differently from the locked ones. At that time, only unlocked cells accept the edits that you specify.
In this tutorial:
- Spreadsheet Security
- Assigning a Password for Opening a Workbook
- Opening a password-protected workbook
- Changing or deleting passwords
- Protecting the Worksheet Against Unwanted Changes
- Unlocking cells for data entry
- Turning on worksheet protection
- Removing protection from a worksheet
- Enabling cell range editing by certain users
- Protecting the structure of the workbook file
- Hiding Sensitive Worksheet Data