{"id":12198,"date":"2014-05-29T09:43:12","date_gmt":"2014-05-29T09:43:12","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=3696"},"modified":"2014-05-29T09:43:12","modified_gmt":"2014-05-29T09:43:12","slug":"protect-excel-sheet","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/","title":{"rendered":"Excel Trick – Sheet Protection – Protect it and Stay Free"},"content":{"rendered":"

Dear Readers,<\/p>\n

I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your whole sheet except a cell or cell range<\/strong>.
\nOne of my avid reader Avinash Dubey<\/strong><\/a> wanted me to post an article on Disabling\/protecting rest all the cells which are unused.<\/p>\n

\nHey Vishwa,
\n 
\nBackground is changed as per the second method but I want unused space disabled. I mean, the cells where user has provided the data can be formatted and rest of the cells (unused) should be white and disabled.
\n 
\nPlease post this topic.
\n 
\nThanks,
\nAvinash\n<\/p><\/blockquote>\n

Here I am going to put all possible ways of disabling or preventing users from accessing unused cells in your worksheet.<\/p>\n

Protect whole Sheet except the range you want to allow user to edit<\/h3>\n

You might be knowing about Protect Sheet<\/strong> option available in Excel in Review Tab . Using this option you can protect your whole Worksheet by providing a password (Passing a password is not mandatory). It does not work only on selected area rather it protects the whole sheet.
\n 
\nNow the question is how to protect all sheet except the area which you want user to be able to edit<\/strong> Follow the below steps to achieve this:
\n <\/p>\n

Step 1.<\/h3>\n

Select the Cell or Cell Range you want user to be able to edit<\/p>\n

Step 2.<\/h3>\n

Right click on Selected Cell or Cell Range and click on Format Cells<\/strong>
\n\"How<\/p>\n

Step 3.<\/h3>\n

Go to Protection Tab and Un-Check the checkbox shown in the below image
\n\"Uncheck<\/p>\n

Step 4.<\/h3>\n

Now go to Review Tab<\/strong> and Click on Protect Sheet<\/strong>
\n\"Protect-sheet<\/p>\n

Step 5.<\/h3>\n

Now Enter a password to protect the sheet and click Ok
\n\"Protect-sheet-with-password\"<\/p>\n

Step 6.<\/h3>\n

Now re-enter the password and click on Ok
\n\"Re-enter-password\"<\/p>\n

Now your whole worksheet is protected except the areas you selected to change the formatting above<\/h2>\n

\nYou are done now !! Your whole sheet is protected except the area you wanted users to edit. Now no one can edit the sheet beyond the cells you provided an access to. Then go and Enjoy your freedom \ud83d\ude42 your sheet is protected now \ud83d\ude42\n<\/p><\/blockquote>\n

If you too have any Excel Tip to share or Want an Article to be published, let me know by putting your tips and suggestions in comment<\/h2>\n<\/span>","protected":false},"excerpt":{"rendered":"

Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1673,1676,1682],"tags":[],"class_list":["post-12198","post","type-post","status-publish","format-standard","hentry","category-excel-functions","category-excel-tips","category-popular-articles"],"yoast_head":"\nExcel Trick - Sheet Protection - Protect it and Stay Free - Let's excel in Excel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Trick - Sheet Protection - Protect it and Stay Free\" \/>\n<meta property=\"og:description\" content=\"Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2014-05-29T09:43:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\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:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Excel Trick – Sheet Protection – Protect it and Stay Free\",\"datePublished\":\"2014-05-29T09:43:12+00:00\",\"dateModified\":\"2014-05-29T09:43:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\"},\"wordCount\":418,\"commentCount\":8,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png\",\"articleSection\":[\"Excel Functions\",\"Excel Tips\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\",\"name\":\"Excel Trick - Sheet Protection - Protect it and Stay Free - Let's excel in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png\",\"datePublished\":\"2014-05-29T09:43:12+00:00\",\"dateModified\":\"2014-05-29T09:43:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Functions\",\"item\":\"https:\/\/vmlogger.com\/excel\/excel-functions\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Trick – Sheet Protection – Protect it and Stay Free\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Trick - Sheet Protection - Protect it and Stay Free - Let's excel in Excel","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:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/","og_locale":"en_US","og_type":"article","og_title":"Excel Trick - Sheet Protection - Protect it and Stay Free","og_description":"Dear Readers, I am back with another Excel Trick which is very much common while managing your sheet with certain security (protection). To protect the whole Worksheet can be easily done by using the Protect Sheet option available in Microsoft Excel. But in this article I am going to explain you, How to protect your […]","og_url":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2014-05-29T09:43:12+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Excel Trick – Sheet Protection – Protect it and Stay Free","datePublished":"2014-05-29T09:43:12+00:00","dateModified":"2014-05-29T09:43:12+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/"},"wordCount":418,"commentCount":8,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png","articleSection":["Excel Functions","Excel Tips","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/","url":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/","name":"Excel Trick - Sheet Protection - Protect it and Stay Free - Let's excel in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png","datePublished":"2014-05-29T09:43:12+00:00","dateModified":"2014-05-29T09:43:12+00:00","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2014\/05\/format-cells.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2014\/05\/protect-excel-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Functions","item":"https:\/\/vmlogger.com\/excel\/excel-functions\/"},{"@type":"ListItem","position":3,"name":"Excel Trick – Sheet Protection – Protect it and Stay Free"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12198"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=12198"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/12198\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=12198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=12198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=12198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}