{"id":4992,"date":"2023-07-05T10:45:11","date_gmt":"2023-07-05T10:45:11","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/"},"modified":"2023-07-05T10:45:11","modified_gmt":"2023-07-05T10:45:11","slug":"excel-hapus-setiap-tiga-baris","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/","title":{"rendered":"Cara menghapus setiap baris ketiga di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghapus setiap baris ketiga di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda memiliki kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38937 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt1.png\" alt=\"\" width=\"469\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menghapus setiap baris ketiga sehingga hanya menyisakan baris berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38938 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt2.png\" alt=\"\" width=\"465\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ayo pergi!<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 1: Masukkan datanya<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Mari kita mulai dengan memasukkan data berikut ke Excel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38937 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt1.png\" alt=\"\" width=\"469\" height=\"413\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 2: Buat Kolom Dukungan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya ketikkan kata <strong>Delete<\/strong> pada sel <strong>D4<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38939 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt3.png\" alt=\"\" width=\"424\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian sorot rentang <strong>D2:D4<\/strong> . Selanjutnya, klik dan seret ke bawah ke semua sel yang tersisa di kolom D:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38940 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt4.png\" alt=\"\" width=\"456\" height=\"433\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setiap baris ketiga sekarang berisi kata <strong>Delete<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38941 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt5.png\" alt=\"\" width=\"462\" height=\"443\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 3: Tambahkan Filter dan Hapus Baris<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang <strong>A1:D13<\/strong> , lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik ikon <b>Filter<\/b> di grup <strong>Sortir &amp; Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38943 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt7.png\" alt=\"\" width=\"543\" height=\"134\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik panah drop-down di samping kolom <strong>Helper<\/strong> , lalu centang kotak di samping <strong>Delete<\/strong> saja, lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38942 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt6.png\" alt=\"\" width=\"407\" height=\"606\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda klik <strong>OK<\/strong> , hanya baris dengan nilai <strong>Delete<\/strong> pada kolom <strong>Helper<\/strong> yang akan terlihat:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38944 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt8.png\" alt=\"\" width=\"466\" height=\"362\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, sorot empat garis yang terlihat lalu klik kanan. Lalu klik <strong>Hapus Baris<\/strong> di menu drop-down:<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38945 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt9.png\" alt=\"\" width=\"453\" height=\"407\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Terakhir, klik lagi ikon <strong>Filter<\/strong> di tab <strong>Data<\/strong> untuk menghapus filter.<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38943 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt7.png\" alt=\"\" width=\"543\" height=\"134\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Satu-satunya baris yang tersisa adalah baris yang tidak memiliki nilai <strong>Hapus<\/strong> di kolom <strong>Pembantu<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38946 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt10.png\" alt=\"\" width=\"462\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kami sebenarnya menghapus setiap baris ketiga dari kumpulan data asli.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat menghapus kolom <strong>Pembantu<\/strong> jika diinginkan karena kami tidak lagi memerlukannya.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/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\/excel-menghapus-teks-baris-tertentu\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris dengan teks tertentu di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris yang difilter di Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-penghapusan-excel\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus tabel di excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menghapus setiap baris ketiga di Excel. Misalnya, Anda memiliki kumpulan data berikut yang berisi informasi tentang berbagai pemain bola basket: Contoh langkah demi langkah berikut menunjukkan cara menghapus setiap baris ketiga sehingga hanya menyisakan baris berikut: Ayo pergi! Langkah 1: Masukkan datanya Mari kita mulai dengan memasukkan data berikut ke Excel: [&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 Menghapus Setiap Baris Ketiga di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus setiap baris ketiga 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\/excel-hapus-setiap-tiga-baris\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Setiap Baris Ketiga di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus setiap baris ketiga di Excel, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T10:45:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt1.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\/excel-hapus-setiap-tiga-baris\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/\",\"name\":\"Cara Menghapus Setiap Baris Ketiga di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T10:45:11+00:00\",\"dateModified\":\"2023-07-05T10:45:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus setiap baris ketiga di Excel, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus setiap baris ketiga di excel (dengan contoh)\"}]},{\"@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 Menghapus Setiap Baris Ketiga di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghapus setiap baris ketiga 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\/excel-hapus-setiap-tiga-baris\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Setiap Baris Ketiga di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus setiap baris ketiga di Excel, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/","og_site_name":"Statorials","article_published_time":"2023-07-05T10:45:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dt1.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\/excel-hapus-setiap-tiga-baris\/","url":"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/","name":"Cara Menghapus Setiap Baris Ketiga di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T10:45:11+00:00","dateModified":"2023-07-05T10:45:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus setiap baris ketiga di Excel, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-hapus-setiap-tiga-baris\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus setiap baris ketiga di excel (dengan contoh)"}]},{"@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\/4992"}],"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=4992"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4992\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}