{"id":2208,"date":"2023-09-15T01:31:19","date_gmt":"2023-09-15T01:31:19","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/penyelarasan\/"},"modified":"2023-12-06T06:18:20","modified_gmt":"2023-12-06T06:18:20","slug":"penyelarasan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/penyelarasan\/","title":{"rendered":"Bagaimana cara mengubah perataan teks di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3215566176\"><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, perataan membantu Anda menyelaraskan teks dan nilai dalam sel lembar kerja. Secara default, angkanya rata di kanan bawah dan teksnya rata di kiri bawah sel. Dalam tutorial ini, kita akan mempelajari cara menyesuaikan perataan teks dengan dua cara: horizontal dan vertikal.<\/p><h2 class=\"wp-block-heading\"> Ubah perataan menggunakan pita<\/h2><p> Untuk mengubah perataan teks di Excel dari pita.<\/p><ul><li> Pertama, pilih rentang sel yang ingin Anda selaraskan kembali.<\/li><li> Selanjutnya, buka tab Beranda dan pilih grup Alignment. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79600\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilihan penyelarasan\" width=\"520\" height=\"246\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Penjajaran vertikal<\/h2><p> Anda dapat menggunakan opsi berikut untuk menyelaraskan data secara vertikal.<\/p><ol type=\"1\"><li> Top Align \u2013 Memungkinkan Anda untuk menyelaraskan teks serta angka di bagian atas sel.<\/li><li> Tengah \u2013 Menyelaraskan data ke tengah sel.<\/li><li> Bawah \u2013 Ini adalah opsi default, dan menempatkan konten di bagian bawah sel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79601\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-icones-dalignement-vertical.png\" sizes=\"auto, \" srcset=\"\" alt=\"opsi perataan vertikal\" width=\"475\" height=\"234\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Penjajaran horizontal<\/h2><p> Untuk menyelaraskan data secara horizontal, gunakan opsi di bawah:<\/p><ol type=\"1\"><li> Rata Kiri \u2013 Meratakan teks ke tepi kiri sel.<\/li><li> Center- Ini menempatkan teks dan nomor di tengah.<\/li><li> Kanan \u2013 Meratakan konten ke sisi kanan sel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79602\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-options-dalignement-horizontal.png\" sizes=\"auto, \" srcset=\"\" alt=\"opsi perataan horizontal\" width=\"814\" height=\"169\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilihan lain<\/h2><ol type=\"1\"><li> <strong>Orientasi Teks (Putar Teks)<\/strong> : Memungkinkan Anda mengubah orientasi teks secara vertikal atau diagonal.<\/li><li> <strong>Bungkus Teks<\/strong> : Opsi ini membantu Anda membungkus teks panjang menjadi beberapa baris dalam satu sel.<\/li><li> <strong>Keluar<\/strong> : Ada dua keluar dalam grup roster. Saat Anda mengklik ikon Tingkatkan Indentasi, teks Anda akan bergerak lebih jauh ke kanan. Namun, untuk memindahkan teks kembali ke kiri, klik ikon Decrease Indent.<\/li><li> <strong>Merge<\/strong> : Digunakan untuk menggabungkan sel-sel yang dipilih menjadi satu sel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79603\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-options-dorientation-du-texte-et-de-fusion-du-texte-en-retrait.png\" sizes=\"auto, \" srcset=\"\" alt=\"opsi bungkus-teks-indentasi-teks-dan-penggabungan\" width=\"396\" height=\"218\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Ubah Perataan Teks dari Opsi Format Sel<\/h2><p> Cara lain untuk mengubah perataan teks adalah dengan menggunakan kotak dialog Format Sel. Berikut adalah langkah-langkah untuk ini.<\/p><ul><li> Sekali lagi, Anda perlu memilih sel yang ingin Anda selaraskan kembali.<\/li><li> Selanjutnya, buka kotak dialog Format Cells dari panah kanan bawah pada grup Alignment. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79604\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cliquez-sur-la-fleche-en-bas-a-droite.png\" sizes=\"auto, \" srcset=\"\" alt=\"klik panah di kanan bawah\" width=\"582\" height=\"256\"><\/figure><\/div><ul><li> Selanjutnya, pilih tab Alignment di kotak dialog Format Cells. Dalam hal ini, pilih opsi yang diinginkan dari daftar drop-down horizontal dan vertikal untuk menyelaraskan teks. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79605\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Alignement-du-texte-de-la-boite-de-dialogue-de-format-6-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"format-sel-dialog-perataan teks\" width=\"565\" height=\"558\"><\/figure><\/div><ul><li> Sekarang, pilih perataan teks horizontal dan vertikal dari opsi drop-down dan klik tombol OK untuk menerapkannya ke sel yang dipilih.<\/li><\/ul><p> Misalnya, kita memilih \u201cTerdistribusi\u201d pada perataan teks horizontal dan vertikal. Cuplikan di bawah menunjukkan teks didistribusikan secara merata di seluruh tinggi dan lebar dengan menambah spasi antar kata untuk mengisi sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79606\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-alignement-de-texte-distribue.png\" sizes=\"auto, \" srcset=\"\" alt=\"perataan teks terdistribusi\" width=\"618\" height=\"332\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Mengubah arah teks<\/h3><p> Di bagian bawah kotak Format Cells, terdapat opsi untuk mengubah arah teks. Pengaturan defaultnya adalah Konteks, namun Anda dapat mengubahnya dari kiri ke kanan atau kanan ke kiri.<\/p><ul><li> Arah teks default adalah dari kiri ke kanan.<\/li><li> Dan opsi kanan ke kiri digunakan untuk beberapa bahasa tertentu seperti Arab. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79607\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-changer-la-direction-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"perubahan arah teks\" width=\"438\" height=\"218\"><\/figure><\/div><h3 class=\"wp-block-heading\"> Mengubah orientasi teks<\/h3><p> Opsi orientasi teks juga tersedia di kotak dialog Format Sel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79608\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-options-dorientation-du-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"opsi orientasi teks\" width=\"193\" height=\"235\"><\/figure><\/div><p> Digunakan untuk mengubah orientasi dengan memutar teks searah jarum jam, berlawanan arah jarum jam, atas dan bawah. Masukkan angka dari 90 hingga -90 derajat ke dalam kotak atau Anda juga dapat menggunakan penunjuk orientasi untuk mengubah arah teks dan klik OK untuk menerapkan pada sel yang dipilih. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-79609\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-faire-pivoter-le-texte-de-45-degres.png\" sizes=\"auto, \" srcset=\"\" alt=\"putar-teks-45 derajat\" width=\"449\" height=\"234\"><\/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\/pembenaran-lengkap\/\">Isi Justify di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/bilah-rumus-excel\/\">Bilah rumus di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-header-footer\/\">Tambahkan header dan footer di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/penggaris\/\">Tampilkan penggaris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pegangan-pengisian\/\">Isi pegangan di Excel<\/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-2208","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 mengubah perataan teks di Excel?<\/title>\n<meta name=\"description\" content=\"Ini adalah tutorial dasar Microsoft Excel untuk mengubah perataan nilai dalam sel. Selain itu, ada beberapa opsi lain\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\/penyelarasan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengubah perataan teks di Excel?\" \/>\n<meta property=\"og:description\" content=\"Ini adalah tutorial dasar Microsoft Excel untuk mengubah perataan nilai dalam sel. Selain itu, ada beberapa opsi lain\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/penyelarasan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.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\/penyelarasan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/penyelarasan\/\",\"name\":\"\u25b7 Bagaimana cara mengubah perataan teks di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penyelarasan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penyelarasan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.png\",\"datePublished\":\"2023-09-15T01:31:19+00:00\",\"dateModified\":\"2023-12-06T06:18:20+00:00\",\"description\":\"Ini adalah tutorial dasar Microsoft Excel untuk mengubah perataan nilai dalam sel. Selain itu, ada beberapa opsi lain\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/penyelarasan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/penyelarasan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penyelarasan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/penyelarasan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah perataan teks 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 mengubah perataan teks di Excel?","description":"Ini adalah tutorial dasar Microsoft Excel untuk mengubah perataan nilai dalam sel. Selain itu, ada beberapa opsi lain\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\/penyelarasan\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengubah perataan teks di Excel?","og_description":"Ini adalah tutorial dasar Microsoft Excel untuk mengubah perataan nilai dalam sel. Selain itu, ada beberapa opsi lain\u2026","og_url":"https:\/\/exceladvisor.org\/id\/penyelarasan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.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\/penyelarasan\/","url":"https:\/\/exceladvisor.org\/id\/penyelarasan\/","name":"\u25b7 Bagaimana cara mengubah perataan teks di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/penyelarasan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/penyelarasan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.png","datePublished":"2023-09-15T01:31:19+00:00","dateModified":"2023-12-06T06:18:20+00:00","description":"Ini adalah tutorial dasar Microsoft Excel untuk mengubah perataan nilai dalam sel. Selain itu, ada beberapa opsi lain\u2026","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/penyelarasan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/penyelarasan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/penyelarasan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-options-dalignement.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/penyelarasan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah perataan teks 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\/2208","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=2208"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2208\/revisions"}],"predecessor-version":[{"id":2710,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2208\/revisions\/2710"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}