{"id":1589,"date":"2023-11-16T06:38:44","date_gmt":"2023-11-16T06:38:44","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hapus-baris\/"},"modified":"2023-12-06T06:19:10","modified_gmt":"2023-12-06T06:19:10","slug":"hapus-baris","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hapus-baris\/","title":{"rendered":"Bagaimana cara menghapus baris menggunakan pintasan excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2404467096\"><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>Saat bekerja di Excel, pengguna sering kali ingin menghapus baris yang tidak perlu atau tidak diinginkan agar datanya jelas dan bersih. Untuk ini, Excel memiliki opsi untuk menghapus baris kapan saja.<\/p><p> Menghapus baris semudah menambahkan baris di Excel dan baris tersebut dapat dihapus secara manual atau menggunakan pintasan keyboard.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk menghapus baris di Excel<\/h2><p> Pintasan keyboard untuk menghapus garis seperti di bawah ini dan dapat digunakan dengan dua cara. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67529\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan-untuk-menghapus-baris\" width=\"816\" height=\"320\"><\/figure><\/div><p> Ctrl + tanda minus (-)<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah untuk menghapus baris menggunakan pintasan keyboard<\/h2><ol><li> Pertama, tekan tombol pintas \u201cShift + Spacebar\u201d untuk memilih seluruh baris, lalu cukup tekan \u201cCtrl + tanda minus (-) untuk menghapus baris yang dipilih tersebut.<\/li><li> Atau, klik sel mana pun di baris yang ingin Anda hapus dan tekan tombol pintasan \u201cCtrl + tanda minus (-)\u201d.<\/li><li> Jika Anda memiliki beberapa baris tidak berurutan untuk dihapus, tahan tombol \u201cCtrl\u201d dan klik sel mana pun di setiap baris satu per satu yang ingin Anda hapus, lalu tekan tombol pintasan \u201cCtrl + tanda kurangi (-)\u201d . <br><img loading=\"lazy\" decoding=\"async\" title=\"2-pilih-beberapa sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionner-les-multiples-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-multiple-cells\" width=\"544\" height=\"235\"><\/li><li> Setelah itu, kotak dialog \u201cHapus\u201d akan terbuka dan menggunakan tombol panah bawah, pilih tombol radio \u201cSemua Baris\u201d.<\/li><li> Sekarang tekan tombol &#8220;Enter&#8221; dan Anda akan menghapus baris-baris ini. <br><img decoding=\"async\" title=\"3-pilih-seluruh baris\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-la-ligne-entiere.png\" sizes=\"\" srcset=\"\" alt=\"select-entire-row\"><\/li><\/ol><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-79\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-kolom-1\/\">Tambahkan kolom<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-sel\/\">Hapus sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengedit-sel\/\">Sunting Sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/\">Tampilkan kolom<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/masukkan-sel\/\">Masukkan sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/\">Sisipkan \u2013 Tambahkan baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-sel-yang-terdisosiasi-1\/\">Gabungkan-pisahkan sel<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">pintasan Excel (lembar contekan PDF)<\/a><\/p><\/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-1589","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 menggunakan pintasan Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus baris di lembar kerja di Excel.\" \/>\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-baris\/\" \/>\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 menggunakan pintasan Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus baris di lembar kerja di Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hapus-baris\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.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-baris\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hapus-baris\/\",\"name\":\"\u25b7 Bagaimana cara menghapus baris menggunakan pintasan Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-baris\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-baris\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.png\",\"datePublished\":\"2023-11-16T06:38:44+00:00\",\"dateModified\":\"2023-12-06T06:19:10+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus baris di lembar kerja di Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-baris\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hapus-baris\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-baris\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-baris\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus baris menggunakan pintasan 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 menggunakan pintasan Excel?","description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus baris di lembar kerja di Excel.","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-baris\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghapus baris menggunakan pintasan Excel?","og_description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus baris di lembar kerja di Excel.","og_url":"https:\/\/exceladvisor.org\/id\/hapus-baris\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.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-baris\/","url":"https:\/\/exceladvisor.org\/id\/hapus-baris\/","name":"\u25b7 Bagaimana cara menghapus baris menggunakan pintasan Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-baris\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-baris\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.png","datePublished":"2023-11-16T06:38:44+00:00","dateModified":"2023-12-06T06:19:10+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus baris di lembar kerja di Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-baris\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hapus-baris\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hapus-baris\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-supprimer-la-ligne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hapus-baris\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus baris menggunakan pintasan 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\/1589","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=1589"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1589\/revisions"}],"predecessor-version":[{"id":2817,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1589\/revisions\/2817"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1589"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}