{"id":5110,"date":"2025-09-28T11:42:42","date_gmt":"2025-09-28T11:42:42","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=5110"},"modified":"2025-10-03T04:34:34","modified_gmt":"2025-10-03T04:34:34","slug":"lock-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel","title":{"rendered":"How to Lock Cells in Excel? &#8211; (5 Working Ways)"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">It is vital to\u00a0<strong>lock cells in Excel<\/strong>\u00a0so that no one can modify the content of the protected cells without the owner\u2019s permission. Therefore, if you also want to restrict someone from making changes to your Excel cells, just check out this blog. This article contains different ways to lock cells in Excel to prevent editing and make them protected.<!--more--><\/p>\n<p>So, let\u2019s get started\u2026<\/p>\n<table style=\"height: 221px;\" width=\"971\">\n<tbody>\n<tr style=\"text-align: justify;\">\n<td style=\"background-color: #77c159; color: #ffffff;\" width=\"319\">\n<h3 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>Quick Ways<\/strong><\/span><\/h3>\n<\/td>\n<td style=\"background-color: #77c159;\" width=\"319\">\n<h3 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong>Step-By-Step Solutions Guide<\/strong><\/span><\/h3>\n<\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td style=\"text-align: justify;\" width=\"319\">\n<p style=\"text-align: left;\"><strong>Way 1- <\/strong>Lock Cells In Excel Worksheet<\/p>\n<\/td>\n<td width=\"319\">Choose the cells &gt;&gt; go to the\u00a0Home tab and then from the\u00a0Alignment<span style=\"font-family: inherit; font-size: inherit;\">&#8230;<\/span><strong style=\"font-family: inherit; font-size: inherit;\"><a href=\"#sol1\">Complete Steps<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td style=\"background-color: #f3f3f3;\" width=\"319\">\n<p style=\"text-align: left;\"><strong>Way 2- <\/strong>Lock Some Specific Cells In Excel<\/p>\n<\/td>\n<td style=\"background-color: #f3f3f3;\" width=\"319\">Choose the entire worksheet &gt;&gt; go to Home tab &gt;&gt; hit sign of the dialog box launcher<span style=\"font-family: inherit; font-size: inherit;\">&#8230;<\/span><strong style=\"font-family: inherit; font-size: inherit;\"><a href=\"#sol2\">Complete Steps<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td width=\"319\">\n<p style=\"text-align: left;\"><strong>Way 3- <\/strong>Lock Excel Cells Using VBA Code<\/p>\n<\/td>\n<td style=\"text-align: justify;\" width=\"319\">Choose entire cells in Excel spreadsheet &gt;&gt; go to the Home tab &gt;&gt; cells &gt;&gt; Format<span style=\"font-family: inherit; font-size: inherit;\">&#8230;<\/span><strong style=\"font-family: inherit; font-size: inherit;\"><a href=\"#sol3\">Complete Steps<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td style=\"background-color: #f3f3f3;\" width=\"319\">\n<p style=\"text-align: left;\"><strong>Way 4- <\/strong>Protect Entire Worksheet Except Few Cells<\/p>\n<\/td>\n<td style=\"background-color: #f3f3f3;\" width=\"319\">Press Control + 1 key &gt;&gt; in the opened Format Cells dialog box &gt;&gt; go to \u2018Protection\u2019.<span style=\"font-family: inherit; font-size: inherit;\">..<\/span><strong style=\"font-family: inherit; font-size: inherit;\"><a href=\"#sol4\">Complete Steps<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td width=\"319\">\n<p style=\"text-align: left;\"><strong>Way 5- <\/strong>Lock Formula Cells<\/p>\n<\/td>\n<td style=\"text-align: justify;\" width=\"319\">Choose Format Cells &gt;&gt; go to Protection tab &gt;&gt; untick Locked option &gt;&gt; OK<span style=\"font-family: inherit; font-size: inherit;\">&#8230;<\/span><strong style=\"font-family: inherit; font-size: inherit;\"><a href=\"#sol5\">Complete Steps<\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To repair &amp; recover corrupted Excel file data, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h2 style=\"text-align: left;\"><strong>What&#8217;s The Need To Lock Cells In Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">The plus point of<strong> locking cells in Excel <\/strong>is that it protects your data from unwanted changes.<\/p>\n<p style=\"text-align: justify;\">Suppose you have to share your Excel spreadsheet with other users, and there are some specific cells which you don&#8217;t want to get modified. In that case, cell lock is the best trick to avoid formula and formatting changes like issues.<\/p>\n<h2 style=\"text-align: left;\"><strong>How To Lock Cells In Excel?<\/strong><\/h2>\n<p><a name=\"sol1\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Way 1- Lock Cells In Excel Worksheet<\/strong><\/h3>\n<p style=\"text-align: justify;\">Follow the below-mentioned solutions to do so<strong>:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Choose the cells which you need to lock.<\/li>\n<li style=\"text-align: left;\">Go to the\u00a0<strong>Home <\/strong>tab and then from the\u00a0<strong>Alignment<\/strong>\u00a0group tap to the small arrow present across it. This will open the windows of\u00a0<strong>Format Cells<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5126 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1.png\" alt=\"Lock Some Specific Cells in Excel 1\" width=\"520\" height=\"140\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1.png 520w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1-300x81.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Now in the<strong> format cell<\/strong> window go to the\u00a0<strong>Protection <\/strong>tab and choose the check box of\u00a0<strong>Locked<\/strong> After that tap to the OK button to shut off this popup window.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5127 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-2.png\" alt=\"Lock Some Specific Cells in Excel 2\" width=\"539\" height=\"258\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-2.png 539w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-2-300x144.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Note:<\/strong> If you are attempting these steps on the worksheet or workbook which you haven\u2019t protected then you will find that the cells are locked already. This implies that the cell can also be locked when the workbook or worksheet is protected.<\/p>\n<ul style=\"text-align: justify;\">\n<li>From the excel ribbon hit the <strong>Review<\/strong> After that from the <strong>Changes <\/strong>group, you have to choose either\u00a0the <strong>Protect Workbook or Protect Sheet<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5135 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel.png\" alt=\"Lock Some Specific Cells in Excel\" width=\"1045\" height=\"120\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel.png 1045w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-300x34.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1024x118.png 1024w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-768x88.png 768w\" sizes=\"auto, (max-width: 1045px) 100vw, 1045px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Next, you have to reapply the protection over your workbook or worksheet.<\/li>\n<\/ul>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Tip<\/span>:<\/strong>\u00a0well it\u2019s a best solution to unlock cells which you need to modify before protecting a workbook or worksheet. But don\u2019t get worried as you can unlock them easily even after applying protection over it. For removing up the protection, all you need to do is just remove the applied password.<\/p>\n<\/div><\/div>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a href=\"https:\/\/www.repairmsexcel.com\/blog\/protect-excel-workbook-from-editing\" target=\"_blank\" rel=\"noopener\">5 Tricks To Protect Excel Workbook From Editing<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"sol2\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Way 2- <\/strong><strong>Lock Some Specific Cells In Excel<\/strong><\/h3>\n<p style=\"text-align: justify;\">Sometimes you just need to lock some individual cells which contain important data or formulas. In such cases, only protect the cells which you need to lock leaving the rest one as it is.<\/p>\n<p style=\"text-align: justify;\">By default, entire cells are comes locked, so if you apply protection to your sheet then entire cells are also get locked.<\/p>\n<p style=\"text-align: justify;\">So, make sure that only those cells are protected which you want to lock and after that only apply protection to the whole worksheet.<\/p>\n<p style=\"text-align: justify;\">Follow the steps to <strong>lock some specific cells in Excel<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose entire worksheet and then go to the <strong>Home<\/strong> tab.<\/li>\n<li>After that hit, the sign of the dialog box launcher presents the <strong>alignment <\/strong>group.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5126 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1.png\" alt=\"Lock Some Specific Cells in Excel 1\" width=\"520\" height=\"140\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1.png 520w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1-300x81.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now in the opened dialog box of <strong>Format Cells<\/strong>, got to the <strong>Protection <\/strong>tab and uncheck the<strong> Locked<\/strong> option. Hit the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5127 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-2.png\" alt=\"Lock Some Specific Cells in Excel 2\" width=\"539\" height=\"258\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-2.png 539w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-2-300x144.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose the cells which you need to lock.<\/li>\n<li>Again make a tap over the dialog box launcher present in the <strong>Alignment <\/strong>group which is under the <strong>Home <\/strong>tab.<\/li>\n<li>Now again in the opened dialog box of <strong>Format Cells<\/strong> go to the <strong>Protection<\/strong> tab and make a check mark across the <strong>Locked <\/strong>option.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5128 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-3.png\" alt=\"Lock Some Specific Cells in Excel 3\" width=\"538\" height=\"241\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-3.png 538w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-3-300x134.png 300w\" sizes=\"auto, (max-width: 538px) 100vw, 538px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Doing this will unlock entire cells of your worksheet except the one which you have selected for locking.<\/li>\n<li>Now go to the <strong>Review <\/strong>tab and then from the <strong>Changes <\/strong>group hit the <strong>Protect Sheet <\/strong>option.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5135 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel.png\" alt=\"Lock Some Specific Cells in Excel\" width=\"1045\" height=\"120\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel.png 1045w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-300x34.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-1024x118.png 1024w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-768x88.png 768w\" sizes=\"auto, (max-width: 1045px) 100vw, 1045px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>From the opened dialogue box of Protect Sheet:<\/li>\n<li>Check whether the option of \u2018<strong>Protect worksheet and contents of locked cells<\/strong>\u2019 is checked or not. If it\u2019s not then check it.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5129 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-4.png\" alt=\"Lock Some Specific Cells in Excel 4\" width=\"285\" height=\"320\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-4.png 285w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-4-267x300.png 267w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Enter the password to apply password on your sheet.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5130 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-5.png\" alt=\"Lock Some Specific Cells in Excel 5\" width=\"456\" height=\"321\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-5.png 456w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-5-300x211.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now specify the permission which you want to assign to other users. By default, you will see that the first two options are already selected. Using which user can easily make selection for the <strong>locked or unlocked cells<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5131 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-6.png\" alt=\"Lock Some Specific Cells in Excel 6\" width=\"285\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-6.png 285w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-6-268x300.png 268w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Apart from this you can also allow other options like inserting rows\/columns or making changes in the formatting.<\/li>\n<li>Tap to the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5132 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-7.png\" alt=\"Lock Some Specific Cells in Excel 7\" width=\"285\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-7.png 285w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-7-268x300.png 268w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<p style=\"text-align: justify;\">If you are applying any password then you are asked to reconfirm it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5133 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-8.png\" alt=\"Lock Some Specific Cells in Excel 8\" width=\"314\" height=\"195\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-8.png 314w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-8-300x186.png 300w\" sizes=\"auto, (max-width: 314px) 100vw, 314px\" \/><\/p>\n<p>When the next time you try to edit those specific cells, you will get the following error message pop-up dialog box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5134 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-9.png\" alt=\"Lock Some Specific Cells in Excel 9\" width=\"909\" height=\"241\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-9.png 909w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-9-300x80.png 300w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Lock-Some-Specific-Cells-in-Excel-9-768x204.png 768w\" sizes=\"auto, (max-width: 909px) 100vw, 909px\" \/><br \/>\n<a name=\"sol3\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Way 3- <\/strong><strong>Lock Excel Cells Using VBA Code<\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li>Choose entire cells in your Excel spreadsheet.<\/li>\n<li>Now go to the\u00a0<strong>Home <\/strong>tab first and then to <strong>cells<\/strong> from this cell section tap on the <strong>Format<\/strong>\u00a0option and choose the\u00a0<strong>format cells <\/strong>option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2775 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-1.png\" alt=\"Locking cells with Excel VBA 1\" width=\"768\" height=\"494\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-1.png 768w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-1-300x193.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>This will open a <strong>Format <\/strong>Cells dialogue box. On this opened dialog box, you need hit the <strong>Protection tab<\/strong>. Here you have un-select the option<strong> Locked<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2776 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-2.png\" alt=\"Locking cells with Excel VBA 2\" width=\"529\" height=\"460\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-2.png 529w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-2-300x261.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now in your Excel file where name of your sheet appears. Make a right click from your mouse and choose the <strong>View Code.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2777 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-3.png\" alt=\"Locking cells with Excel VBA 3\" width=\"361\" height=\"275\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-3.png 361w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-3-300x229.png 300w\" sizes=\"auto, (max-width: 361px) 100vw, 361px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>This will open <strong>Microsoft Visual Basic for Applications<\/strong> dialogue box. In this opened white sheet along with the dialogue box, you just need to type the below code.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2778 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-4.png\" alt=\"Locking cells with Excel VBA 4\" width=\"768\" height=\"759\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-4.png 768w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-4-300x296.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>In the written code, we have selected the data range from C7 to E11. And have also applied a password like, 1234.<\/li>\n<li>After entering the complete code go to the <strong>Debug<\/strong> Here you will find a\u00a0<strong>Run Sub\/User Form (F5) option <\/strong>tap on it.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2779 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-5.png\" alt=\"Locking cells with Excel VBA 5\" width=\"766\" height=\"294\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-5.png 766w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-5-300x115.png 300w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now you will see that your Excel worksheet is opening along with a password window.<\/li>\n<li>So, write same password that you as allotted in the VBA code eg: 1234.<\/li>\n<li>After doing this whenever you approach for making changes in the desired cells of the Excel. This will throw a warning message stating that <strong>\u201cyou can\u2019t edit the cells as it is protected\u201d.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2780 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-6.png\" alt=\"Locking cells with Excel VBA 6\" width=\"767\" height=\"345\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-6.png 767w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/09\/Locking-cells-with-Excel-VBA-6-300x135.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Note<\/span>:<\/strong>\u00a0To unlock the cells locked with Excel VBA code you have to follow the same unlocking procedures as explained earlier.<\/p>\n<\/div><\/div>\n<blockquote>\n<p style=\"text-align: center;\"><strong><span style=\"color: #ff0000;\">Also Read<\/span>; <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/unlock-password-protected-xlsx-file\">Top 3 Methods To Unlock Password Protected Excel File<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"sol4\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Way 4- <\/strong><strong>Protect Entire Worksheet Except Few Cells<\/strong><\/h3>\n<p style=\"text-align: justify;\">In some cases, people also want to protect the entire worksheet by keeping some of the cells unlocked.<\/p>\n<p style=\"text-align: justify;\">Well, such a situation arises when you have added interactive features in your worksheet like a drop-down list. And you want that your drop-down keeps working even when the worksheet is protected.<\/p>\n<p style=\"text-align: justify;\">To accomplish this task, just follow the below-mentioned steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Make a selection of the cells which you want to keep unlocked.<\/li>\n<li>Press the <strong>Control + 1<\/strong> key from your keyboard.<\/li>\n<li>In the opened <strong>Format Cells<\/strong> dialog box go to the <strong>\u2018Protection\u2019.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5136 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-1.png\" alt=\"Protect the Entire Sheet except few cells 1\" width=\"671\" height=\"220\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-1.png 671w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-1-300x98.png 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Unselect the<strong> Locked<\/strong> option and hit the OK button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Now if the entire worksheet is kept protected, these particular cells should work normally.<\/p>\n<p style=\"text-align: justify;\">For this you have to perform the following steps, so as to protect the entire worksheet except the selected cells:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Hit the <strong>Review<\/strong> tab and then from the <strong>Changes <\/strong>group tap to the <strong>Protect Sheet<\/strong> icon.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5137 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-2.png\" alt=\"Protect the Entire Sheet except few cells 2\" width=\"420\" height=\"135\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-2.png 420w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-2-300x96.png 300w\" sizes=\"auto, (max-width: 420px) 100vw, 420px\" \/><\/p>\n<ul>\n<li>In the opened <strong>Protect Sheet<\/strong> dialog box:<\/li>\n<li>Check whether the option of \u2018<strong>Protect worksheet and contents of locked cells<\/strong>\u2019 is checked or not. If it\u2019s not then check it.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5138 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-3.png\" alt=\"Protect the Entire Sheet except few cells 3\" width=\"285\" height=\"320\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-3.png 285w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-3-267x300.png 267w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><\/p>\n<ul>\n<li>Enter the password to apply password on your sheet).<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5139 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-4.png\" alt=\"Protect the Entire Sheet except few cells 4\" width=\"456\" height=\"321\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-4.png 456w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-4-300x211.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Now specify the permission which you want to assign to other users. By default, you will see that the first two options are already selected. Using which user can easily make selection for the locked or unlocked cells.<\/li>\n<li>Apart from this you can also allow other options like inserting rows\/columns or making changes in the formatting.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5141 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-6.png\" alt=\"Protect the Entire Sheet except few cells 6\" width=\"285\" height=\"319\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-6.png 285w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/Protect-the-Entire-Sheet-except-few-cells-6-268x300.png 268w\" sizes=\"auto, (max-width: 285px) 100vw, 285px\" \/><br \/>\n<a name=\"sol5\"><\/a><\/p>\n<h3 style=\"text-align: justify;\"><strong>Way 5- <\/strong><strong>Lock Formula Cells<\/strong><\/h3>\n<p style=\"text-align: justify;\">To <strong>lock formula cells<\/strong>, the very first thing you need to do is unlock all the cells and then only lock the cells having the formula in it. At last protect the sheet.<\/p>\n<p style=\"text-align: justify;\">Well if you don\u2019t know how to perform all these tasks then follow the below steps:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose entire cell of your worksheet.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5118 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-1.jpg\" alt=\"lock formula cell 1\" width=\"604\" height=\"127\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-1.jpg 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-1-300x63.jpg 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now make a right click and from the listed option choose the <strong>Format Cells.<\/strong><\/li>\n<li>On the opened format cell window go to the <strong>Protection<\/strong> tab and untick the check box of<strong> Locked<\/strong> option. After that hit the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5119 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-2.png\" alt=\"lock formula cell 2\" width=\"529\" height=\"465\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-2.png 529w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-2-300x264.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Go to the <strong>Home<\/strong> tab and then from the<strong> Editing<\/strong> group choose the <strong>Find &amp; Select.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5120 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-3.png\" alt=\"lock formula cell 3\" width=\"338\" height=\"100\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-3.png 338w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-3-300x89.png 300w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Hit the <strong>Go To Special <\/strong>option.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5121 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-4.png\" alt=\"lock formula cell 4\" width=\"183\" height=\"272\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Choose <strong>Formulas<\/strong> and hit the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5122 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-5.png\" alt=\"lock formula cell 5\" width=\"314\" height=\"330\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-5.png 314w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-5-285x300.png 285w\" sizes=\"auto, (max-width: 314px) 100vw, 314px\" \/><\/p>\n<p style=\"text-align: justify;\">You will see that after doing these steps Excel will selects all the formula cells.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5123 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-6.png\" alt=\"lock formula cell 6\" width=\"604\" height=\"127\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-6.png 604w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-6-300x63.png 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Press the <strong>CTRL + 1<\/strong> button from your keyboard.<\/li>\n<li>Go to the<strong> Protection<\/strong> tab and select the check box of <strong>Locked <\/strong>option. After that press the <strong>OK<\/strong> button.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5124 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-7.png\" alt=\"lock formula cell 7\" width=\"529\" height=\"465\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-7.png 529w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/lock-formula-cell-7-300x264.png 300w\" sizes=\"auto, (max-width: 529px) 100vw, 529px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Note:<\/strong><\/p>\n<p style=\"text-align: justify;\">If you select the check box of <strong>Hidden<\/strong> option then the user will not be able to see the formula within the formula bar even after choosing the formula cells.<\/p>\n<p style=\"text-align: justify;\">Always keep in mind that locking cells doesn\u2019t have any effect until and unless the worksheet is protected.<\/p>\n<ul style=\"text-align: justify;\">\n<li>So now it\u2019s time to protect your Excel sheet.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">After this, you will see that entire the formula cells are been locked. In case of editing these cells, firstly you need to unprotect the worksheet.<\/p>\n<h2 style=\"text-align: left;\"><strong>Use Excel Repair Tool to Repair\/Recover Corrupted Excel Documents<\/strong><\/h2>\n<p style=\"text-align: justify;\"><a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>MS Excel Repair Tool<\/strong><\/a> is a special tool that is specifically designed to repair any sort of issues, corruption, errors in Excel file. This can also easily restore entire lost Excel data including <strong>cell comments, charts, worksheet properties, and other related data.<\/strong><\/p>\n<p style=\"text-align: justify;\">It is a unique tool that can repair multiple corrupted Excel files in one repair cycle and restore data to a new blank Excel file or the preferred location. The tool has the ability to recover data without modifying the original formatting.<\/p>\n<ul>\n<li style=\"text-align: left;\">The interface is very simple, with a large toolbar of buttons to add files or folders to the application.<\/li>\n<li style=\"text-align: left;\">With this software, you can repair your corrupted Excel file.<\/li>\n<li style=\"text-align: left;\">It can easily restore all corrupt excel files and also recover everything which includes cell comments, charts, worksheet properties, and other related data.<\/li>\n<li style=\"text-align: left;\">The corrupted excel file can be restored to a new blank Excel file.<\/li>\n<li style=\"text-align: left;\">It has the ability to recover the complete Excel file data from the file and restore them even without modifying the original formatting.<\/li>\n<\/ul>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Try Now<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/www.repairmsexcel.com\/blog\/buy-now' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Buy Now<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> Free version of the product only previews recoverable data.<\/div><\/center>\n<h3 style=\"text-align: left;\">Steps to Utilize MS Excel Repair Tool:<\/h3>\n\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Can I Lock Multiple Cells in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, you can lock multiple cells in Excel through freeze panes. Apart from that, you can use a shortcut key- F4 to lock specific columns or rows in the document as well as the range of cells that you want to lock.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Are You Able to Lock Some Cells in an Excel Workbook and Not Others?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, on the Excel worksheet, you have to select only the cells you want to lock. Now, bring up the Format Cells window by pressing (<strong>Ctrl+Shift+F<\/strong>). At this time, go to the Protection tab, check the Locked box &gt;&gt; select OK.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Make a Cell Non-Editable in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo make a cell non editable in Excel, you need to make cell as read only using VBA code. Although using the VBA code helps to make cell as read-only so that no one can edit them and even you don\u2019t have to lock the cells to protect your worksheet data.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Are the Three Different Ways to Protect Your Workbook?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe three different ways to protect your workbook are: <ul><li>Password Protection (File Level) <\/li><li>Protect Workbook Structure <\/li><li>Lock Cells and Protect Sheet                     <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Does F4 Lock Cells in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, the F4 key is a shortcut mode or we can say the easiest way to lock cells in the MS Excel.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Can I Lock Multiple Cells in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, you can lock multiple cells in Excel through freeze panes. Apart from that, you can use a shortcut key- F4 to lock specific columns or rows in the document as well as the range of cells that you want to lock.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Are You Able to Lock Some Cells in an Excel Workbook and Not Others?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, on the Excel worksheet, you have to select only the cells you want to lock. Now, bring up the Format Cells window by pressing (<strong>Ctrl+Shift+F<\/strong>). At this time, go to the Protection tab, check the Locked box &gt;&gt; select OK.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Make a Cell Non-Editable in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To make a cell non editable in Excel, you need to make cell as read only using VBA code. Although using the VBA code helps to make cell as read-only so that no one can edit them and even you don\u2019t have to lock the cells to protect your worksheet data.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Are the Three Different Ways to Protect Your Workbook?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The three different ways to protect your workbook are: &lt;ul&gt;&lt;li&gt;Password Protection (File Level) &lt;\/li&gt;&lt;li&gt;Protect Workbook Structure &lt;\/li&gt;&lt;li&gt;Lock Cells and Protect Sheet\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Does F4 Lock Cells in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, the F4 key is a shortcut mode or we can say the easiest way to lock cells in the MS Excel.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: justify;\">Bottom Line<\/h2>\n<p style=\"text-align: justify;\">Locking cells in Excel help you to keep the formula completely safe from being tempered by any third-party user.<\/p>\n<p style=\"text-align: justify;\">Hopefully, this informative tutorial seems helpful to you on how to protect cells in excel without protecting sheets. Don\u2019t forget to leave a comment if you have any queries or tips to share about <strong>how to lock cells in Excel and protect them.<\/strong><\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>External References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/lock-cells-to-protect-them-cb7835f6-9c37-4161-bb53-d1c410acaf21\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/lock-cells-to-protect-them-cb7835f6-9c37-4161-bb53-d1c410acaf21<\/a><\/li>\n<\/ul>\n<\/div><\/div>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>It is vital to\u00a0lock cells in Excel\u00a0so that no one can modify the content of the protected cells without the &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Lock Cells in Excel? &#8211; (5 Working Ways)\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#more-5110\" aria-label=\"Read more about How to Lock Cells in Excel? &#8211; (5 Working Ways)\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":5145,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[728,1216,1213],"class_list":["post-5110","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-how-to-lock-cells-in-excel","tag-lock-excel-cells-using-vba-code","tag-lock-multiple-cells-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Lock Cells in Excel? - (5 Working Ways)<\/title>\n<meta name=\"description\" content=\"Read this excellent post and learn how to lock cells in Excel. Also, learn how to lock specific cells, lock formulas, and more tricks here.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Lock Cells in Excel? - (5 Working Ways)\" \/>\n<meta property=\"og:description\" content=\"Read this excellent post and learn how to lock cells in Excel. Also, learn how to lock specific cells, lock formulas, and more tricks here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-28T11:42:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-03T04:34:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Lock Cells in Excel? &#8211; (5 Working Ways)\",\"datePublished\":\"2025-09-28T11:42:42+00:00\",\"dateModified\":\"2025-10-03T04:34:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel\"},\"wordCount\":2235,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png\",\"keywords\":[\"how to lock cells in excel\",\"Lock Excel Cells Using VBA Code\",\"Lock Multiple Cells In Excel\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel\",\"name\":\"How to Lock Cells in Excel? - (5 Working Ways)\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png\",\"datePublished\":\"2025-09-28T11:42:42+00:00\",\"dateModified\":\"2025-10-03T04:34:34+00:00\",\"description\":\"Read this excellent post and learn how to lock cells in Excel. Also, learn how to lock specific cells, lock formulas, and more tricks here.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png\",\"width\":900,\"height\":450,\"caption\":\"How To Lock Cells In Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Lock Cells in Excel? &#8211; (5 Working Ways)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Lock Cells in Excel? - (5 Working Ways)","description":"Read this excellent post and learn how to lock cells in Excel. Also, learn how to lock specific cells, lock formulas, and more tricks here.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Lock Cells in Excel? - (5 Working Ways)","og_description":"Read this excellent post and learn how to lock cells in Excel. Also, learn how to lock specific cells, lock formulas, and more tricks here.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2025-09-28T11:42:42+00:00","article_modified_time":"2025-10-03T04:34:34+00:00","og_image":[{"width":900,"height":450,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Lock Cells in Excel? &#8211; (5 Working Ways)","datePublished":"2025-09-28T11:42:42+00:00","dateModified":"2025-10-03T04:34:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel"},"wordCount":2235,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png","keywords":["how to lock cells in excel","Lock Excel Cells Using VBA Code","Lock Multiple Cells In Excel"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel","name":"How to Lock Cells in Excel? - (5 Working Ways)","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png","datePublished":"2025-09-28T11:42:42+00:00","dateModified":"2025-10-03T04:34:34+00:00","description":"Read this excellent post and learn how to lock cells in Excel. Also, learn how to lock specific cells, lock formulas, and more tricks here.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/05\/How-To-Lock-Cells-In-Excel.png","width":900,"height":450,"caption":"How To Lock Cells In Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/lock-cells-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Lock Cells in Excel? &#8211; (5 Working Ways)"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=5110"}],"version-history":[{"count":2,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5110\/revisions"}],"predecessor-version":[{"id":9217,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5110\/revisions\/9217"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/5145"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=5110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=5110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=5110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}