{"id":2077,"date":"2023-10-20T06:06:43","date_gmt":"2023-10-20T06:06:43","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/"},"modified":"2023-12-06T06:19:14","modified_gmt":"2023-12-06T06:19:14","slug":"masukkan-garis","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/","title":{"rendered":"Bagaimana cara menyisipkan baris menggunakan pintasan excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3297043167\"><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>Memasukkan atau menambahkan baris di Excel adalah tugas yang mudah jika Anda mengetahui pintasannya. Seringkali saat bekerja di Excel, pengguna ingin menambahkan baris kosong dan mereka bisa menambahkannya dengan sangat cepat menggunakan pintasan keyboard alih-alih membuka ikon &#8220;Sisipkan&#8221; di bawah tab &#8220;Beranda&#8221;.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk menyisipkan baris baru di Excel<\/h2><p> <kbd>Alt<\/kbd> \u2192 <kbd>Saya<\/kbd> \u2192 <kbd>R<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67505\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan untuk menambahkan baris\" width=\"790\" height=\"310\"><\/figure><\/div><p> <kbd>Ctrl<\/kbd> + <kbd>Shift<\/kbd> <kbd>++<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67506\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-touche-de-raccourci-pour-ajouter-une-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"tombol pintas-untuk-menambahkan-baris\" width=\"786\" height=\"308\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah Menambahkan Baris Menggunakan Pintasan Keyboard<\/h2><h3 class=\"wp-block-heading\"> 1. Menggunakan pintasan keyboard Alt \u2192 I \u2192 R<\/h3><ol><li> Pertama, klik sel mana pun di baris di atasnya yang ingin Anda tambahkan baris kosong baru. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-klik-di-sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cliquez-sur-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-on-the-cell\" width=\"459\" height=\"210\"><\/li><li> Setelah itu, cukup tekan \u201cAlt \u2192 I \u2192 R\u201d dan Anda akan mendapatkan baris baru yang disisipkan di atas sel yang dipilih. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-baris-baru-ditambahkan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-nouvelle-ligne-ajoutee.png\" sizes=\"auto, \" srcset=\"\" alt=\"added-new-row\" width=\"465\" height=\"232\"><\/li><\/ol><h3 class=\"wp-block-heading\"> 2. Menggunakan pintasan keyboard Ctrl + Shift + Tanda Plus (+)<\/h3><ol><li> Pertama, pilih baris menggunakan pintasan keyboard \u201cShift + Spasi\u201d di atasnya yang ingin Anda tambahkan baris kosong baru. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-pilih-baris\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionnez-la-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-row\" width=\"485\" height=\"220\"><\/li><li> Setelah itu, tekan tombol pintas \u201cCtrl + Shift + Tanda Plus (+) dan Anda akan mendapatkan baris kosong baru yang disisipkan di atas baris yang dipilih. <br><img loading=\"lazy\" decoding=\"async\" title=\"Pintasan 6 tekan untuk menambahkan garis\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-appuyez-sur-le-raccourci-pour-ajouter-une-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"press-shortcut-to-add-row\" width=\"494\" height=\"250\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Kesimpulan<\/h2><ol><li> Excel selalu menambahkan baris di atas baris atau sel yang dipilih, kita tidak bisa mengubah pengaturan default ini.<\/li><li> Setelah Anda menambahkan baris, Anda cukup menekan tombol \u201cFn + F4\u201d untuk membuat Excel mengulangi tugas menambahkan lebih banyak baris kosong.<\/li><li> Jika Anda memiliki beberapa kumpulan data di lembar yang sama, konversikan kumpulan data tersebut ke dalam tabel karena Excel menyisipkan baris dari kolom A ke akhir kolom di lembar kecuali Anda memiliki data di tabel, yang mungkin mengacaukan kumpulan data lainnya. <\/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-75\"><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\/hapus-baris\/\">Hapus baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengedit-sel\/\">Sunting Sel<\/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-2077","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>Apa pintasan keyboard untuk menyisipkan baris baru?<\/title>\n<meta name=\"description\" content=\"Mari pelajari cara menggunakan pintasan keyboard untuk menambahkan baris ke lembar kerja di Excel. Mari kita periksa ini\u2026\" \/>\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\/masukkan-garis\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apa pintasan keyboard untuk menyisipkan baris baru?\" \/>\n<meta property=\"og:description\" content=\"Mari pelajari cara menggunakan pintasan keyboard untuk menambahkan baris ke lembar kerja di Excel. Mari kita periksa ini\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-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\/masukkan-garis\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/\",\"name\":\"Apa pintasan keyboard untuk menyisipkan baris baru?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-ligne.png\",\"datePublished\":\"2023-10-20T06:06:43+00:00\",\"dateModified\":\"2023-12-06T06:19:14+00:00\",\"description\":\"Mari pelajari cara menggunakan pintasan keyboard untuk menambahkan baris ke lembar kerja di Excel. Mari kita periksa ini\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-ligne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-ligne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyisipkan 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":"Apa pintasan keyboard untuk menyisipkan baris baru?","description":"Mari pelajari cara menggunakan pintasan keyboard untuk menambahkan baris ke lembar kerja di Excel. Mari kita periksa ini\u2026","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\/masukkan-garis\/","og_locale":"id_ID","og_type":"article","og_title":"Apa pintasan keyboard untuk menyisipkan baris baru?","og_description":"Mari pelajari cara menggunakan pintasan keyboard untuk menambahkan baris ke lembar kerja di Excel. Mari kita periksa ini\u2026","og_url":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:14+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-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\/masukkan-garis\/","url":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/","name":"Apa pintasan keyboard untuk menyisipkan baris baru?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-ligne.png","datePublished":"2023-10-20T06:06:43+00:00","dateModified":"2023-12-06T06:19:14+00:00","description":"Mari pelajari cara menggunakan pintasan keyboard untuk menambahkan baris ke lembar kerja di Excel. Mari kita periksa ini\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/masukkan-garis\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-ligne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-ajouter-une-ligne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/masukkan-garis\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyisipkan 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\/2077","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=2077"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2077\/revisions"}],"predecessor-version":[{"id":2826,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2077\/revisions\/2826"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}