{"id":1630,"date":"2023-11-14T19:39:30","date_gmt":"2023-11-14T19:39:30","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/"},"modified":"2023-12-06T06:19:11","modified_gmt":"2023-12-06T06:19:11","slug":"hapus-kolom-baris-tersembunyi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/","title":{"rendered":"Bagaimana cara menghapus baris tersembunyi di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3776033056\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Terkadang saat mengerjakan data Excel, pengguna menyembunyikan beberapa baris dan kolom yang tidak ingin mereka lihat, dan kemudian setelah menyiapkan data, menghapus beberapa baris dan kolom tersembunyi dalam data adalah tugas yang membosankan.<\/p><p> Untuk mengatasinya, Excel memiliki fungsi bawaan untuk menemukan dan menghapus baris dan kolom tersembunyi sekaligus. Berikut beberapa langkah cepat dan mudah untuk menghapus semua baris atau kolom tersembunyi di Excel. <\/p><h2 id=\"delete-all-hidden-rows-or-columns-in-excel-using-inspect-document\" class=\"wp-block-heading\">Hapus semua baris atau kolom tersembunyi di Excel menggunakan Inspect Document<\/h2><ol><li> Pertama, klik pada tab &#8220;File&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-file-tab\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"file-tab\" width=\"544\" height=\"120\"><\/li><li> Setelah itu, klik \u201cInfo\u201d di menu konteks, lalu klik \u201cPeriksa Masalah\u201d dan kemudian \u201cPeriksa Dokumen\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-periksa-dokumen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-inspecter-le-document.png\" sizes=\"auto, \" srcset=\"\" alt=\"inspect-document\" width=\"602\" height=\"506\"><\/li><li> Setelah Anda mengklik &#8220;Periksa Dokumen&#8221;, Excel membuka menu &#8220;Pemeriksa Dokumen&#8221;.<\/li><li> Sekarang Anda hanya perlu mengklik tombol \u201cPeriksa\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-inspektur-dokumen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-inspecteur-de-documents.png\" sizes=\"auto, \" srcset=\"\" alt=\"document-inspector\" width=\"450\" height=\"417\"><\/li><li> Terakhir, klik \u201cHapus Semua\u201d di pilihan \u201cBaris dan Kolom Tersembunyi\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-hapus-semua\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-supprimer-tout.png\" sizes=\"auto, \" srcset=\"\" alt=\"remove-all\" width=\"452\" height=\"421\"><\/li><li> Pada titik ini, semua baris atau kolom tersembunyi di Excel telah dihapus. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-baris-dan-kolom tersembunyi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-et-colonnes-masquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"hidden-rows-and-columns\" width=\"451\" height=\"415\"><\/li><\/ol><h2 id=\"delete-all-hidden-rows-or-column-using-vba-macros\" class=\"wp-block-heading\"> Hapus semua baris atau kolom tersembunyi menggunakan VBA<\/h2><p> Dalam dua kode berikut, Anda dapat menghapus baris dan kolom dari rentang bekas yang disembunyikan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub delete_hidden_columns() Dim ws As Worksheet Dim iCol As Integer Set ws = ActiveSheet iCol = ws.UsedRange.Columns(ws.UsedRange.Columns.Count).Column For i = iCol To 1 Step -1 If Columns(i).Hidden = True Then Columns(i).EntireColumn.Delete Next End Sub '------------------------------------------------- Sub delete_hidden_rows() Dim ws As Worksheet Dim iRow As Integer Set ws = ActiveSheet iRow = ws.UsedRange.Columns(ws.UsedRange.Rows.Count).Row For i = iRow To 1 Step -1 If Rows(i).Hidden = True Then Rows(i).EntireRow.Delete Next End Sub<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Microsoft Excel (Komponen, Bagian dan Catatan Pengetahuan)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-hapus-hyperlink\/\">Tambahkan dan hapus hyperlink di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-tanda-air\/\">Tambahkan tanda air di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/\">Batalkan pilihan sel di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-kolom\/\">Tambahkan kolom di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-garis\/\">Hapus satu baris atau beberapa baris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kolom-salin\/\">Salin dan tempel kolom di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/memindahkan-kolom-baris\/\">Pindahkan baris dan kolom di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/lebar-kolom\/\">Cara mengubah lebar kolom di excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1630","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Bagaimana cara menghapus baris tersembunyi di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menghapus semua baris dan kolom tersembunyi menggunakan dua metode berbeda.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menghapus baris tersembunyi di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menghapus semua baris dan kolom tersembunyi menggunakan dua metode berbeda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/\",\"name\":\"\u25b7 Bagaimana cara menghapus baris tersembunyi di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\",\"datePublished\":\"2023-11-14T19:39:30+00:00\",\"dateModified\":\"2023-12-06T06:19:11+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menghapus semua baris dan kolom tersembunyi menggunakan dua metode berbeda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus baris tersembunyi di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u25b7 Bagaimana cara menghapus baris tersembunyi di Excel?","description":"Dalam tutorial ini, Anda akan mempelajari cara menghapus semua baris dan kolom tersembunyi menggunakan dua metode berbeda.","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:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghapus baris tersembunyi di Excel?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menghapus semua baris dan kolom tersembunyi menggunakan dua metode berbeda.","og_url":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/","url":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/","name":"\u25b7 Bagaimana cara menghapus baris tersembunyi di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png","datePublished":"2023-11-14T19:39:30+00:00","dateModified":"2023-12-06T06:19:11+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menghapus semua baris dan kolom tersembunyi menggunakan dua metode berbeda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus baris tersembunyi di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1630"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1630\/revisions"}],"predecessor-version":[{"id":2819,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1630\/revisions\/2819"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}