- On the\u00a0Review<\/strong>\u00a0tab, click\u00a0Unprotect Sheet<\/strong>\u00a0(in the\u00a0Changes<\/strong>\u00a0group).
![\"Unprotect](\"https:\/\/support.content.office.net\/en-us\/media\/2b56b2db-4631-40b1-a57c-6c91cc365483.jpg\")
<\/li>- Click the\u00a0Protect Sheet<\/strong>\u00a0button to\u00a0Unprotect Sheet<\/strong>\u00a0when a worksheet is protected.<\/li>
- If prompted, enter the password to unprotect the worksheet.<\/li><\/ol><\/li>
- Select the whole worksheet by clicking the\u00a0Select All<\/strong>\u00a0button.
![\"Select](\"https:\/\/support.content.office.net\/en-us\/media\/03ba0af2-8786-4b83-941c-0d53b4d67f31.jpg\")
<\/li>- On the\u00a0Home<\/strong>\u00a0tab, click the\u00a0Format Cell Font<\/strong>\u00a0popup launcher. You can also press Ctrl+Shift+F or Ctrl+1.
![\"Format](\"https:\/\/support.content.office.net\/en-us\/media\/23fadd75-ae99-4017-ac42-c4ac739a53c9.jpg\")
<\/li>- In the\u00a0Format Cells<\/strong>\u00a0popup, in the\u00a0Protection<\/strong>\u00a0tab, uncheck the\u00a0Locked<\/strong>\u00a0box and then click\u00a0OK<\/strong>.
This unlocks all the cells on the worksheet when you protect the worksheet. Now, you can choose the cells you specifically want to lock.<\/li>
- On the worksheet, select just the cells that you want to lock.<\/li>
- Bring up the\u00a0Format Cells<\/strong>\u00a0popup window again (Ctrl+Shift+F).<\/li>
- This time, on the\u00a0Protection<\/strong>\u00a0tab, check\u00a0the\u00a0Locked<\/strong>\u00a0box and then click\u00a0OK<\/strong>.<\/li>
- On the\u00a0Review<\/strong>\u00a0tab, click\u00a0Protect Sheet<\/strong>.
![\"Protect](\"https:\/\/support.content.office.net\/en-us\/media\/4543f329-cdde-445d-9948-45f0cb801816.jpg\")
<\/li>- In the\u00a0Allow all users of this worksheet to<\/strong>\u00a0list, choose\u00a0the elements that you want users to be able to change.<\/li>
- In the\u00a0Password to unprotect sheet<\/strong>\u00a0box, type a password for the sheet, click\u00a0OK<\/strong>, and then retype the password to confirm it.
- The password is optional. If you do not supply a password, any user can unprotect the sheet and change the protected elements.<\/li>
- Make sure that you choose a password that is easy to remember, because if you lose the password, you won’t have access to the protected elements on the worksheet.<\/li><\/ul><\/li><\/ol>\n\n\n\n
Unlock ranges on a protected worksheet for users to edit<\/h3>\n\n\n\n
To give specific users permission to edit ranges in a protected worksheet, your computer must be running Microsoft Windows XP or later, and your computer must be in a domain. Instead of using permissions that require a domain, you can also specify a password for a range.<\/p>\n\n\n\n
- Select the worksheet that you want to protect.<\/li>
- On the\u00a0Review<\/strong>\u00a0tab, in the\u00a0Changes<\/strong>\u00a0group, c<\/li>
- lick\u00a0Allow Users to Edit Ranges<\/strong>.
![\"Allow](\"https:\/\/support.content.office.net\/en-us\/media\/1b8040c2-c5b8-46ac-b6af-516bcf7cf01e.jpg\")
<\/li>- This command is available only when the worksheet is not protected.<\/li>
- Do one of the following:
- To add a new editable range, click\u00a0New<\/strong>.<\/li>
- To modify an existing editable range, select it in the\u00a0Ranges unlocked by a password when sheet is protected<\/strong>\u00a0box, and then click\u00a0Modify<\/strong>.<\/li>
- To delete an editable range, select it in the\u00a0Ranges unlocked by a password when sheet is protected<\/strong>\u00a0box, and then click\u00a0Delete<\/strong>.<\/li><\/ul><\/li>
- In the\u00a0Title<\/strong>\u00a0box, type the name for the range that you want to unlock.<\/li>
- In the\u00a0Refers to cells<\/strong>\u00a0box, type an equal sign (=<\/strong>), and then type the reference of the range that you want to unlock. You can also click the\u00a0Collapse Dialog<\/strong>\u00a0button, select the range in the worksheet, and then click the\u00a0Collapse Dialog<\/strong>\u00a0button again to return to the dialog box.<\/li>
- For password access, in the\u00a0Range password<\/strong>\u00a0box, type a password that allows access to the range. Specifying a password is optional when you plan to use access permissions. Using a password allows you to see user credentials of any authorized person who edits the range.<\/li>
- For access permissions, click\u00a0Permissions<\/strong>, and then click\u00a0Add<\/strong>.<\/li>
- In the\u00a0Enter the object names to select (examples)<\/strong>\u00a0box, type the names of the users who you want to be able to edit the ranges. To see how user names should be entered, click\u00a0examples<\/strong>. To verify that the names are correct, click\u00a0Check Names<\/strong>.<\/li>
- Click\u00a0OK<\/strong>.<\/li>
- To specify the type of permission for the user who you selected, in the\u00a0Permissions<\/strong>\u00a0box, select or clear the\u00a0Allow<\/strong>\u00a0or\u00a0Deny<\/strong>\u00a0check boxes, and then click\u00a0Apply<\/strong>.<\/li>
- Click\u00a0OK<\/strong>\u00a0two times. If prompted for a password, type the password that you specified.<\/li>
- In the\u00a0Allow Users to Edit Ranges<\/strong>\u00a0dialog box, click\u00a0Protect Sheet<\/strong>.<\/li>
- In the\u00a0Allow all users of this worksheet to<\/strong>\u00a0list, select the elements that you want users to be able to change.<\/li>
- In the\u00a0Password to unprotect sheet<\/strong>\u00a0box, type a password, click\u00a0OK<\/strong>, and then retype the password to confirm it.<\/li><\/ol>\n\n\n\n
- The password is optional. If you do not supply a password, then any user can unprotect the worksheet and change the protected elements.<\/li>
- Ensure that you choose a password that you can remember. If you lose the password, you will be unable to access to the protected elements on the worksheet.<\/li>
- If a cell belongs to more than one range, users who are authorized to edit any of those ranges can edit the cell.<\/li>
- If a user tries to edit multiple cells at once and is authorized to edit some but not all of those cells, the user will be prompted to edit the cells one-by-one.<\/li><\/ul>\n\n\n\n
Ref: https:\/\/support.microsoft.com\/en-us\/office\/lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a<\/p>\n","protected":false},"excerpt":{"rendered":"
By default, protecting a worksheet locks all cells so none of them are editable. To enable some cell editing, while leaving other cells locked, it’s possible to unlock all the cells. You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"footnotes":""},"categories":[10,18],"tags":[616,617],"class_list":["post-3066","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-lock-cells-in-excel","tag-unlock-cells-in-excel"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t
- To modify an existing editable range, select it in the\u00a0Ranges unlocked by a password when sheet is protected<\/strong>\u00a0box, and then click\u00a0Modify<\/strong>.<\/li>
- lick\u00a0Allow Users to Edit Ranges<\/strong>.
- Click the\u00a0Protect Sheet<\/strong>\u00a0button to\u00a0Unprotect Sheet<\/strong>\u00a0when a worksheet is protected.<\/li>