{"id":4877,"date":"2023-07-06T22:53:06","date_gmt":"2023-07-06T22:53:06","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/"},"modified":"2023-07-06T22:53:06","modified_gmt":"2023-07-06T22:53:06","slug":"excel-menghapus-subtotal","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/","title":{"rendered":"Cara menghapus subtotal di excel (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda bisa menggunakan tombol Hapus Semua<\/strong> di fungsi Subtotal<\/strong> grup Garis Besar<\/strong> pada tab Data<\/strong> untuk menghapus subtotal dari lembar di Excel.<\/span><\/p>\n

Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini.<\/span><\/p>\n

Contoh: Cara Menghapus Subtotal di Excel<\/strong><\/span><\/h2>\n

Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span> <\/p>\n

\"\"<\/p>\n

Perhatikan bahwa kumpulan data saat ini memiliki baris subtotal untuk menampilkan total poin yang dicetak oleh masing-masing tim.<\/span><\/p>\n

Untuk menghapus subtotal ini, sorot rentang A1:B17<\/strong> , lalu klik tab Data<\/strong> di sepanjang pita atas, lalu klik ikon Subtotal<\/strong> di grup Garis Besar<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Di jendela baru yang muncul, klik tombol Hapus Semua<\/strong> di sudut kiri bawah untuk menghapus semua subtotal dan pemformatan dari kumpulan data:<\/span> <\/p>\n

\"Excel<\/p>\n

Setelah Anda mengklik tombol ini, semua baris subtotal dan format subtotal akan dihapus dari kumpulan data:<\/span> <\/p>\n

\"\"<\/p>\n

Jika Anda ingin mempertahankan baris subtotal namun menghapus pengelompokannya, Anda dapat mengklik panah di samping Pisahkan<\/strong> di grup Garis Besar<\/strong> pada tab Data<\/strong> , lalu klik Hapus Garis Besar<\/strong> :<\/span> <\/p>\n

\"\"<\/p>\n

Pengelompokan akan dihapus tetapi baris subtotalnya akan tetap ada:<\/span> <\/p>\n

\"\"<\/p>\n

Jangan ragu untuk menggunakan metode apa pun yang Anda inginkan, bergantung pada apakah Anda ingin menghapus subtotal dan pengelompokan atau hanya pengelompokan saja.<\/span><\/p>\n

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

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

Cara menggunakan SUBTOTAL dengan AVERAGEIF di Excel<\/a>
Cara menggunakan SUBTOTAL dengan SUMIF di Excel<\/a>
Cara menggunakan SUBTOTAL dengan COUNTIF di Excel<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Anda bisa menggunakan tombol Hapus Semua di fungsi Subtotal grup Garis Besar pada tab Data untuk menghapus subtotal dari lembar di Excel. Contoh berikut menunjukkan dengan tepat bagaimana melakukan hal ini. Contoh: Cara Menghapus Subtotal di Excel Misalkan kita memiliki kumpulan data berikut di Excel yang berisi informasi tentang poin yang dicetak oleh pemain bola […]<\/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 Subtotal di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus subtotal dari lembar di Excel, 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\/excel-menghapus-subtotal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Subtotal di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus subtotal dari lembar di Excel, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-06T22:53:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsub2.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-menghapus-subtotal\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/\",\"name\":\"Cara Menghapus Subtotal di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-06T22:53:06+00:00\",\"dateModified\":\"2023-07-06T22:53:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus subtotal dari lembar di Excel, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus subtotal 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 Subtotal di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghapus subtotal dari lembar di Excel, 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\/excel-menghapus-subtotal\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Subtotal di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus subtotal dari lembar di Excel, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/","og_site_name":"Statorials","article_published_time":"2023-07-06T22:53:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/rsub2.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-menghapus-subtotal\/","url":"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/","name":"Cara Menghapus Subtotal di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-06T22:53:06+00:00","dateModified":"2023-07-06T22:53:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus subtotal dari lembar di Excel, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-menghapus-subtotal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus subtotal 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\/4877"}],"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=4877"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4877\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4877"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4877"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}