{"id":1832,"date":"2023-10-31T22:52:09","date_gmt":"2023-10-31T22:52:09","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/penarikan\/"},"modified":"2023-12-06T06:15:05","modified_gmt":"2023-12-06T06:15:05","slug":"penarikan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/penarikan\/","title":{"rendered":"Bagaimana cara menambah dan mengurangi indentasi di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1734248219\"><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>Di Excel ada beberapa cara untuk menambah dan mengurangi indentasi dan dalam tutorial ini kita akan mempelajari semua metode tersebut.<\/p><h2 class=\"wp-block-heading\"> Tombol pelepasan pita<\/h2><p> Ada dua tombol yang bisa Anda gunakan untuk menambah atau menghapus indentasi dari sel atau rentang sel. Tombol yang memiliki panah kanan untuk menambahkan indentasi dan berpura-pura memiliki panah kiri untuk menghapus maksud. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61140\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png\" sizes=\"auto, \" srcset=\"\" alt=\"tombol pelepas pita\" width=\"625\" height=\"180\"><\/figure><\/div><ol><li> Pertama, Anda perlu <strong>memilih sel atau rentang sel<\/strong> tempat Anda menambahkan atau menghapus indentasinya.<\/li><li> Setelah itu, buka <strong>tab beranda dan cari tab perataan di sana<\/strong> .<\/li><li> Dari sini, di tab perataan, Anda dapat menggunakan <strong>dua tombol<\/strong> .<\/li><li> Pada akhirnya, klik tombol untuk <strong>menambah atau menghapus indentasi<\/strong> .<\/li><\/ol><p> Anda dapat melihat pada contoh berikut, kami menambahkan indentasi di sel A1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-12941\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-ou-supprimer-retrait.png\" alt=\"menambah atau menghapus penghapusan\" width=\"628\" height=\"335\" srcset=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-ou-supprimer-retrait.png 821w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-ou-supprimer-retrait-300x160.png 300w, https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/ajouter-ou-supprimer-retrait-768x410.png 768w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\"><\/figure><\/div><p> Jika Anda ingin menambahkan beberapa indentasi, Anda harus mengklik tombol tersebut beberapa kali. Artinya jika Anda ingin menambahkan indentasi sebanyak tiga kali, Anda perlu mengklik tombol tersebut sebanyak tiga kali. Dan menghapus indentasi juga terjadi dengan cara yang sama.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk menambahkan indentasi<\/h2><p> Anda juga dapat menggunakan pintasan keyboard untuk menambahkan \u2013 menghapus indentasi dari sel. Ada dua pintasan berbeda untuk menambahkan indentasi penghapusan.<\/p><ul><li> <strong>Tingkatkan indentasi:<\/strong> <kbd>Alt \u279c H \u279c 6<\/kbd><\/li><li> <strong>Kurangi indentasi:<\/strong> <kbd>Alt \u279c H \u279c 5<\/kbd><\/li><\/ul><p> <strong>Terkait: <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">Pintasan Keyboard (Lembar Cheat PDF)<\/a><\/strong><\/p><h2 class=\"wp-block-heading\"> Kode VBA untuk menambahkan indentasi<\/h2><p> Jika Anda <a href=\"https:\/\/exceladvisor.org\/id\/vba\/\">memahami VBA<\/a> , Anda dapat menulis kode yang dapat menambahkan indentasi pada sel yang dipilih, seperti kode berikut.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\"><strong>Sub<\/strong> Macro1() <strong>Dim<\/strong> myInt <strong>As<\/strong> Integer myInt = InputBox(\"how many indents you want to add?\", \"Add Indent\") Selection.InsertIndent myInt <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre><p> Sebelum <a href=\"https:\/\/exceladvisor.org\/id\/jalankan-makro-2\/\">menjalankan kode ini,<\/a> Anda perlu memilih sel yang ingin Anda tambah indentasinya. Ini akan menampilkan kotak input untuk memasukkan nomor penarikan yang ingin Anda tambahkan. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61142\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-vba-pour-ajouter-un-retrait.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-untuk-menambahkan-indentasi\" width=\"474\" height=\"205\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hapus lekukan dari sel<\/h2><p> Seperti yang kita bahas di awal tutorial ini, Anda bisa menggunakan tombol turunkan indentasi untuk menghapus indentasi dari sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61143\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-supprimer-lindentation-de-la-cellule.png\" sizes=\"auto, \" srcset=\"\" alt=\"menghilangkan lekukan sel\" width=\"623\" height=\"179\"><\/figure><\/div><p> Selain itu, Anda dapat menghapus pemformatan sel atau rentang sel untuk menghilangkan lekukan karena ini adalah bagian dari pemformatan sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61144\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-formatage-clair.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus pemformatan\" width=\"582\" height=\"328\"><\/figure><\/div><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\/menarik-garis\/\">Gambar garis di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-tombol\/\">Tambahkan tombol di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-sel-yang-terdisosiasi\/\">Gabung \u2013 memisahkan sel-sel di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pemeriksa-ejaan\/\">Periksa ejaan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/memutar-teks\/\">Memutar teks di Excel (orientasi teks)<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1832","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 menambah dan mengurangi indentasi di Excel?<\/title>\n<meta name=\"description\" content=\"Di Excel ada beberapa cara untuk menambah dan mengurangi indentasi dan dalam tutorial ini kita akan mempelajari semua metode tersebut\" \/>\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\/penarikan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menambah dan mengurangi indentasi di Excel?\" \/>\n<meta property=\"og:description\" content=\"Di Excel ada beberapa cara untuk menambah dan mengurangi indentasi dan dalam tutorial ini kita akan mempelajari semua metode tersebut\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/penarikan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penarikan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/penarikan\/\",\"name\":\"\u25b7 Bagaimana cara menambah dan mengurangi indentasi di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penarikan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penarikan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png\",\"datePublished\":\"2023-10-31T22:52:09+00:00\",\"dateModified\":\"2023-12-06T06:15:05+00:00\",\"description\":\"Di Excel ada beberapa cara untuk menambah dan mengurangi indentasi dan dalam tutorial ini kita akan mempelajari semua metode tersebut\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penarikan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/penarikan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penarikan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penarikan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menambah dan mengurangi indentasi 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 menambah dan mengurangi indentasi di Excel?","description":"Di Excel ada beberapa cara untuk menambah dan mengurangi indentasi dan dalam tutorial ini kita akan mempelajari semua metode tersebut","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\/penarikan\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menambah dan mengurangi indentasi di Excel?","og_description":"Di Excel ada beberapa cara untuk menambah dan mengurangi indentasi dan dalam tutorial ini kita akan mempelajari semua metode tersebut","og_url":"https:\/\/exceladvisor.org\/id\/penarikan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:05+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/penarikan\/","url":"https:\/\/exceladvisor.org\/id\/penarikan\/","name":"\u25b7 Bagaimana cara menambah dan mengurangi indentasi di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/penarikan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/penarikan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png","datePublished":"2023-10-31T22:52:09+00:00","dateModified":"2023-12-06T06:15:05+00:00","description":"Di Excel ada beberapa cara untuk menambah dan mengurangi indentasi dan dalam tutorial ini kita akan mempelajari semua metode tersebut","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/penarikan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/penarikan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/penarikan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boutons-en-retrait-du-ruban.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/penarikan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menambah dan mengurangi indentasi 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\/1832","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=1832"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1832\/revisions"}],"predecessor-version":[{"id":2390,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1832\/revisions\/2390"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}