{"id":8271,"date":"2019-07-16T01:24:50","date_gmt":"2019-07-16T01:24:50","guid":{"rendered":"https:\/\/www.isunshare.com\/blog\/?p=8271"},"modified":"2019-07-16T01:24:50","modified_gmt":"2019-07-16T01:24:50","slug":"lock-selected-cells-in-excel-2016-2013-2010","status":"publish","type":"post","link":"https:\/\/www.isunshare.com\/blog\/lock-selected-cells-in-excel-2016-2013-2010\/","title":{"rendered":"2 Ways to Lock Selected Cells in Excel 2016\/2013\/2010"},"content":{"rendered":"<p>When you need to share an Excel worksheet with others, you might set a password to protect your worksheet from edit or modification. However, this way will lock all the cells in your worksheet. If you just want the certain cells to be locked, simply password protecting the worksheet can&#8217;t be applied. So, what can you at this time? Here, we will talk about 2 useful ways to <a href=\"https:\/\/www.isunshare.com\/blog\/lock-selected-cells-in-excel-2016-2013-2010\">lock the selected cells in Excel 2016\/2013\/2010<\/a>, let&#8217;s continue reading for more details.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"306\" class=\"aligncenter size-full wp-image-8272\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/lock-selected-cells-in-excel.png\" alt=\"lock selected cells in Excel\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/lock-selected-cells-in-excel.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/lock-selected-cells-in-excel-300x153.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<ul>\n<li><a href=\"#way1\">Lock Selected Cells with the Common Sheet Password<\/a><\/li>\n<li><a href=\"#way2\">Lock Certain Cells Using the Extra Range Password<\/a><\/li>\n<\/ul>\n<h2 id=\"way1\">1. Lock Selected Cells with the Common Sheet Password<\/h2>\n<p>You can use this way when you need others to fill in your Excel worksheet, but want to keep some items like the form title be unchangeable. And the locked cells only can be changed after entering the correct password for unprotecting the entire sheet.<\/p>\n<p>Step 1: Press Ctrl+A to select all the cells in the Excel worksheet. Then right-click the worksheet and choose Format Cells in the context menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"435\" height=\"242\" class=\"size-full wp-image-8274 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/select-format-cells-option.png\" alt=\"select the Format cells option\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/select-format-cells-option.png 435w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/select-format-cells-option-300x167.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/p>\n<p>Step 2: Switch to the Protection interface, untick the Locked option and click OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"531\" height=\"230\" class=\"size-full wp-image-8275 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/unlock-all-cells-in-excel.png\" alt=\"unlock all cells in Excel\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/unlock-all-cells-in-excel.png 531w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/unlock-all-cells-in-excel-300x130.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<p>Step 3: Select the cells that you plan to lock and right-click them to choose Format Cells and tick the Locked option in the Protection window. Then click OK to execute the operation.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"242\" class=\"size-full wp-image-8276 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/lock-the-selected-cells.png\" alt=\"lock the selected cells\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/lock-the-selected-cells.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/lock-the-selected-cells-300x121.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>Step 4: Locate to the tool menu &gt; choose Review &gt; select Protect Sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"574\" height=\"300\" class=\"size-full wp-image-8277 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/click-protect-sheet-under-review.png\" alt=\"click Protect Sheet under Review\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/click-protect-sheet-under-review.png 574w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/click-protect-sheet-under-review-300x157.png 300w\" sizes=\"auto, (max-width: 574px) 100vw, 574px\" \/><\/p>\n<p>Step 5: Enter a password to unprotect the worksheet and confirm it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"516\" height=\"323\" class=\"size-full wp-image-8278 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/protect-sheet-with-password.png\" alt=\"protect the sheet with password\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/protect-sheet-with-password.png 516w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/protect-sheet-with-password-300x188.png 300w\" sizes=\"auto, (max-width: 516px) 100vw, 516px\" \/><\/p>\n<p>After that, if the locked cells are clicked, a box will be popped out to remind that the cells are protected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"524\" height=\"111\" class=\"size-full wp-image-8279 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/box-for-protected-cells.png\" alt=\"box for the protected cells\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/box-for-protected-cells.png 524w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/box-for-protected-cells-300x64.png 300w\" sizes=\"auto, (max-width: 524px) 100vw, 524px\" \/><\/p>\n<h2 id=\"way2\">2. Lock Certain Cells Using the Extra Range Password<\/h2>\n<p>Besides the normal whole sheet password, this method provides an extra password for users to unlock the cells. It can be applied when you hope the user edit some of the locked cells. For example, you want the users just to fill in their own parts in your sheet.<\/p>\n<p>Steps 1-3 are the same as those of the Way 1 above.<\/p>\n<p>Step 4: Click the Review option in the upper panel and choose the Allow Edit Ranges button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"270\" class=\"size-full wp-image-8280 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/choose-allow-edit-ranges-button.png\" alt=\"choose the Allow edit ranges button\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/choose-allow-edit-ranges-button.png 600w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/choose-allow-edit-ranges-button-300x135.png 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/p>\n<p>Step 5: Choose New in the pop-out prompt. Then enter the range name, referred cells and range password in the box. Don&#8217;t forget to click OK to save the change.<\/p>\n<p><em>Tips: To select the referred cells, you can click the up arrow to select cells in the sheet or directly input the cells&#8217; locations.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"540\" height=\"272\" class=\"size-full wp-image-8281 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/set-the-new-range.png\" alt=\"set the new range\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/set-the-new-range.png 540w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/set-the-new-range-300x151.png 300w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/set-the-new-range-256x128.png 256w\" sizes=\"auto, (max-width: 540px) 100vw, 540px\" \/><\/p>\n<p>Step 6: After creating the range password successfully, select the Protect Sheet button and protect the whole worksheet with a password.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"526\" height=\"307\" class=\"size-full wp-image-8283 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/protect-the-whole-sheet.png\" alt=\"protect the whole sheet\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/protect-the-whole-sheet.png 526w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/protect-the-whole-sheet-300x175.png 300w\" sizes=\"auto, (max-width: 526px) 100vw, 526px\" \/><\/p>\n<p>At last, when you select the locked cells, you can see a pop-out prompt for you to enter the range password for changing the cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"333\" class=\"size-full wp-image-8284 alignnone\" src=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/unlock-range-prompt.png\" alt=\"the unlock range prompt\" srcset=\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/unlock-range-prompt.png 555w, https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2019\/07\/unlock-range-prompt-300x180.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/p>\n<hr \/>\n<p><strong>Related Articles:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.isunshare.com\/excel-password\/forgot-excel-2010-2013-workbook-password.html\">Forgot Excel Workbook 2010\/2013\/2016 Password<\/a><\/li>\n<li class=\"entry-title\"><a href=\"https:\/\/www.isunshare.com\/blog\/set-excel-workbook-read-only-to-restrict-changes\/\">How to Set Excel Workbook Read Only to Restrict Changes<\/a><\/li>\n<li class=\"entry-title\"><a href=\"https:\/\/www.isunshare.com\/blog\/remove-or-disable-read-only-in-excel-file\/\">How to Remove or Disable Read Only in Excel File<\/a><\/li>\n<li class=\"entry-title\"><a href=\"https:\/\/www.isunshare.com\/blog\/prevent-excel-sheet-from-deletion\/\">2 Options to Prevent Excel Sheets from Deletion<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>When you need to share an Excel worksheet with others, you might set a password to protect your&#8230;<\/p>\n","protected":false},"author":1,"featured_media":8272,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-8271","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/8271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=8271"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/8271\/revisions"}],"predecessor-version":[{"id":8291,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/8271\/revisions\/8291"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/8272"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=8271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=8271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=8271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}