{"id":2695,"date":"2023-07-21T03:29:01","date_gmt":"2023-07-21T03:29:01","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/"},"modified":"2023-07-21T03:29:01","modified_gmt":"2023-07-21T03:29:01","slug":"excel-menghapus-baris-yang-difilter","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/","title":{"rendered":"Cara menghapus baris yang difilter di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Seringkali, Anda mungkin ingin menghapus baris tertentu setelah memfilternya di Excel.<\/span><\/span><\/p>\n

Untungnya, hal ini mudah dilakukan dan contoh berikut menunjukkan cara melakukannya dalam praktik.<\/span><\/p>\n

Contoh: Hapus Baris yang Difilter di Excel<\/strong><\/span><\/h3>\n

Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang 10 pemain bola basket:<\/span><\/p>\n

\"\"<\/span><\/p>\n

Katakanlah kita ingin menghapus semua baris yang mengandung “Penjaga” di kolom Posisi.<\/span><\/p>\n

Pertama, kita dapat menerapkan filter untuk hanya menampilkan baris yang mengandung \u201cPenjaga\u201d.<\/span><\/p>\n

Untuk melakukannya, klik tab Data<\/strong> di sepanjang pita atas, lalu klik tombol Filter<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Lalu klik panah drop-down di sebelah Position<\/strong> , centang kotak di sebelah Guard<\/strong> , lalu klik OK<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Data akan secara otomatis disaring untuk hanya menampilkan baris yang kolom Posisinya berisi \u201cPenjaga\u201d:<\/span><\/span><\/p>\n

\"\"<\/span><\/p>\n

Selanjutnya, sorot setiap baris. Selanjutnya, klik kanan pada baris mana pun dan klik Hapus Baris<\/strong> dari menu drop-down:<\/span> <\/p>\n

\"\"<\/p>\n

Semua garis yang terlihat akan dihapus.<\/span><\/p>\n

Terakhir, cukup klik tombol Filter<\/strong> sekali lagi untuk mematikan filter.<\/span><\/p>\n

Satu-satunya baris yang tersisa adalah baris dengan \u201cMaju\u201d di kolom Posisi<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Sumber daya tambahan<\/strong><\/span><\/h3>\n

Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Excel:<\/span><\/p>\n

Bagaimana cara mengganti nilai #N\/A di Excel<\/a>
Cara menginterpolasi nilai yang hilang di Excel<\/a>
Cara menghitung duplikat di excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Seringkali, Anda mungkin ingin menghapus baris tertentu setelah memfilternya di Excel. Untungnya, hal ini mudah dilakukan dan contoh berikut menunjukkan cara melakukannya dalam praktik. Contoh: Hapus Baris yang Difilter di Excel Misalkan kita memiliki kumpulan data berikut yang berisi informasi tentang 10 pemain bola basket: Katakanlah kita ingin menghapus semua baris yang mengandung “Penjaga” di […]<\/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":"\nCara Menghapus Baris yang Difilter di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus baris yang difilter di Excel, dengan contoh lengkap.\" \/>\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-menghapus-baris-yang-difilter\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Baris yang Difilter di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus baris yang difilter di Excel, dengan contoh lengkap.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T03:29:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/delfilt1.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-menghapus-baris-yang-difilter\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/\",\"name\":\"Cara Menghapus Baris yang Difilter di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T03:29:01+00:00\",\"dateModified\":\"2023-07-21T03:29:01+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus baris yang difilter di Excel, dengan contoh lengkap.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus baris yang difilter 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 Baris yang Difilter di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghapus baris yang difilter di Excel, dengan contoh lengkap.","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-menghapus-baris-yang-difilter\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Baris yang Difilter di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus baris yang difilter di Excel, dengan contoh lengkap.","og_url":"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/","og_site_name":"Statorials","article_published_time":"2023-07-21T03:29:01+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/delfilt1.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-menghapus-baris-yang-difilter\/","url":"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/","name":"Cara Menghapus Baris yang Difilter di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T03:29:01+00:00","dateModified":"2023-07-21T03:29:01+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus baris yang difilter di Excel, dengan contoh lengkap.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghapus-baris-yang-difilter\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus baris yang difilter 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\/2695"}],"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=2695"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2695\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2695"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2695"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2695"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}