Get Editing Cells Of Locked Pages

Now that you've locked/unlocked the cells that you want users to be able to edit, you want to protect the sheet. Once you protect the sheet, users cannot change the locked cells. However, they can still modify the unlocked cells. ... With the sheet protected, users will be unable to change the cells that are locked.

Now, you can choose the cells you specifically want to lock. On the worksheet, select just the cells that you want to lock. Bring up the Format Cells popup window again (Ctrl+Shift+F). This time, on the Protection tab, check the Locked box and then click OK.

Select the cells or ranges you want to unlock by a password when the sheet is protected. Go to the Review tab > Changes group, and click Allow Users to Edit Ranges. ... In the Allow Users to Edit Ranges dialog window, click the New button to add a new range:

You can enable or disable Edit mode by changing an Excel option. Click File > Options > Advanced. ... To enable Edit mode, select the Allow editing directly in cells check box. To disable Edit mode, clear the Allow editing directly in cells check box.

Select the cells you wish to modify. Choose the Home tab. In the Cells area, select Format > Format Cells . Select the Protection tab. Uncheck the box for Locked to unlock the cells. Check the box to lock them. Select OK .

Select the cells which you only allow to change in a worksheet, right click on the selected cells, and then click Format Cells from the right-clicking menu. See screenshot: 2. In the Format Cells dialog box, go to the Protection tab, uncheck the Locked box, and then click the OK button.

Click Protect Sheet Give the worksheet a password. Uncheck the worksheet protection property called Select Locked Cells Check the Sort property and the AutoFilter properties. Click OK

Go to the worksheet you want to unprotect. Go to File > Info > Protect > Unprotect Sheet, or from the Review tab > Changes > Unprotect Sheet. If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box, and click OK.