{"id":1854,"date":"2023-10-31T09:02:59","date_gmt":"2023-10-31T09:02:59","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/"},"modified":"2023-12-06T06:15:02","modified_gmt":"2023-12-06T06:15:02","slug":"posisikan-lembar-kerja-secara-horizontal","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/","title":{"rendered":"Bagaimana cara memusatkan spreadsheet di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-396012611\"><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, saat Anda membuka spreadsheet, Anda bisa memasukkan data dari kiri ke kanan. Lembar kerja disejajarkan ke kiri secara horizontal dan disejajarkan ke atas secara vertikal.<\/p><p> Namun Anda bisa menyelaraskan data pada lembar kerja ke tengah secara horizontal dan ke tengah secara vertikal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72534\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.png\" sizes=\"auto, \" srcset=\"\" alt=\"dialog tata letak\" width=\"485\" height=\"468\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-Langkah Membuat Spreadsheet Berpusat Horizontal<\/h2><ol><li> Pertama, buka tab Layout dan klik menu drop-down opsi margin. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-Klik Dropdown Opsi Margin\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Liste-deroulante-des-options-de-marge-en-2-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-margin-option-dropdown\" width=\"506\" height=\"209\"><\/li><li> Sekarang dari margin klik opsi margin khusus. Ini membuka kotak dialog tata letak. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi margin khusus dalam 3 klik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Options-de-marge-personnalisees-en-3-clics.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-custom-margin-options\" width=\"549\" height=\"537\"><\/li><li> Setelah itu, pada kotak dialog pengaturan halaman, centang opsi bagian tengah halaman (secara horizontal dan vertikal). Saat Anda melakukan ini, Anda akan melihat, ini menunjukkan kepada Anda bahwa data di lembar kerja sekarang berada secara horizontal di tengah dan vertikal di tengah. <br><img loading=\"lazy\" decoding=\"async\" title=\"4 pilihan tanda centang secara horizontal dan vertikal\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-options-de-coche-horizontalement-et-verticalement.png\" sizes=\"auto, \" srcset=\"\" alt=\"tickmark-horizontally-and-vertically-options\" width=\"536\" height=\"517\"><\/li><li> Pada akhirnya, klik OK untuk menyimpan pengaturan ini.<\/li><\/ol><p> Ini tidak akan mengubah data yang Anda miliki di spreadsheet, tetapi ketika Anda mencetaknya, itu akan dilakukan secara horizontal di tengah dan vertikal di tengah.<\/p><h2 class=\"wp-block-heading\"> Menggunakan Opsi Pratinjau Cetak untuk Membuat Spreadsheet Berpusat Horizontal<\/h2><p> Opsi yang sama dapat diubah dari opsi pratinjau cetak.<\/p><ol type=\"1\"><li> Buka tab File dan klik opsi Cetak.<\/li><li> Setelah itu, klik &#8220;Pengaturan Halaman&#8221;.<\/li><li> Sekarang klik pada tab Margin.<\/li><li> Selanjutnya, centang kotak secara horizontal dan vertikal.<\/li><li> Pada akhirnya, klik OK untuk menyimpan pengaturan. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72538\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-creer-une-feuille-de-calcul-horizontalement.png\" sizes=\"auto, \" srcset=\"\" alt=\"membuat-lembar kerja-secara horizontal\" width=\"710\" height=\"510\"><\/figure><\/div><p> Ini adalah opsi yang sama yang kami gunakan pada metode pertama, hanya saja cara membukanya berbeda.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard<\/h2><p> Jika Anda ingin membuat spreadsheet secara horizontal di tengah, gunakan <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">pintasan keyboard<\/a> untuk membuka tata letak, lalu terapkan pengaturan:<\/p><p> <kbd>Alt<\/kbd> \u21e2 <kbd>P<\/kbd> \u21e2 <kbd>S<\/kbd> \u21e2 <kbd>P<\/kbd> \u21e2 <kbd>M<\/kbd><\/p><p> Saat Anda menekan tombol pintasan ini, kotak dialog tata letak dan tab margin akan terbuka.<\/p><p> Dan dari situ Anda bisa menerapkan pengaturan untuk membuat lembar kerja Anda secara horizontal di tengah dan vertikal di tengah.<\/p><p> Seperti yang saya katakan sebelumnya, ketika Anda menerapkan pengaturan ini, itu tidak akan membuat perubahan apa pun pada data di lembar kerja, tetapi akan mengubah perataan yang Anda miliki saat mencetaknya.<\/p><p> Anda juga melihat pengaturan ini di <a href=\"https:\/\/exceladvisor.org\/id\/pratinjau-cetak-1\/\">pratinjau cetak<\/a> .<\/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><\/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-1854","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 spreadsheet di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara membuat spreadsheet secara horizontal di tengah dan vertikal di tengah\" \/>\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\/posisikan-lembar-kerja-secara-horizontal\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara memusatkan spreadsheet di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara membuat spreadsheet secara horizontal di tengah dan vertikal di tengah\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.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\/posisikan-lembar-kerja-secara-horizontal\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/\",\"name\":\"Bagaimana cara memusatkan spreadsheet di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.png\",\"datePublished\":\"2023-10-31T09:02:59+00:00\",\"dateModified\":\"2023-12-06T06:15:02+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara membuat spreadsheet secara horizontal di tengah dan vertikal di tengah\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memusatkan spreadsheet 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 spreadsheet di Excel? (Tutorial 2023)","description":"Dalam tutorial ini, kita akan mempelajari cara membuat spreadsheet secara horizontal di tengah dan vertikal di tengah","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\/posisikan-lembar-kerja-secara-horizontal\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara memusatkan spreadsheet di Excel? (Tutorial 2023)","og_description":"Dalam tutorial ini, kita akan mempelajari cara membuat spreadsheet secara horizontal di tengah dan vertikal di tengah","og_url":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:02+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.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\/posisikan-lembar-kerja-secara-horizontal\/","url":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/","name":"Bagaimana cara memusatkan spreadsheet di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.png","datePublished":"2023-10-31T09:02:59+00:00","dateModified":"2023-12-06T06:15:02+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara membuat spreadsheet secara horizontal di tengah dan vertikal di tengah","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-boite-de-dialogue-de-mise-en-page.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/posisikan-lembar-kerja-secara-horizontal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memusatkan spreadsheet 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\/1854","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=1854"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1854\/revisions"}],"predecessor-version":[{"id":2387,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1854\/revisions\/2387"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}