{"id":2690,"date":"2023-07-21T04:00:56","date_gmt":"2023-07-21T04:00:56","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/"},"modified":"2023-07-21T04:00:56","modified_gmt":"2023-07-21T04:00:56","slug":"excel-ganti-sel-kosong-dengan-nol","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/","title":{"rendered":"Bagaimana cara mengganti sel kosong dengan nol di excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk mengganti sel kosong dengan angka nol di Excel adalah dengan menggunakan fungsi <strong>Go To Special<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Ganti sel kosong dengan nol di Excel<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kumpulan data berikut yang menunjukkan poin yang dicetak oleh tim bola basket yang berbeda:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23690 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerblank1-1.jpg\" alt=\"\" width=\"466\" height=\"417\" srcset=\"\" sizes=\"\"><\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalkan kita ingin mengganti sel kosong di kolom Poin dengan angka nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, ketik <strong>Ctrl+G<\/strong> untuk menampilkan jendela <strong>Go To<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23691 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerblank2.jpg\" alt=\"\" width=\"478\" height=\"392\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik tombol <strong>Spesial<\/strong> di pojok kiri bawah jendela <strong>Go to<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela baru yang muncul, pilih <strong>Blanks<\/strong> lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23692\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerblank3.jpg\" alt=\"ganti yang kosong dengan nol di Excel\" width=\"535\" height=\"455\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap nilai kosong di kolom Poin akan otomatis disorot:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23693 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerblank4.jpg\" alt=\"\" width=\"458\" height=\"439\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, masukkan nilai <strong>0<\/strong> di bilah rumus dan tekan <strong>Ctrl+Enter<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23694 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerblank5.jpg\" alt=\"\" width=\"462\" height=\"462\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap sel kosong di kolom Poin akan otomatis diganti dengan angka nol.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Penting untuk menekan <strong>Ctrl+Enter<\/strong> setelah mengetikkan angka nol sehingga setiap sel kosong diisi dengan angka nol, bukan hanya sel kosong pertama yang dipilih.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/excel-ganti-na\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti nilai #N\/A di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/interpolasi-nilai-yang-hilang-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menginterpolasi nilai yang hilang di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghitung-duplikat\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung duplikat di excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk mengganti sel kosong dengan angka nol di Excel adalah dengan menggunakan fungsi Go To Special . Contoh berikut menunjukkan cara menggunakan fungsi ini dalam praktiknya. Contoh: Ganti sel kosong dengan nol di Excel Misalkan kita memiliki kumpulan data berikut yang menunjukkan poin yang dicetak oleh tim bola basket yang berbeda: Misalkan kita [&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>Cara Mengganti Sel Kosong dengan Nol di Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti sel kosong dengan nol di Excel, beserta contoh lengkapnya.\" \/>\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\/excel-ganti-sel-kosong-dengan-nol\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengganti Sel Kosong dengan Nol di Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti sel kosong dengan nol di Excel, beserta contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T04:00:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerblank1-1.jpg\" \/>\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\/excel-ganti-sel-kosong-dengan-nol\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/\",\"name\":\"Cara Mengganti Sel Kosong dengan Nol di Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T04:00:56+00:00\",\"dateModified\":\"2023-07-21T04:00:56+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti sel kosong dengan nol di Excel, beserta contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengganti sel kosong dengan nol di excel\"}]},{\"@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":"Cara Mengganti Sel Kosong dengan Nol di Excel \u2013 Statologi","description":"Tutorial ini menjelaskan cara mengganti sel kosong dengan nol di Excel, beserta contoh lengkapnya.","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\/excel-ganti-sel-kosong-dengan-nol\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengganti Sel Kosong dengan Nol di Excel \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara mengganti sel kosong dengan nol di Excel, beserta contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/","og_site_name":"Statorials","article_published_time":"2023-07-21T04:00:56+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacerblank1-1.jpg"}],"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\/excel-ganti-sel-kosong-dengan-nol\/","url":"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/","name":"Cara Mengganti Sel Kosong dengan Nol di Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T04:00:56+00:00","dateModified":"2023-07-21T04:00:56+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti sel kosong dengan nol di Excel, beserta contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-ganti-sel-kosong-dengan-nol\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengganti sel kosong dengan nol di excel"}]},{"@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\/2690"}],"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=2690"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2690\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2690"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2690"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}