{"id":5070,"date":"2023-07-04T05:33:54","date_gmt":"2023-07-04T05:33:54","guid":{"rendered":"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/"},"modified":"2023-07-04T05:33:54","modified_gmt":"2023-07-04T05:33:54","slug":"opsi-daftar-drop-down-excel-kosong","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/","title":{"rendered":"Excel: cara menambahkan opsi kosong di daftar drop-down"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin ingin membuat daftar drop-down di Excel dengan opsi kosong yang bisa Anda pilih.<\/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 data<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki data di Excel tentang jumlah poin yang dicetak oleh seorang pemain bola basket di tim tertentu dan kita ingin memberikan salah satu peringkat berikut kepada seorang pemain:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Tidak ada peringkat (kosong)<\/span><\/li>\n<li> <span style=\"color: #000000;\">BAGUS<\/span><\/li>\n<li> <span style=\"color: #000000;\">BAIKLAH<\/span><\/li>\n<li> <span style=\"color: #000000;\">Buruk<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Misalnya, kita mungkin memiliki data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39508 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte1.png\" alt=\"\" width=\"438\" height=\"323\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tetapkan opsi tarik-turun<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, ketikkan sel kosong dengan <strong>Good<\/strong> , <strong>OK<\/strong> dan <strong>Bad<\/strong> dalam rentang <strong>F1:F4<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39521 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dropblank1.png\" alt=\"\" width=\"536\" height=\"349\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan digunakan pada langkah berikutnya sebagai opsi potensial yang dapat dipilih dari daftar drop-down.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 3: Buat daftar drop-down dengan opsi kosong<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, pilih sel <strong>C2<\/strong> , lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Validasi Data<\/strong> di grup <strong>Alat Data<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39509 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/la-validation-des-donnees.png\" alt=\"\" width=\"552\" height=\"193\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada kotak baru yang muncul, pilih <strong>List<\/strong> dari menu drop-down <strong>Allow<\/strong> , lalu pilih <strong>F1:F4<\/strong> untuk <strong>Source<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-39522\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dropblank2.png\" alt=\"Daftar tarik-turun Excel dengan opsi kosong\" width=\"568\" height=\"518\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , daftar drop-down akan secara otomatis ditambahkan ke sel <strong>C2<\/strong> dengan opsi kosong, Baik, OK, dan Buruk:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-39523 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dropblank3.png\" alt=\"\" width=\"526\" height=\"368\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda memilih opsi pertama dari daftar drop-down, nilai di sel <strong>C2<\/strong> akan kosong.<\/span><\/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 operasi umum lainnya di Excel:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dengan-warna\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara membuat daftar drop-down dengan warna<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/daftar-dropdown-excel-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara membuat daftar drop-down dari lembar lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/isi-otomatis-excel-dari-daftar\/\" target=\"_blank\" rel=\"noopener\">Excel: Cara mengisi otomatis menggunakan daftar kustom<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin ingin membuat daftar drop-down di Excel dengan opsi kosong yang bisa Anda pilih. Contoh langkah demi langkah berikut menunjukkan cara melakukan hal ini. Langkah 1: Buat data Misalkan kita memiliki data di Excel tentang jumlah poin yang dicetak oleh seorang pemain bola basket di tim tertentu dan kita ingin memberikan salah satu [&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: Cara menambahkan opsi kosong di daftar drop-down - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan opsi kosong ke daftar drop-down di Excel, dengan contoh langkah demi langkah.\" \/>\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\/opsi-daftar-drop-down-excel-kosong\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel: Cara menambahkan opsi kosong di daftar drop-down - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan opsi kosong ke daftar drop-down di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-04T05:33:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte1.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\/opsi-daftar-drop-down-excel-kosong\/\",\"url\":\"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/\",\"name\":\"Excel: Cara menambahkan opsi kosong di daftar drop-down - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-04T05:33:54+00:00\",\"dateModified\":\"2023-07-04T05:33:54+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan opsi kosong ke daftar drop-down di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel: cara menambahkan opsi kosong di daftar drop-down\"}]},{\"@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: Cara menambahkan opsi kosong di daftar drop-down - Statologi","description":"Tutorial ini menjelaskan cara menambahkan opsi kosong ke daftar drop-down di Excel, dengan contoh langkah demi langkah.","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\/opsi-daftar-drop-down-excel-kosong\/","og_locale":"id_ID","og_type":"article","og_title":"Excel: Cara menambahkan opsi kosong di daftar drop-down - Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan opsi kosong ke daftar drop-down di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/","og_site_name":"Statorials","article_published_time":"2023-07-04T05:33:54+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/couleurgoutte1.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\/opsi-daftar-drop-down-excel-kosong\/","url":"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/","name":"Excel: Cara menambahkan opsi kosong di daftar drop-down - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-04T05:33:54+00:00","dateModified":"2023-07-04T05:33:54+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan opsi kosong ke daftar drop-down di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/opsi-daftar-drop-down-excel-kosong\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Excel: cara menambahkan opsi kosong di daftar drop-down"}]},{"@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\/5070"}],"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=5070"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/5070\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=5070"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=5070"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=5070"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}