{"id":1803,"date":"2023-11-03T20:23:05","date_gmt":"2023-11-03T20:23:05","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kunci\/"},"modified":"2023-12-06T06:12:53","modified_gmt":"2023-12-06T06:12:53","slug":"kunci","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kunci\/","title":{"rendered":"Bagaimana cara cepat mengunci lembar kerja di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3164955203\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Di Excel, ada opsi untuk mengunci lembar. Seperti yang Anda ketahui, kami memiliki empat tipe lembar berbeda di Excel untuk digunakan, dan Anda bisa mengunci semua lembar ini. Tutorial ini mengajarkan kita cara menggunakan opsi &#8220;Proteksi Lembar&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92692\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengunci daun\" width=\"764\" height=\"156\"><\/figure><\/div><h2 id=\"h-lock-protect-a-worksheet\" class=\"wp-block-heading\"> Kunci &#8220;Lindungi&#8221; lembar kerja<\/h2><ol><li> Pertama, klik kanan tab worksheet, lalu klik \u201cProtect Sheet\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"Lembar pelindung dalam 2 klik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-la-feuille-de-protection.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-click-on-protect-sheet\" width=\"453\" height=\"348\"><\/li><li> Di <a href=\"https:\/\/exceladvisor.org\/id\/kotak-dialog\/\">kotak dialog<\/a> &#8220;Proteksi Lembar&#8221;, pilih opsi yang ingin Anda izinkan untuk diubah oleh pengguna. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-pilih-opsi-yang-dapat-diubah oleh pengguna\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-choisissez-les-options-que-les-utilisateurs-peuvent-modifier.png\" sizes=\"auto, \" srcset=\"\" alt=\"3-choose-options-that-users-can-edit\" width=\"247\" height=\"412\"><\/li><li> Dan masukkan kata sandi yang ingin Anda terapkan dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-masukkan kata sandi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-entrez-le-mot-de-passe.png\" sizes=\"auto, \" srcset=\"\" alt=\"4-enter-the-password\" width=\"301\" height=\"130\"><\/li><li> Kemudian masukkan kembali kata sandi yang sama untuk mengonfirmasi, lalu klik OK untuk menerapkan kunci. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-masukkan kembali kata sandi untuk mematuhi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-re-entrer-le-mot-de-passe-pour-se-conformer.png\" sizes=\"auto, \" srcset=\"\" alt=\"5-re-enter-password-to-conform\" width=\"318\" height=\"182\"><\/li><\/ol><p> Ketika Anda mengklik OK, itu mengunci lembar menggunakan kata sandi yang ditentukan (123456). Saat pengguna mencoba mengedit sel, sebuah pesan ditampilkan: &#8220;Sel atau bagan yang Anda coba edit ada di lembar yang dilindungi. Untuk membuat perubahan, buka proteksi lembar. Anda mungkin diminta memasukkan kata sandi. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92697\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-popup-pour-deproteger-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"popup-ke-buka proteksi-sheet\" width=\"796\" height=\"162\"><\/figure><\/div><p> Untuk membuka proteksi, Anda perlu mengikuti langkah yang sama dan memasukkan kata sandi yang Anda tentukan (123456). Perlindungan lembar tetap utuh meskipun Anda memindahkan atau menyalin lembar ke buku kerja baru atau yang sudah ada.<\/p><p class=\"qt-tip\"> <strong>Catatan<\/strong> : Anda dapat melewatkan menentukan kata sandi tetapi mengunci lembarnya. Dalam hal ini, pengguna tidak memerlukan kata sandi untuk membuka kunci sheet. Namun lembar tersebut akan memiliki semua perlindungan yang Anda tentukan.<\/p><h2 id=\"h-lock-a-chart-sheet-macro-sheet-or-dialog-sheet\" class=\"wp-block-heading\"> Kunci lembar grafik, lembar makro, atau lembar dialog<\/h2><p> Seperti yang saya katakan, Anda dapat mengunci semua jenis lembar, dan setiap lembar berisi sekumpulan item yang dapat Anda lindungi dengan kunci tersebut.<\/p><h3 id=\"h-chart-sheet\" class=\"wp-block-heading\"> Lembar Bagan <\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92698\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-verrouiller-une-macro-graphique-ou-une-feuille-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengunci makro bagan atau lembar dialog\" width=\"283\" height=\"244\"><\/figure><\/div><h3 id=\"h-macro-sheet\" class=\"wp-block-heading\"> Daun makro <\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92699\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Feuille-de-macro-a-8-serrures.png\" sizes=\"auto, \" srcset=\"\" alt=\"kunci lembar makro\" width=\"291\" height=\"251\"><\/figure><\/div><h3 id=\"h-dialog-sheet\" class=\"wp-block-heading\"> Lembar dialog <\/h3><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92700\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-Verrouiller-la-feuille-de-dialogue.png\" sizes=\"auto, \" srcset=\"\" alt=\"lembar dialog kunci\" width=\"318\" height=\"186\"><\/figure><\/div><p> Seperti yang Anda lihat pada contoh di atas, menentukan kata sandi adalah opsional di lembar. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-de-verrouillage.xlsx\" rel=\"nofollow\">Unduh<\/a> <\/div><div class=\"gb-container gb-container-3044ba66 gb-container-mt\"><p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja\/\" data-wpil=\"url\">Lembar Bentang Excel<\/a><\/strong><\/p><h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> Tutorial lainnya <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-7495e031\"><div class=\"gb-container gb-container-7495e031\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengkonsolidasikan\/\">Konsolidasikan data dari beberapa spreadsheet<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\">Ganti nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/grup-1\/\">Kelompokkan Lembar Kerja di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/\">Lihat dua lembar berdampingan di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-530ab33a\"><div class=\"gb-container gb-container-530ab33a\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menampilkan\/\">Melihat lembar Excel atau semua lembar (spreadsheet)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-1\/\">Hapus lembar (lembar kerja) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/duplikat\/\">Gandakan lembar atau spreadsheet di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tautan-ke-lembar-lain\/\">Buat hyperlink (tautan) ke spreadsheet lain<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1803","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bagaimana cara cepat mengunci lembar kerja di Excel?<\/title>\n<meta name=\"description\" content=\"Panduan singkat ini akan membantu Anda mengunci lembar di Excel dalam beberapa langkah sederhana. Mari kita periksa ini...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/kunci\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara cepat mengunci lembar kerja di Excel?\" \/>\n<meta property=\"og:description\" content=\"Panduan singkat ini akan membantu Anda mengunci lembar di Excel dalam beberapa langkah sederhana. Mari kita periksa ini...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kunci\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kunci\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kunci\/\",\"name\":\"Bagaimana cara cepat mengunci lembar kerja di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kunci\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kunci\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\",\"datePublished\":\"2023-11-03T20:23:05+00:00\",\"dateModified\":\"2023-12-06T06:12:53+00:00\",\"description\":\"Panduan singkat ini akan membantu Anda mengunci lembar di Excel dalam beberapa langkah sederhana. Mari kita periksa ini...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kunci\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kunci\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kunci\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kunci\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara cepat mengunci lembar kerja di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara cepat mengunci lembar kerja di Excel?","description":"Panduan singkat ini akan membantu Anda mengunci lembar di Excel dalam beberapa langkah sederhana. Mari kita periksa ini...","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:\/\/exceladvisor.org\/id\/kunci\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara cepat mengunci lembar kerja di Excel?","og_description":"Panduan singkat ini akan membantu Anda mengunci lembar di Excel dalam beberapa langkah sederhana. Mari kita periksa ini...","og_url":"https:\/\/exceladvisor.org\/id\/kunci\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:53+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/kunci\/","url":"https:\/\/exceladvisor.org\/id\/kunci\/","name":"Bagaimana cara cepat mengunci lembar kerja di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kunci\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kunci\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png","datePublished":"2023-11-03T20:23:05+00:00","dateModified":"2023-12-06T06:12:53+00:00","description":"Panduan singkat ini akan membantu Anda mengunci lembar di Excel dalam beberapa langkah sederhana. Mari kita periksa ini...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kunci\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kunci\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kunci\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-verrouiller-une-feuille.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kunci\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara cepat mengunci lembar kerja di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1803","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1803"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1803\/revisions"}],"predecessor-version":[{"id":2253,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1803\/revisions\/2253"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}