{"id":3547,"date":"2018-11-30T16:18:57","date_gmt":"2018-11-30T16:18:57","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3547"},"modified":"2024-03-28T11:36:52","modified_gmt":"2024-03-28T11:36:52","slug":"lock-cells","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/","title":{"rendered":"Lock Cells in Excel"},"content":{"rendered":"\n

In Excel 2019, but also in earlier versions, Excel allows you to create a password to lock a number of cells or even the entire worksheet to prevent it from being modified by other users who don\u2019t know the password.<\/p>\n\n\n\n

By default, when you lock a worksheet a user without a password will be able to select protected cells, but won\u2019t be able to edit or format them. These settings can be changed in the options.<\/p>\n\n\n\n

How to lock all cells inside a worksheet<\/h2>\n\n\n\n
    \n
  1. Navigate to Review >> Changes<\/strong>.<\/li>\n\n\n\n
  2. Click the Protect Sheet button<\/strong>.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
      \n
    1. Enter the password<\/strong>. You don\u2019t have to enter anything, but then a user can unprotect the sheet, only by clicking the Unprotect Sheet button.<\/li>\n\n\n\n
    2. Reenter the password<\/strong>.<\/li>\n\n\n\n
    3. Allow Actions<\/strong>. Inside the Protect Sheet window, you can select which actions users will be able to perform. By default, only selecting locked and unlocked cells are You can keep the default setting, select more actions, or uncheck all of them.<\/li>\n<\/ol>\n\n\n\n
      \"\"<\/figure>\n\n\n\n
        \n
      1. Click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n

        If you try to edit any cell, you will get an error.<\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n

        How to lock selected cells inside a worksheet<\/h2>\n\n\n\n

        Instead of protecting all cells inside a workbook, you can allow users to modify some of them. Here, is how you can do it.<\/p>\n\n\n\n

          \n
        1. Select cells<\/strong><\/a> you want to be unlocked<\/strong>. In our example, we will keep cells C2:C4<\/li>\n\n\n\n
        2. Navigate to Review >> Changes<\/strong>.<\/li>\n\n\n\n
        3. Click the Allow Users to Edit Ranges button<\/strong>.<\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. Create a new range.<\/strong> The cells, you\u2019ve already selected are typed inside Refers to Cells area. You can modify them if you want. You can add a password, but we want all users to have access to these cells.<\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
              \n
            1. Click OK<\/strong>.<\/li>\n\n\n\n
            2. Inside Allow Users to Edit Ranges window, click OK<\/strong>.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
                \n
              1. Navigate to Review >> Changes >> Protect Sheet Button.<\/strong> Make the same changes as you did in protecting the entire worksheet.<\/li>\n<\/ol>\n\n\n\n

                You can edit cells C2:C4.<\/p>\n\n\n\n

                \"\"<\/figure>\n\n\n\n

                If you try to edit any cell outside this range you will get the same error as before.<\/p>\n\n\n\n

                \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

                In Excel 2019, but also in earlier versions, Excel allows you to create a password to lock a number of cells or even…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"\nLock Cells in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to lock cells in Excel to prevent modifications by unauthorized users. Protect entire sheets or select cells with password protection.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lock Cells in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to lock cells in Excel to prevent modifications by unauthorized users. Protect entire sheets or select cells with password protection.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-30T16:18:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T11:36:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Lock Cells in Excel\",\"datePublished\":\"2018-11-30T16:18:57+00:00\",\"dateModified\":\"2024-03-28T11:36:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/\"},\"wordCount\":343,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/\",\"name\":\"Lock Cells in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png\",\"datePublished\":\"2018-11-30T16:18:57+00:00\",\"dateModified\":\"2024-03-28T11:36:52+00:00\",\"description\":\"Learn how to lock cells in Excel to prevent modifications by unauthorized users. Protect entire sheets or select cells with password protection.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lock Cells in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lock Cells in Excel","description":"Learn how to lock cells in Excel to prevent modifications by unauthorized users. Protect entire sheets or select cells with password protection.","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:\/\/officetuts.net\/excel\/examples\/lock-cells\/","og_locale":"en_US","og_type":"article","og_title":"Lock Cells in Excel","og_description":"Learn how to lock cells in Excel to prevent modifications by unauthorized users. Protect entire sheets or select cells with password protection.","og_url":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/","article_published_time":"2018-11-30T16:18:57+00:00","article_modified_time":"2024-03-28T11:36:52+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Lock Cells in Excel","datePublished":"2018-11-30T16:18:57+00:00","dateModified":"2024-03-28T11:36:52+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/"},"wordCount":343,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/","url":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/","name":"Lock Cells in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png","datePublished":"2018-11-30T16:18:57+00:00","dateModified":"2024-03-28T11:36:52+00:00","description":"Learn how to lock cells in Excel to prevent modifications by unauthorized users. Protect entire sheets or select cells with password protection.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/lock-cells\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/protect-sheet-ribbon.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/lock-cells\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Lock Cells in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3547"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3547"}],"version-history":[{"count":7,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3547\/revisions"}],"predecessor-version":[{"id":17336,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3547\/revisions\/17336"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}