{"id":4991,"date":"2023-07-05T11:09:15","date_gmt":"2023-07-05T11:09:15","guid":{"rendered":"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/"},"modified":"2023-07-05T11:09:15","modified_gmt":"2023-07-05T11:09:15","slug":"excel-hapus-semua-kolom-lainnya","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/","title":{"rendered":"Cara menghapus semua kolom lainnya di excel (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menghapus semua kolom lain di Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, Anda memiliki kumpulan data berikut yang berisi nilai penjualan toko selama delapan tahun berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38924 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev1.png\" alt=\"\" width=\"612\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menghapus setiap kolom lainnya sehingga hanya tersisa tahun 1, tahun 3, tahun 5, dan tahun 7:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38933 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev9.png\" alt=\"\" width=\"502\" height=\"365\" 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-38924 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev1.png\" alt=\"\" width=\"612\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 2: Sisipkan baris baru<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik kanan pada baris pertama dan klik <strong>Sisipkan<\/strong> di menu tarik-turun:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38925 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev2.png\" alt=\"\" width=\"575\" height=\"517\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya ketik <strong>Keep<\/strong> di sel <strong>A1<\/strong> dan <strong>Hapus<\/strong> di sel <strong>B1<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian sorot sel <strong>A1<\/strong> dan <strong>B1<\/strong> dan seret rumus ke kanan untuk secara otomatis mengisi <strong>Simpan<\/strong> dan <strong>Hapus<\/strong> di sel bergantian:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38926 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev3.png\" alt=\"\" width=\"631\" height=\"374\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 3: Urutkan data dari kiri ke kanan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot rentang <strong>A1:H7<\/strong> , lalu klik tab <strong>Data<\/strong> di sepanjang pita atas, lalu klik ikon <strong>Sortir<\/strong> di grup <strong>Sortir &amp; Filter<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-36361 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excel_sort.png\" alt=\"\" width=\"613\" height=\"135\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Pada jendela Sortir baru yang muncul, klik tombol <strong>Opsi<\/strong> , lalu klik <strong>Urutkan dari Kiri ke Kanan<\/strong> , lalu klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38927 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev4.png\" alt=\"\" width=\"677\" height=\"436\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, pilih <strong>Baris 1<\/strong> di kotak <strong>Urutkan<\/strong> berdasarkan, dan klik <strong>OK<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38928 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev5.png\" alt=\"\" width=\"662\" height=\"517\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Setelah Anda mengklik <strong>OK<\/strong> , kolom akan secara otomatis diurutkan dengan semua kolom <strong>Hapus<\/strong> ditampilkan terlebih dahulu:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-38929\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev6.png\" alt=\"Excel menghapus setiap kolom lainnya\" width=\"611\" height=\"336\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <strong><span style=\"color: #000000;\">Langkah 4: Hapus Kolom<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot empat kolom pertama, lalu klik kanan dan klik <strong>Hapus<\/strong> di menu drop-down:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38930 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev7.png\" alt=\"\" width=\"590\" height=\"541\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Empat kolom pertama akan dihapus dan hanya kolom tahun 1, tahun 3, tahun 5 dan tahun 7 yang akan dipertahankan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-38931 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev8.png\" alt=\"\" width=\"440\" height=\"370\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Jika mau, Anda juga dapat menghapus baris pertama yang berisi nilai <strong>Keep<\/strong> , karena kami hanya membuat baris ini sebagai saluran bantuan untuk mengetahui kolom mana yang harus dipertahankan.<\/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 semua kolom lain di Excel. Misalnya, Anda memiliki kumpulan data berikut yang berisi nilai penjualan toko selama delapan tahun berturut-turut: Contoh langkah demi langkah berikut menunjukkan cara menghapus setiap kolom lainnya sehingga hanya tersisa tahun 1, tahun 3, tahun 5, dan tahun 7: Ayo pergi! Langkah 1: Masukkan datanya Mari [&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 Semua Kolom Lainnya di Excel (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus semua kolom lain di Excel, termasuk 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-hapus-semua-kolom-lainnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menghapus Semua Kolom Lainnya di Excel (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus semua kolom lain di Excel, termasuk contoh lengkapnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-05T11:09:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev1.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-semua-kolom-lainnya\/\",\"url\":\"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/\",\"name\":\"Cara Menghapus Semua Kolom Lainnya di Excel (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-05T11:09:15+00:00\",\"dateModified\":\"2023-07-05T11:09:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus semua kolom lain di Excel, termasuk contoh lengkapnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghapus semua kolom lainnya 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 Semua Kolom Lainnya di Excel (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menghapus semua kolom lain di Excel, termasuk 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-hapus-semua-kolom-lainnya\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menghapus Semua Kolom Lainnya di Excel (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus semua kolom lain di Excel, termasuk contoh lengkapnya.","og_url":"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/","og_site_name":"Statorials","article_published_time":"2023-07-05T11:09:15+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/dev1.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-semua-kolom-lainnya\/","url":"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/","name":"Cara Menghapus Semua Kolom Lainnya di Excel (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-05T11:09:15+00:00","dateModified":"2023-07-05T11:09:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus semua kolom lain di Excel, termasuk contoh lengkapnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/excel-hapus-semua-kolom-lainnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghapus semua kolom lainnya 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\/4991"}],"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=4991"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4991\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}