{"id":472051,"date":"2022-07-08T22:00:05","date_gmt":"2022-07-08T19:00:05","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-unprotect-a-microsoft-excel-workbook\/"},"modified":"2022-07-08T22:00:05","modified_gmt":"2022-07-08T19:00:05","slug":"how-to-unprotect-a-microsoft-excel-workbook","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-unprotect-a-microsoft-excel-workbook\/","title":{"rendered":"#How to Unprotect a Microsoft Excel Workbook"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3d82b39ecf0\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3d82b39ecf0\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unprotect-a-microsoft-excel-workbook\/#%E2%80%9CHow_to_Unprotect_a_Microsoft_Excel_Workbook%E2%80%9D\" >&#8220;How to Unprotect a Microsoft Excel Workbook&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unprotect-a-microsoft-excel-workbook\/#Unprotecting_a_Workbook_vs_Unprotecting_a_Worksheet\" >Unprotecting a Workbook vs. Unprotecting a Worksheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unprotect-a-microsoft-excel-workbook\/#Unprotect_an_Excel_Workbook\" >Unprotect an Excel Workbook<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-unprotect-a-microsoft-excel-workbook\/#Unprotect_an_Excel_Worksheet\" >Unprotect an Excel Worksheet<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Unprotect_a_Microsoft_Excel_Workbook%E2%80%9D\"><\/span>&#8220;How to Unprotect a Microsoft Excel Workbook&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background.\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Whether you want to make structural changes or modify the content in your Microsoft Excel workbooks, you\u2019ll have to unprotect those items first. We\u2019ll show you how to do just that.<\/p>\n<p>If you used a password to protect your Excel items, you\u2019ll need that password in the unlocking procedure below, so keep that handy.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Lock Cells in Microsoft Excel to Prevent Editing<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Unprotecting_a_Workbook_vs_Unprotecting_a_Worksheet\"><\/span>Unprotecting a Workbook vs. Unprotecting a Worksheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019d like to make structural changes to your workbook, like adding, moving, deleting, hiding, or renaming your worksheets, you\u2019ll have to unprotect your workbook (as opposed to unprotecting a worksheet). Doing that unlocks the options to make the above-mentioned changes to your workbook.<\/p>\n<p>In case you\u2019re looking to modify the data in your worksheet, such as changing the content of a cell, you\u2019ll have to unprotect your sheet. This allows you to add and remove content from your worksheet.<\/p>\n<p>Either way, it\u2019s easy to unprotect your items in Excel as we\u2019ll explain below.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Unprotect_an_Excel_Workbook\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Unprotect an Excel Workbook<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To be able to make structural changes to your workbook, first, launch your spreadsheet with Microsoft Excel.<\/p>\n<p>In <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/714701\/how-to-switch-back-to-the-classic-ribbon-in-microsoft-office\/\">Excel\u2019s ribbon at the top, click the \u201cReview\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-810346\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/1-excel-review-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the &quot;Review&quot; tab at the top.\" width=\"648\" height=\"362\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the \u201cReview\u201d tab, from the \u201cProtect\u201d section, choose \u201cProtect Workbook.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-810347\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/2-unprotect-excel-workbook.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select &quot;Protect Workbook.&quot;\" width=\"645\" height=\"372\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you didn\u2019t use a password to protect your workbook, your workbook is now unprotected.<\/p>\n<p>In case you used a password for protection, then in the \u201cUnprotect Workbook\u201d box that opens, type that password and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-810348\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/3-enter-excel-workbook-password.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"406\" height=\"139\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your workbook is now unlocked and you can add, remove, delete, hide, and rename worksheets in it. Enjoy!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Rename Worksheet Tabs in Excel<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Unprotect_an_Excel_Worksheet\"><\/span>Unprotect an Excel Worksheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To change the content of your cells in your worksheet, first, open your spreadsheet with Microsoft Excel.<\/p>\n<p>When Excel opens, in the ribbon at the top, select the \u201cReview\u201d tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-810349\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/4-excel-review-tab.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Open the &quot;Review&quot; tab at the top.\" width=\"650\" height=\"363\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>On the \u201cReview\u201d tab, from the \u201cProtect\u201d section, choose \u201cUnprotect Sheet.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-810350\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/5-unprotect-excel-worksheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"644\" height=\"355\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you didn\u2019t use a password to protect your worksheet, your worksheet is now unlocked.<\/p>\n<p>In case you did use a password, then in the \u201cUnprotect Sheet\u201d box, enter your password and click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-810351\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/06\/6-enter-excel-worksheet-password.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"406\" height=\"139\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Your worksheet is now unlocked and you can make whatever changes you want to it.<\/p>\n<hr\/>\n<p>Need to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/357597\/how-to-protect-cells-from-editing-in-microsoft-excel\/\">re-protect your Excel workbook? If so, it\u2019s a quick and easy process to do that.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Protect Workbooks, Worksheets, and Cells From Editing in Microsoft Excel<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/810325\/how-to-unprotect-a-microsoft-excel-workbook\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Unprotect a Microsoft Excel Workbook&#8221; Whether you want to make structural changes or modify the content in your Microsoft Excel workbooks, you\u2019ll have to unprotect those items first. We\u2019ll show you how to do just that. If you used a password to protect your Excel items, you\u2019ll need that password in the unlocking&#8230;<\/p>\n","protected":false},"author":1,"featured_media":472052,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-472051","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/472051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=472051"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/472051\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/472052"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=472051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=472051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=472051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}