{"id":1927,"date":"2023-10-27T23:22:27","date_gmt":"2023-10-27T23:22:27","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hanya-baca\/"},"modified":"2023-12-06T06:13:46","modified_gmt":"2023-12-06T06:13:46","slug":"hanya-baca","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hanya-baca\/","title":{"rendered":"Bagaimana cara membuat read-only di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-731903549\"><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>Terkadang pengguna ingin mengatur mode default buku kerja ke baca-saja untuk mencegah pengguna mengubah apa pun secara tidak sengaja atau sengaja dalam data.<\/p><p> Pengguna biasanya menyiapkan mode buku kerja hanya ketika mereka memiliki terlalu banyak rumus atau perhitungan dalam data, dan mereka tidak ingin mengacaukannya.<\/p><p> Dalam tutorial ini, kami akan menunjukkan kepada Anda beberapa cara untuk mempersiapkan mode buku kerja Excel default saja dan Anda dapat memilih salah satunya sesuai dengan preferensi Anda.<\/p><h2 id=\"h-make-workbook-ready-only-using-save-as\" class=\"wp-block-heading\"> Siapkan buku kerja hanya dengan menggunakan Simpan Sebagai<\/h2><ol><li> Pertama, buka tab \u201cFile\u201d dan kemudian klik \u201cSave As\u201d untuk menyimpan buku kerja dalam mode read-only. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-simpan-sebagai-opsi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png\" sizes=\"auto, \" srcset=\"\" alt=\"save-as-option\" width=\"130\" height=\"367\"><\/li><li> Setelah itu, pilih lokasi untuk menyimpannya, lalu klik tombol &#8220;Alat&#8221;, lalu pilih &#8220;Opsi Umum&#8221; dari menu tarik-turun. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-pilih-opsi-umum\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-choisir-les-options-generales.png\" sizes=\"auto, \" srcset=\"\" alt=\"choose-general-options\" width=\"674\" height=\"251\"><br><br><\/li><li> Sekarang, atur kata sandi di kolom \u201cKata Sandi untuk diubah\u201d, lalu pilih opsi \u201cDirekomendasikan hanya dibaca\u201d dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-masukkan-kata sandi-untuk-mengubah\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-entrez-le-mot-de-passe-pour-modifier.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-password-to-modify\" width=\"305\" height=\"206\"><\/li><li> Biarkan kolom &#8220;Kata Sandi untuk diubah&#8221; kosong, jika Anda tidak ingin menyetel kata sandi dan hanya ingin menyarankan pengguna membuka file dalam mode baca-saja. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-tanda centang-baca-saja-direkomendasikan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coches-lecture-seule-recommandee.png\" sizes=\"auto, \" srcset=\"\" alt=\"tickmark-read-only-recommended\" width=\"305\" height=\"209\"><\/li><li> Setelah selesai, beserta kata sandinya, pengguna akan menerima kotak pesan untuk memasukkan kata sandi jika ingin membuka dalam mode edit atau klik &#8220;Read Only&#8221; untuk membuka dalam mode lihat saja. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-kata sandi-diperlukan-untuk-membuka-dalam-mode-edit\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-mot-de-passe-requis-pour-ouvrir-en-mode-edition.png\" sizes=\"auto, \" srcset=\"\" alt=\"password-required-to-open-in-edit-mode\" width=\"332\" height=\"173\"><\/li><\/ol><h2 id=\"h-make-workbook-ready-only-using-info-option\" class=\"wp-block-heading\"> Siapkan buku kerja hanya menggunakan opsi info<\/h2><ol><li> Pertama, buka tab &#8220;File&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"tab 6-buka-file\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-aller-a-longlet-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-file-tab\" width=\"329\" height=\"179\"><\/li><li> Setelah itu, klik opsi \u201cInfo\u201d, lalu klik \u201cProteksi Buku Kerja\u201d, lalu pilih opsi \u201cSelalu buka sebagai hanya-baca\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-pilih-selalu-buka-baca-saja\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-choisissez-toujours-ouvert-en-lecture-seule.png\" sizes=\"auto, \" srcset=\"\" alt=\"choose-always-open-read-only\" width=\"540\" height=\"381\"><\/li><li> Sekarang mode default buku kerja telah berubah menjadi hanya-baca dan siapa pun yang membuka file ini akan menerima pesan yang menanyakan \u201cBuka file dalam mode Hanya siap sesuai permintaan penulis atau dalam mode dapat diedit saat membuka buku kerja.<\/li><li> Klik &#8220;Ya&#8221; dan itu akan terbuka dalam mode baca-saja, jika tidak, klik &#8220;Tidak&#8221; jika Anda ingin membukanya dalam mode yang dapat diedit. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-pilih-ya-untuk-membuka-dalam-mode-baca-saja\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-choisissez-oui-pour-ouvrir-en-mode-lecture-seule.png\" sizes=\"auto, \" srcset=\"\" alt=\"choose-yes-to-open-in-read-only-mode\" width=\"664\" height=\"118\"><\/li><\/ol><h2 id=\"h-make-workbook-to-ready-only-mode-using-toggle-read-only\" class=\"wp-block-heading\"> Letakkan buku kerja dalam mode siap hanya menggunakan tombol baca-saja<\/h2><p> Beralih ke Baca-Saja adalah cara terbaik dan tercepat untuk mengalihkan buku kerja ke mode baca-saja dan mode dapat diedit kapan saja tanpa membuat salinan buku kerja tersebut.<\/p><ol><li> Pertama, klik tanda \u201cPanah\u201d di \u201cBilah Alat Akses Cepat\u201d dan pilih \u201cPerintah Lainnya\u201d dari menu tarik-turun. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi 9 pesanan lagi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-options-de-commandes-supplementaires.png\" sizes=\"auto, \" srcset=\"\" alt=\"more-commands-option\" width=\"281\" height=\"389\"><\/li><li> Setelah itu, pilih opsi \u201cPerintah tidak ada di pita\u201d di bidang \u201cPilih perintah dari\u201d.<\/li><li> Sekarang, gulir ke bawah dan klik opsi \u201cBeralih ke Hanya Baca\u201d, lalu klik \u201cTambah\u201d untuk menambahkannya ke \u201cBilah Alat Akses Cepat\u201d.<\/li><li> Setelah selesai, klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-tambahkan-toggle-read-only-in-toolbar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-ajouter-une-bascule-en-lecture-seule-dans-la-barre-doutils.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-toggle-read-only-in-toolbar\" width=\"664\" height=\"547\"><\/li><li> Pada titik ini, tombol &#8220;Toggle Read Only&#8221; telah ditambahkan ke &#8220;Quick Access Toolbar&#8221;.<\/li><li> Sekarang, untuk mengaktifkan mode read-only, klik tombol \u201cSwitch to read-only\u201d dan mode buku kerja akan diubah menjadi mode read-only.<\/li><li> Untuk mengaktifkan kembali mode yang dapat diedit, klik tombol \u201cBeralih ke Hanya Baca\u201d lagi. <br><img loading=\"lazy\" decoding=\"async\" title=\"11 tombol sakelar baca-saja\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-basculer-le-bouton-de-lecture-seule.png\" sizes=\"auto, \" srcset=\"\" alt=\"toggle-read-only-button\" width=\"326\" height=\"172\"><\/li><\/ol><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Jika Anda belum menyimpan buku kerja, Excel akan meminta Anda untuk menyimpan perubahan apa pun yang telah Anda buat sebelum mengaktifkan mode baca-saja. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84807\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-enregistrer-les-modifications.png\" sizes=\"auto, \" srcset=\"\" alt=\"Simpan perubahan\" width=\"390\" height=\"133\"><\/figure><\/div><h2 id=\"h-remove-read-only-mode-of-the-file\" class=\"wp-block-heading\"> Hapus mode baca-saja dari file<\/h2><p> Untuk menghapus mode baca-saja dari buku kerja dan membuatnya dapat diedit lagi, Anda perlu membuat salinan buku kerja baru menggunakan &#8220;Simpan Sebagai&#8221; dan saat menyimpan salinan baru Anda perlu menghapus centang pada &#8220;Direkomendasikan hanya-baca&#8221; dari \u00bb Kotak dialog Opsi Umum. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84808\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-supprimer-le-mode-lecture-seule.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus mode baca-saja\" width=\"658\" height=\"346\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/alat-kamera\/\">Alat Kamera Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jendela-arloji\/\">Jendela tontonan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pemotong-excel\/\">Pemotong Excel (Panduan Lengkap)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/excel-secara-default-di-mac\/\">Jadikan Excel Default di Mac<\/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-1927","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>3 Cara Membuat File Read-Only di 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:\/\/exceladvisor.org\/id\/hanya-baca\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 Cara Membuat File Read-Only di Excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hanya-baca\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hanya-baca\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hanya-baca\/\",\"name\":\"3 Cara Membuat File Read-Only di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hanya-baca\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hanya-baca\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png\",\"datePublished\":\"2023-10-27T23:22:27+00:00\",\"dateModified\":\"2023-12-06T06:13:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hanya-baca\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hanya-baca\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hanya-baca\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hanya-baca\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat read-only 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":"3 Cara Membuat File Read-Only di 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:\/\/exceladvisor.org\/id\/hanya-baca\/","og_locale":"id_ID","og_type":"article","og_title":"3 Cara Membuat File Read-Only di Excel","og_url":"https:\/\/exceladvisor.org\/id\/hanya-baca\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/hanya-baca\/","url":"https:\/\/exceladvisor.org\/id\/hanya-baca\/","name":"3 Cara Membuat File Read-Only di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hanya-baca\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hanya-baca\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png","datePublished":"2023-10-27T23:22:27+00:00","dateModified":"2023-12-06T06:13:46+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hanya-baca\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hanya-baca\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hanya-baca\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-enregistrer-en-tant-quoption.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hanya-baca\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat read-only 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\/1927","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=1927"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1927\/revisions"}],"predecessor-version":[{"id":2310,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1927\/revisions\/2310"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1927"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}