{"id":4718,"date":"2023-07-08T15:39:53","date_gmt":"2023-07-08T15:39:53","guid":{"rendered":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/"},"modified":"2023-07-08T15:39:53","modified_gmt":"2023-07-08T15:39:53","slug":"daftar-dropdown-excel-dari-lembar-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/","title":{"rendered":"Excel: buat daftar drop-down dari lembar lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin membuat daftar drop-down di lembar Excel menggunakan nilai dari lembar lain.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Buat daftar nilai<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin pengguna dapat memasukkan data untuk tim bola basket yang berbeda ke dalam Excel <strong>Sheet 1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36841 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano1.png\" alt=\"\" width=\"472\" height=\"379\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk memastikan bahwa pengguna hanya memasukkan nama tim tertentu, kami akan menentukan daftar nama tim yang valid di <strong>Sheet2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36842 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano2.png\" alt=\"\" width=\"486\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Buat nama untuk daftar drop-down<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kami kemudian akan menyorot rentang sel <strong>A1:A7<\/strong> di <strong>Sheet2<\/strong> dan klik kanan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Klik <strong>Tetapkan Nama<\/strong> dari menu tarik-turun, lalu masukkan <strong>Teams<\/strong> di kotak <strong>Nama<\/strong> . Lalu klik <strong>oke<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36846 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano6.png\" alt=\"\" width=\"429\" height=\"466\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Gunakan validasi data untuk membuat daftar drop-down<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin pengguna dapat memasukkan salah satu nama tim dari daftar di <strong>Sheet2<\/strong> dalam rentang <strong>A2:A10<\/strong> di <strong>Sheet1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menyorot rentang <strong>A2:A10<\/strong> di <strong>Sheet1<\/strong> , lalu klik ikon <strong>Validasi Data<\/strong> di grup <strong>Alat Data<\/strong> di tab <strong>Data<\/strong> di sepanjang pita atas:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36844 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano4.png\" alt=\"\" width=\"517\" height=\"248\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Di jendela baru yang muncul, klik panah tarik-turun di samping <strong>Izinkan<\/strong> dan pilih <strong>Daftar<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian ketik <strong>=teams<\/strong> di kotak <strong>Sumber<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36847 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano7.png\" alt=\"\" width=\"555\" height=\"517\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik <strong>OK<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sekarang, ketika Anda mengklik salah satu sel dalam rentang <strong>A2:A10<\/strong> , panah drop-down akan muncul di mana pengguna dapat memilih salah satu nama tim dalam daftar <strong>Sheet2<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36848 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano8.png\" alt=\"\" width=\"475\" height=\"382\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hal ini memastikan hanya tujuh nama tim dari <strong>Lembar 2<\/strong> yang dapat dimasukkan di kolom A.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika pengguna mencoba memasukkan nama tim lain secara manual yang tidak terdaftar, Excel akan menghasilkan pesan kesalahan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36849 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano9.png\" alt=\"\" width=\"531\" height=\"305\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-dari-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengisi otomatis menggunakan daftar kustom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sorot-excel-jika-ada-dalam-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: cara menyorot sel jika nilainya ada dalam daftar<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/unggul-jika-dalam-daftar-maka-ya\/\" target=\"_blank\" rel=\"noopener\">Excel: cari nilai dalam daftar dan kembalikan ya atau tidak<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin membuat daftar drop-down di lembar Excel menggunakan nilai dari lembar lain. Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Buat daftar nilai Katakanlah kita ingin pengguna dapat memasukkan data untuk tim bola basket yang berbeda ke dalam Excel Sheet 1 : Untuk memastikan bahwa pengguna hanya memasukkan [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel: buat daftar drop-down dari lembar lain - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel menggunakan nilai dari sheet lain, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: buat daftar drop-down dari lembar lain - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel menggunakan nilai dari sheet lain, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-08T15:39:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano1.png\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/\",\"name\":\"Excel: buat daftar drop-down dari lembar lain - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-08T15:39:53+00:00\",\"dateModified\":\"2023-07-08T15:39:53+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel menggunakan nilai dari sheet lain, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: buat daftar drop-down dari lembar lain\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel: buat daftar drop-down dari lembar lain - Statorials","description":"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel menggunakan nilai dari sheet lain, dengan sebuah contoh.","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:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: buat daftar drop-down dari lembar lain - Statorials","og_description":"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel menggunakan nilai dari sheet lain, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-08T15:39:53+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ano1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/","url":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/","name":"Excel: buat daftar drop-down dari lembar lain - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-08T15:39:53+00:00","dateModified":"2023-07-08T15:39:53+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat daftar drop-down di Excel menggunakan nilai dari sheet lain, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: buat daftar drop-down dari lembar lain"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4718"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=4718"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4718\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4718"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4718"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4718"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}