{"id":24506,"date":"2026-04-02T05:29:53","date_gmt":"2026-04-02T05:29:53","guid":{"rendered":"https:\/\/www.kaashivinfotech.com\/blog\/?p=24506"},"modified":"2026-04-02T06:02:56","modified_gmt":"2026-04-02T06:02:56","slug":"how-to-lock-cells-in-excel","status":"publish","type":"post","link":"https:\/\/www.kaashivinfotech.com\/blog\/how-to-lock-cells-in-excel\/","title":{"rendered":"How to Lock Cells in Excel \u2013 Secure Your Data"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Excel is the backbone of modern business. With over 2 billion users worldwide, it\u2019s the go-to tool for everything from simple grocery lists to complex financial modeling. But here is the problem: when you share a spreadsheet with a team, it only takes one accidental &#8220;Delete&#8221; key press to ruin hours of work.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you\u2019ve ever had a coworker accidentally overwrite a complex formula or delete a crucial data point, you know the frustration. Learning how to&nbsp;<strong>lock cells in Excel<\/strong>&nbsp;isn&#8217;t just a technical skill\u2014it\u2019s a way to ensure your data remains accurate and your sanity stays intact.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this comprehensive guide, we\u2019ll walk through everything from locking the entire sheet to setting specific permissions for different team members.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why Should You Lock Cells in Excel?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Before we dive into the &#8220;how,&#8221; let\u2019s talk about the &#8220;why.&#8221; Locking cells helps you:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Prevent Accidental Deletion:<\/strong>\u00a0Stop users from erasing important headers or data.<\/li>\n\n\n\n<li><strong>Protect Formulas:<\/strong>\u00a0Ensure your calculations stay consistent.<\/li>\n\n\n\n<li><strong>Control User Input:<\/strong>\u00a0Guide users to only fill out specific &#8220;input&#8221; cells.<\/li>\n\n\n\n<li><strong>Professionalism:<\/strong>\u00a0A locked, functional sheet looks much more professional in a corporate setting.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How to Lock All Cells in Excel<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">By default, Excel has a &#8220;Locked&#8221; property enabled for every cell. However, this property does nothing until you actually&nbsp;<strong>Protect<\/strong>&nbsp;the worksheet. Here is how to lock everything at once:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Select the Entire Sheet<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You can either press&nbsp;<strong>Ctrl + A<\/strong>&nbsp;on your keyboard or click the small triangle icon in the top-left corner of your grid (where the row numbers and column letters meet).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Verify the Cell Status<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Right-click anywhere on the grid and select&nbsp;<strong>Format Cells<\/strong>&nbsp;(Shortcut:&nbsp;<strong>Ctrl + 1<\/strong>). Navigate to the&nbsp;<strong>Protection<\/strong>&nbsp;tab. Make sure the&nbsp;<strong>Locked<\/strong>&nbsp;box is checked. Click OK.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Activate Protection<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Go to the&nbsp;<strong>Review<\/strong>&nbsp;tab on the top ribbon and click on&nbsp;<strong>Protect Sheet<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Set a Password<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A dialog box will appear. Enter a password (choose something you won\u2019t forget!). You can also check or uncheck boxes to decide what users&nbsp;<em>can<\/em>&nbsp;do, such as formatting cells or inserting rows.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Confirm<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click OK, re-enter your password to confirm, and your entire sheet is now read-only for anyone without the password.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-9-1024x683.webp\" alt=\"\" class=\"wp-image-24509\" style=\"aspect-ratio:1.4992888417882142;width:534px;height:auto\" srcset=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-9-1024x683.webp 1024w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-9-300x200.webp 300w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-9-768x512.webp 768w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-9-440x293.webp 440w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-9-680x453.webp 680w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-9.webp 1536w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to Lock Specific Cells in Excel (The &#8220;Input Form&#8221; Method)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Often, you want people to enter data in certain boxes (like a Name or Date field) but keep the rest of the sheet locked. This requires a &#8220;reverse&#8221; approach.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Unlock Everything First<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Select the entire sheet (<strong>Ctrl + A<\/strong>). Right-click, go to&nbsp;<strong>Format Cells &gt; Protection<\/strong>, and&nbsp;<strong>uncheck<\/strong>&nbsp;the &#8220;Locked&#8221; box. Now, all cells are technically &#8220;unprotected.&#8221;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Lock the Target Cells<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Now, select only the specific cells or columns you want to protect. Right-click &gt;&nbsp;<strong>Format Cells &gt; Protection<\/strong>&nbsp;and&nbsp;<strong>check<\/strong>&nbsp;the &#8220;Locked&#8221; box.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Protect the Sheet<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Go to&nbsp;<strong>Review &gt; Protect Sheet<\/strong>&nbsp;and set your password. Now, only the cells you selected in Step 2 will be uneditable, while the rest of the sheet remains open for data entry.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to Lock Formula Cells in Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-12-1024x683.webp\" alt=\"\" class=\"wp-image-24512\" style=\"aspect-ratio:1.4992888417882142;width:486px;height:auto\" srcset=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-12-1024x683.webp 1024w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-12-300x200.webp 300w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-12-768x512.webp 768w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-12-440x293.webp 440w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-12-680x453.webp 680w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-12.webp 1536w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Formula cells are the most vulnerable part of any spreadsheet. You want the results to show, but you don\u2019t want anyone touching the logic.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Select All Cells:<\/strong>\u00a0Press\u00a0<strong>Ctrl + A<\/strong>\u00a0and unlock them via the\u00a0<strong>Format Cells<\/strong>\u00a0menu.<\/li>\n\n\n\n<li><strong>Find the Formulas:<\/strong>\u00a0On the\u00a0<strong>Home<\/strong>\u00a0tab, click\u00a0<strong>Find &amp; Select<\/strong>\u00a0>\u00a0<strong>Go To Special<\/strong>.<\/li>\n\n\n\n<li><strong>Choose Formulas:<\/strong>\u00a0Select the radio button for\u00a0<strong>Formulas<\/strong>\u00a0and click OK. Excel will now automatically highlight every cell containing a formula.<\/li>\n\n\n\n<li><strong>Lock Them:<\/strong>\u00a0Without clicking anywhere else, right-click one of the highlighted cells, go to\u00a0<strong>Format Cells > Protection<\/strong>, and check\u00a0<strong>Locked<\/strong>.<\/li>\n\n\n\n<li><strong>Protect the Sheet:<\/strong>\u00a0Finally, go to the\u00a0<strong>Review<\/strong>\u00a0tab and hit\u00a0<strong>Protect Sheet<\/strong>. Your formulas are now safe!<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">How to Unlock Ranges for Specific Users<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If you are working in a large department, you might want the Sales team to edit one area and the Inventory team to edit another. Excel\u2019s&nbsp;<strong>\u201cAllow Users to Edit Ranges\u201d<\/strong>&nbsp;feature is perfect for this.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Define the Range<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Go to the&nbsp;<strong>Review<\/strong>&nbsp;tab and click&nbsp;<strong>Allow Edit Ranges<\/strong>. Click&nbsp;<strong>New<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Assign Permissions<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Title:<\/strong>\u00a0Give the range a name (e.g., &#8220;Sales_Data&#8221;).<\/li>\n\n\n\n<li><strong>Refers to cells:<\/strong>\u00a0Highlight the specific cells the Sales team can use.<\/li>\n\n\n\n<li><strong>Range Password:<\/strong>\u00a0Set a unique password for this specific section.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Repeat and Protect<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Repeat this for the Inventory team with a different password. Once you click&nbsp;<strong>Protect Sheet<\/strong>&nbsp;in the Review tab, the sheet will be locked. However, if a Sales member tries to click their area, Excel will prompt them for the &#8220;Sales&#8221; password, giving them exclusive access to that section.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-10-1024x683.webp\" alt=\"\" class=\"wp-image-24510\" style=\"aspect-ratio:1.4992888417882142;width:604px;height:auto\" srcset=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-10-1024x683.webp 1024w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-10-300x200.webp 300w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-10-768x512.webp 768w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-10-440x293.webp 440w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-10-680x453.webp 680w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-10.webp 1536w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">What Can You Control? (Sheet Protection Settings)<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you protect a sheet, Excel gives you a checklist of permissions. Here is what they mean:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">Option<\/th><th class=\"has-text-align-left\" data-align=\"left\">What It Lets Users Do<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\"><strong>Select locked cells<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\">Users can click on the cell (useful for copying data) but can&#8217;t change it.<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><strong>Format cells<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\">Change colors, fonts, and borders.<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><strong>Insert\/Delete Rows<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\">Add or remove horizontal lines of data.<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><strong>Sort<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\">Reorder data (Note: this only works if the range is unlocked).<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\"><strong>Use AutoFilter<\/strong><\/td><td class=\"has-text-align-left\" data-align=\"left\">Allow users to use the dropdown arrows to filter data.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Common Mistakes to Avoid<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">When you lock cells in Excel, keep these &#8220;pro tips&#8221; in mind to avoid common headaches:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Protection vs. Encryption:<\/strong>\u00a0Locking a sheet stops\u00a0<em>edits<\/em>, but it doesn&#8217;t stop people from\u00a0<em>looking<\/em>\u00a0at your data. If the data is sensitive (like salaries), you should encrypt the entire file with a password via\u00a0<strong>File > Info > Protect Workbook > Encrypt with Password<\/strong>.<\/li>\n\n\n\n<li><strong>The &#8220;Forgotten Password&#8221; Trap:<\/strong>\u00a0Microsoft cannot recover lost sheet passwords. If you lose it, you are locked out of your own data forever. Always keep a backup or use a password manager.<\/li>\n\n\n\n<li><strong>Hidden Sheets:<\/strong>\u00a0Just because a sheet is hidden doesn&#8217;t mean it&#8217;s locked. Always protect the workbook structure (<strong>Review > Protect Workbook<\/strong>) to prevent people from unhiding sheets.<\/li>\n<\/ul>\n\n\n\n<h1 class=\"wp-block-heading\">Become A Data Analyst With Kaashiv Infotech<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Looking to dive into the world of data analytics and carve your path to success? Kaashiv Infotech is here for you! Our Comprehensive <a href=\"https:\/\/course.kaashivinfotech.com\/data-analysis-course-in-chennai\">Data analytics \u00a0<strong>Inplant Training (IPT)<\/strong><\/a>\u00a0is specially designed by experts to equip you with practical skills and real-world experience that will help you to set your foot in the competitive <a href=\"https:\/\/course.kaashivinfotech.com\/data-analytics-course-in-chennai\">Data Analytics Course in chennai<\/a> industry.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s break down our training offerings to see what makes our program stand out<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Live Industry Projects + Portfolio Building:<\/strong>\u00a0You\u2019ll work on\u00a0<strong>2 real-time projects<\/strong>\u00a0to build a solid portfolio and enhance your learning with actual industry scenarios that showcase your skills in <a href=\"https:\/\/www.kaashiv.com\/internship\/powerbi\" target=\"_blank\" rel=\"noopener\">Power BI<\/a>, <a href=\"https:\/\/kaashiv.com\/internship\/tableau-internship\" target=\"_blank\" rel=\"noopener\">Tableau<\/a>, and<a href=\"https:\/\/www.kaashiv.com\/internship\/microsoft-excel-internship\" target=\"_blank\" rel=\"noopener\"> Excel<\/a>.<br><strong>Practice Exercises:<\/strong>\u00a0Get hands-on practice with daily exercises that enhance your learning and help you master key concepts like SQL, Python, and Visualization.<br><strong>Doubt Clearing Sessions:<\/strong>\u00a0Our regular doubt sessions ensure that no question goes unanswered, giving you clarity of all the technical concepts.<br><strong>Dedicated Learning Environment:<\/strong>\u00a0Access our expert-led learning labs for intensive practice and polish your coding skills in a supportive environment.<br><strong>Industry-Oriented Curriculum:<\/strong>\u00a0Learn industry-relevant skills and techniques that are directly applicable to real-world scenarios and business needs.<br><strong>Triple Certification Credential:<\/strong>\u00a0Earn\u00a0<strong>three certificates<\/strong>\u00a0upon completion\u2014Internship Certificate, IPT Certificate, and Industrial Exposure Certificate\u2014that are recognized and valued by employers in the industry.<br><strong>Career Community Forum:<\/strong>\u00a0Engage with fellow batchmates and instructors in our forum to exchange ideas, seek advice, and collaborate on complex datasets.<br><strong>Expert-Led Sessions:<\/strong>\u00a0Benefit from interactive sessions led by\u00a0<strong>Microsoft MVPs and Google-recognized experts<\/strong>\u00a0who guide you every step of the way.<br><strong>Interview Preparation:<\/strong>\u00a0Gain access to curated interview opportunities and comprehensive preparation materials, including extensive\u00a0<strong>interview question banks<\/strong>, to help you land your dream job in data analytics.<br><strong>100% Job Assistance Guarantee + Career Tools:<\/strong>\u00a0We\u2019re offering 100% job assistance along with\u00a0<strong>ATS-friendly resume tools<\/strong>\u00a0and ongoing support to ensure you are placement-ready.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So what are you waiting for? Launch your career with confidence! Join the Kaashiv Infotech Inplant Training Program and unlock your potential today.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-13-1024x683.webp\" alt=\"\" class=\"wp-image-24513\" style=\"aspect-ratio:1.4992888417882142;width:526px;height:auto\" srcset=\"https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-13-1024x683.webp 1024w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-13-300x200.webp 300w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-13-768x512.webp 768w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-13-440x293.webp 440w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-13-680x453.webp 680w, https:\/\/www.kaashivinfotech.com\/blog\/wp-content\/uploads\/2026\/04\/image-13.webp 1536w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Locking cells in Excel is the best way to maintain data integrity, especially in collaborative environments. Whether you are protecting complex financial formulas or simply making sure a teammate doesn&#8217;t mess up a schedule, these steps ensure your hard work stays protected.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you&#8217;re looking to master Excel and other data tools, check out the resources at\u00a0<strong>kaashivinfotech.com<\/strong>. Mastering these small technical details is what separates a basic user from a <a href=\"https:\/\/www.wikitechy.com\/technology\/why-power-bi-understanding-the-benefits-and-ease-of-learning\/\" target=\"_blank\" rel=\"noopener\">data expert<\/a>!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Frequently Asked Questions (FAQs)<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">1. Why can I still edit cells after locking them?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">You likely forgot the final step:&nbsp;<strong>Protect Sheet<\/strong>. In Excel, the &#8220;Locked&#8221; property doesn&#8217;t do anything until the worksheet protection is turned on under the&nbsp;<strong>Review<\/strong>&nbsp;tab.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Can I lock cells without a password?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Yes! When you click&nbsp;<strong>Protect Sheet<\/strong>, you can leave the password field blank and click OK. This prevents accidental edits, but anyone can turn the protection off with a single click.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. How do I lock cells in Excel but allow sorting?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When you click&nbsp;<strong>Protect Sheet<\/strong>, scroll down the list of permissions and check the box that says&nbsp;<strong>Sort<\/strong>. Note that the cells you want to sort must also be &#8220;unlocked&#8221; in the Format Cells menu for this to work effectively.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4. Is there a shortcut to lock cells?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To get to the Protection menu quickly, press&nbsp;<strong>Ctrl + 1<\/strong>&nbsp;and then use the arrow keys or mouse to navigate to the&nbsp;<strong>Protection<\/strong>&nbsp;tab.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">5. How do I unlock a specific cell that was locked?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Go to&nbsp;<strong>Review &gt; Unprotect Sheet<\/strong>&nbsp;(enter the password if required). Then select the cell, press&nbsp;<strong>Ctrl + 1<\/strong>, uncheck&nbsp;<strong>Locked<\/strong>, and re-protect the sheet.<\/p>\n\n\n<div id=\"rank-math-faq\" class=\"rank-math-block\">\n<div class=\"rank-math-list \">\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"Excel is the backbone of modern business. With over 2 billion users worldwide, it\u2019s the go-to tool for&hellip;","protected":false},"author":38,"featured_media":24508,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_singular_sidebar":"","csco_page_header_type":"","csco_page_load_nextpost":"","footnotes":""},"categories":[10934,10968,220],"tags":[13883,8517,13881,13884,13885,13882],"class_list":["post-24506","post","type-post","status-publish","format-standard","has-post-thumbnail","category-business-analyst","category-power-bi","category-technology","tag-excel-data-protection","tag-excel-tutorial","tag-lock-cells-in-excel","tag-lock-formulas-excel","tag-protect-worksheet-excel","tag-spreadsheet-security","cs-entry"],"_links":{"self":[{"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/posts\/24506","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/comments?post=24506"}],"version-history":[{"count":0,"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/posts\/24506\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/media\/24508"}],"wp:attachment":[{"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/media?parent=24506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/categories?post=24506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaashivinfotech.com\/blog\/wp-json\/wp\/v2\/tags?post=24506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}