{"id":359644,"date":"2021-10-28T18:00:10","date_gmt":"2021-10-28T15:00:10","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-lock-cells-in-microsoft-excel\/"},"modified":"2021-10-28T18:00:10","modified_gmt":"2021-10-28T15:00:10","slug":"how-to-lock-cells-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-lock-cells-in-microsoft-excel\/","title":{"rendered":"#How to Lock Cells in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a40d423102e9\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a40d423102e9\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-lock-cells-in-microsoft-excel\/#Why_Lock_Cells_in_a_Spreadsheet\" >Why Lock Cells in a Spreadsheet?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-lock-cells-in-microsoft-excel\/#Locking_Cells_in_an_Excel_Spreadsheet\" >Locking Cells in an Excel Spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-lock-cells-in-microsoft-excel\/#Protecting_the_Sheet\" >Protecting the Sheet<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Lock Cells in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you\u2019re working on a spreadsheet in Microsoft Excel, locking your cells is crucial to protecting data, preventing mistakes, and more. Today, we\u2019ll show you how to do it.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Why_Lock_Cells_in_a_Spreadsheet\"><\/span>Why Lock Cells in a Spreadsheet?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you collaborate with others on a workbook, you might want to protect a cell by locking\u2014especially if you want to make any changes or adjustments later. Locked cells can\u2019t be reformatted, altered, or deleted. Locking cells works in conjunction with protecting the workbook. To change data within the cells, they need to be unlocked, and the sheet must be unprotected.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Locking_Cells_in_an_Excel_Spreadsheet\"><\/span>Locking Cells in an Excel Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can lock individual cells or multiple cells using this method. Here\u2019s how to do it with multiple cells.<\/p>\n<p>In a new or existing Microsoft Excel document, select the cell or cell range you wish to lock. The cells you selected <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ear slightly shaded, indicating they\u2019re going to be locked.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756743 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/lockcells1.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In a new or existing Microsoft Excel document, select the cell or cell range you wish to lock.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cHome\u201d tab on the ribbon, select \u201cFormat.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756740 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/Formatbox.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In the &quot;Home&quot; tab on the ribbon, select &quot;Format&quot; to open the formatting menu.\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cFormat\u201d menu, select \u201cLock Cell.\u201d Doing so will lock any of the cells you selected.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756742 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/Lockcellformatmenu.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In the &quot;Format&quot; menu, select &quot;Lock Cell&quot; to lock the cells you previously selected.\" width=\"650\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>An alternative way to lock cells is to select your cells, then right-click them to bring up a menu. In that menu, select \u201cFormat Cells.\u201d In the \u201cFormat Cells\u201d box, click the \u201cProtection\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756745 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/protectformat.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In the &quot;Format Cells&quot; box, navigate to the &quot;Protection&quot; tab and click on it.\" width=\"650\" height=\"485\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cProtection\u201d tab, click the checkbox that says \u201cLocked\u201d to enable cell locking. This performs the exact same function as locking cells in the format tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756746 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/formatlocked.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In the &quot;Protection&quot; tab, click on the box labelled &quot;Locked&quot; and click &quot;OK.&quot;\" width=\"650\" height=\"485\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After that, your cells are locked. If you ever need to unlock them, perform the steps above in reverse. Once you\u2019ve finished locking your cells, you need to protect your workbook.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Protecting_the_Sheet\"><\/span>Protecting the Sheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After you lock the cell, you\u2019ll notice that it still lets you change the text or delete content. That\u2019s because, in order for locking cells to work, you must also protect your sheet or workbook. Here\u2019s how. In the Excel ribbon toolbar, click \u201cReview.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756748 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/selectreview.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In the ribbon, click on &quot;Review.&quot;\" width=\"650\" height=\"256\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the ribbon under the \u201cReview\u201d tab, select \u201cProtect Sheet.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756749 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/protectsheet.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In the ribbon under the &quot;Review&quot; tab, click on &quot;Protect Sheet.&quot;\" width=\"650\" height=\"256\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the \u201cProtect Sheet\u201d menu, you can create a password to protect the sheet and select a number of different parameters. For now, check the box marked \u201cProtect worksheet and contents of locked cells.\u201d Make any other adjustments you wish and click \u201cOK\u201d to protect the sheet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-756750 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/protectsheetmenu.jpg?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"In the &quot;Protect Sheet&quot; menu, select &quot;Protect worksheet and contents of locked cells,&quot; then create a password and click &quot;OK.&quot;\" width=\"650\" height=\"395\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Among the other options on the list, you can prevent other users from deleting\/inserting rows and columns, altering the formatting, or <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/general\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"General\" target=\"_blank\" rel=\"noopener\">general<\/a>ly messing with the document by clicking on them in the protection menu. Once the sheet is fully protected, no one can access the locked cells without using a password to unlock them first.<\/p>\n<p>If you need to unlock the worksheet later, revisit the Review &gt; Protect Sheet menu and uncheck \u201cProtect worksheet and contents of locked cells.\u201d Now that you know how to lock cells, you can sleep safely knowing your spreadsheets and workbooks won\u2019t be altered without being unlocked first. Happy locking!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Protect Workbooks, Worksheets, and Cells From Editing in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/756064\/how-to-lock-cells-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Lock Cells in Microsoft Excel&#8221; When you\u2019re working on a spreadsheet in Microsoft Excel, locking your cells is crucial to protecting data, preventing mistakes, and more. Today, we\u2019ll show you how to do it. Why Lock Cells in a Spreadsheet? If you collaborate with others on a workbook, you might want to protect&#8230;<\/p>\n","protected":false},"author":1,"featured_media":359645,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-359644","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/359644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=359644"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/359644\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/359645"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=359644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=359644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=359644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}