{"id":2100,"date":"2023-10-17T19:47:21","date_gmt":"2023-10-17T19:47:21","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/"},"modified":"2023-12-06T06:15:01","modified_gmt":"2023-12-06T06:15:01","slug":"fokus-pada-seleksi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/","title":{"rendered":"Bagaimana cara memusatkan pilihan di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4038603549\"><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, banyak dari kita yang masih menggunakan fitur &#8220;Gabungkan Sel&#8221; untuk memusatkan teks di beberapa kolom dengan menggabungkan sel, namun ada fitur lain yang disebut &#8220;Pusat Pilihan&#8221; yang juga memungkinkan pengguna memusatkan teks secara horizontal di beberapa kolom. tetapi tanpa menggabungkan sel.<\/p><p> Fitur memusatkan teks tanpa menggabungkan pilihan ini membuatnya lebih disukai untuk digunakan pada sel yang digabungkan karena jika terjadi penggabungan sel, struktur data Anda dapat dimanipulasi dan jika Anda memilih satu kolom yang merupakan bagian dari sel yang digabungkan, kolom lain yang merupakan bagian dari gabungan sel juga akan dipilih.<\/p><p> Dalam tutorial ini, kami akan menunjukkan cara memusatkan teks pada beberapa sel yang dipilih.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Memusatkan Seleksi di Excel<\/h2><ol><li> Pertama, pilih rentang sel yang ingin Anda jadikan pusat teks.<\/li><li> Setelah itu klik kanan lalu klik opsi \u201cFormat Sel\u201d dari daftar drop-down. <br><img loading=\"lazy\" decoding=\"async\" title=\"-pilih-rentang sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-cells-range\" width=\"482\" height=\"391\"><\/li><li> Atau pilih cell rangenya, lalu buka tab &#8220;Home&#8221;, lalu klik &#8220;Alignment Grouping Arrow&#8221; dari grup &#8220;Alignment&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"-sejajarkan-pengelompokan-panah\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-fleche-de-regroupement-dalignement.png\" sizes=\"auto, \" srcset=\"\" alt=\"alignment-grouping-arrow\" width=\"603\" height=\"253\"><\/li><li> Pada titik ini, kotak dialog \u201cFormat Sel\u201d akan terbuka.<\/li><li> Di sini, buka tab \u201cAlignment\u201d, lalu klik panah drop-down pada bidang \u201cHorizontal\u201d dan pilih \u201cCenter on Selection\u201d dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"-pilih-tengah-pada-pilihan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-choisir-le-centre-de-la-selection.png\" sizes=\"auto, \" srcset=\"\" alt=\"choose-center-across-selection\" width=\"514\" height=\"419\"><\/li><li> Sekarang ketika Anda memasukkan teks di sel pertama pilihan, Excel akan menempatkannya \u201cBerpusat pada Pilihan\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"-masukkan-teks-di-sel-pertama-rentang pilihan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-saisir-du-texte-dans-la-premiere-cellule-de-la-plage-de-selection.png\" sizes=\"auto, \" srcset=\"\" alt=\"enter-text-in-first-cell-of-selection-range\" width=\"659\" height=\"140\"><\/li><\/ol><p> Pada gambar di atas terlihat bahwa kita telah memasukkan teks di kolom A dan, Excel dibuat di &#8220;Center on Selection&#8221; dan sepertinya sel-selnya digabungkan tetapi tidak.<\/p><p> Bahkan jika Anda memasukkan teks di salah satu sel pilihan dan bukan di sel pertama, teks akan tetap berada di tengah pilihan, namun pusat tersebut tidak akan menjadi pusat yang tepat.<\/p><h2 class=\"wp-block-heading\"> Pusatkan pilihan menggunakan pintasan keyboard<\/h2><p> Tidak ada pintasan keyboard langsung untuk memusatkan teks pada pilihan, tapi ya, menggunakan kombinasi beberapa pintasan keyboard Anda dapat melakukannya.<\/p><p> <kbd>Ctrl<\/kbd> + <kbd>1<\/kbd> \u2192 <kbd>A<\/kbd> \u2192 <kbd>Tab<\/kbd> \u2192 <kbd>C<\/kbd> \u2192 <kbd>C<\/kbd> \u2192 <kbd>Masuk<\/kbd> \u2192 <kbd>Masuk<\/kbd><\/p><ul><li> Pertama, pilih rentang sel, lalu tekan pintasan \u201cCtrl+1\u201d untuk membuka kotak dialog \u201cFormat Sel\u201d.<\/li><li> Setelah terbuka, cukup tekan &#8220;A&#8221; untuk menavigasi ke tab &#8220;Alignment&#8221; di kotak dialog &#8220;Format Cells&#8221;.<\/li><li> Setelah itu, tekan tombol \u201cTab\u201d untuk menyorot bidang \u201cHorizontal\u201d.<\/li><li> Sekarang, tekan tombol \u201cC\u201d dua kali untuk memilih opsi \u201cCenter on Selection\u201d, lalu tekan tombol \u201cEnter\u201d dua kali.<\/li><\/ul><h2 class=\"wp-block-heading\"> Pusatkan pada seleksi VS gabungkan sel<\/h2><p> Saya yakin Anda telah memperhatikan bahwa perbedaan antara keduanya adalah &#8220;Menggabungkan dan tidak menggabungkan sel&#8221; sambil membuat teks &#8220;Pusat pada pilihan&#8221;.<\/p><p> Sejauh ini saat menulis blog ini kami belum menemukan cara untuk menggunakan &#8220;Seleksi Pusat Di Seluruh&#8221; ini pada pemilihan vertikal.<\/p><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\/mencetak-judul\/\">Terapkan Judul Cetak di Excel (atur baris 1 untuk mencetak di setiap halaman)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kertas-grafik\/\">Cetak kertas grafik di Excel (templat kotak persegi)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-hentian-halaman\/\">Hapus hentian halaman di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengatur-area-cetak\/\">Atur Area Cetak di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/\">Pusatkan lembar kerja secara horizontal dan vertikal 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-2100","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>Bagaimana cara memusatkan pilihan di Excel?<\/title>\n<meta name=\"description\" content=\"Panduan singkat ini akan membantu Anda menggabungkan sel dengan Center Across Selection. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.\" \/>\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\/fokus-pada-seleksi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memusatkan pilihan di Excel?\" \/>\n<meta property=\"og:description\" content=\"Panduan singkat ini akan membantu Anda menggabungkan sel dengan Center Across Selection. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.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\/fokus-pada-seleksi\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/\",\"name\":\"Bagaimana cara memusatkan pilihan di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.png\",\"datePublished\":\"2023-10-17T19:47:21+00:00\",\"dateModified\":\"2023-12-06T06:15:01+00:00\",\"description\":\"Panduan singkat ini akan membantu Anda menggabungkan sel dengan Center Across Selection. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memusatkan pilihan 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":"Bagaimana cara memusatkan pilihan di Excel?","description":"Panduan singkat ini akan membantu Anda menggabungkan sel dengan Center Across Selection. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.","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\/fokus-pada-seleksi\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memusatkan pilihan di Excel?","og_description":"Panduan singkat ini akan membantu Anda menggabungkan sel dengan Center Across Selection. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.","og_url":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:01+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.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\/fokus-pada-seleksi\/","url":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/","name":"Bagaimana cara memusatkan pilihan di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.png","datePublished":"2023-10-17T19:47:21+00:00","dateModified":"2023-12-06T06:15:01+00:00","description":"Panduan singkat ini akan membantu Anda menggabungkan sel dengan Center Across Selection. Kami akan membahasnya dalam langkah-langkah yang mudah diikuti.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-selectionner-la-plage-de-cellules-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/fokus-pada-seleksi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memusatkan pilihan 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\/2100","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=2100"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2100\/revisions"}],"predecessor-version":[{"id":2386,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2100\/revisions\/2386"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}