{"id":1592,"date":"2023-11-16T01:36:42","date_gmt":"2023-11-16T01:36:42","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/"},"modified":"2023-12-06T06:18:27","modified_gmt":"2023-12-06T06:18:27","slug":"mengubah-posisi-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/","title":{"rendered":"Bagaimana cara mengubah urutan data melalui pintasan excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1436874989\"><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>Transpose adalah fitur dan rumus di Excel yang memungkinkan Anda mengubah urutan data dari baris ke kolom dan sebaliknya.<\/p><p> Jika Anda bekerja dengan data, Anda sering kali perlu mengubah urutan data dari baris ke kolom atau dari kolom ke baris, dan cara terbaik untuk melakukannya adalah dengan menggunakan opsi pintasan keyboard transposisi.<\/p><p> Ada beberapa cara untuk mengubah urutan data, namun dalam tutorial ini kami telah menjelaskan kedua cara menggunakan pintasan keyboard transposisi untuk mengubah urutan data.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk mengubah urutan data di Excel<\/h2><p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>V<\/kbd> \u2192 <kbd>T<\/kbd> <strong>(disarankan)<\/strong> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70471\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.png\" sizes=\"auto, \" srcset=\"\" alt=\"jalan pintas untuk mengubah urutan\" width=\"845\" height=\"331\"><\/figure><\/div><ul><li> <kbd>Ctrl<\/kbd> + <kbd>Alt<\/kbd> + <kbd>V<\/kbd> lalu, <kbd>E<\/kbd> \u2192 <kbd>Enter<\/kbd> (untuk mengubah urutan termasuk pemformatan sel)<\/li><li> <kbd>Ctrl<\/kbd> + <kbd>Alt<\/kbd> + <kbd>V<\/kbd> lalu, <kbd>E<\/kbd> \u2192 <kbd>V<\/kbd> \u2192 <kbd>Enter<\/kbd> (Untuk mengubah urutan data menjadi nilai saja)<\/li><\/ul><h2 class=\"wp-block-heading\"> Langkah-langkah untuk Mengubah Urutan Data Menggunakan Pintasan Keyboard<\/h2><ol><li> Pertama pilih data yang ingin Anda ubah urutannya, lalu tekan tombol \u201cCtrl + C\u201d untuk menyalin data yang dipilih. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-pilih-data\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionnez-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-data\" width=\"567\" height=\"134\"><\/li><li> Setelah itu, masuk ke sel tempat Anda ingin melakukan transpos data yang disalin, lalu tekan tombol \u201cAlt \u2192 H \u2192 V \u2192 T\u201d secara berurutan dan data Anda akan ditempel sebagai transpos. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-transposisi-data\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-donnees-transposees.png\" sizes=\"auto, \" srcset=\"\" alt=\"transposed-data\" width=\"583\" height=\"248\"><\/li><li> Atau, tekan tombol \u201cCtrl + Alt + V\u201d dan Anda akan membuka kotak dialog \u201cTempel Spesial\u201d.<\/li><li> Sekarang tekan &#8220;E&#8221; untuk memeriksa opsi &#8220;Transpose&#8221; dan kemudian tekan tombol &#8220;Enter&#8221;. <em>(Jika ingin mengubah urutan data sebagai nilai saja, tekan &#8220;V&#8221; setelah menekan &#8220;E&#8221; lalu tekan &#8220;Enter&#8221;) <br><img loading=\"lazy\" decoding=\"async\" title=\"Dialog 4 Tempel Khusus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coller-la-boite-de-dialogue-speciale.png\" sizes=\"auto, \" srcset=\"\" alt=\"paste-special-dialog-box\" width=\"620\" height=\"422\"><\/em> <\/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-23\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/\">Referensi mutlak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\">Salin dan tempel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/\">Potong dan tempel<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tempel-nilai\/\">Tempelkan nilai<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pilih-satu-baris\/\">Pilih satu baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pergi-ke\/\">Buka opsi Buka<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">pintasan Excel (lembar contekan PDF)<\/a><\/p><\/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-1592","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 urutan data melalui pintasan Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melakukan transposisi di Excel dan semua informasi yang terkait dengan tombol pintasan.\" \/>\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\/mengubah-posisi-2\/\" \/>\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 urutan data melalui pintasan Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melakukan transposisi di Excel dan semua informasi yang terkait dengan tombol pintasan.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.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\/mengubah-posisi-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/\",\"name\":\"\u25b7 Bagaimana cara mengubah urutan data melalui pintasan Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.png\",\"datePublished\":\"2023-11-16T01:36:42+00:00\",\"dateModified\":\"2023-12-06T06:18:27+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melakukan transposisi di Excel dan semua informasi yang terkait dengan tombol pintasan.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah urutan data melalui 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":"\u25b7 Bagaimana cara mengubah urutan data melalui pintasan Excel?","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melakukan transposisi di Excel dan semua informasi yang terkait dengan tombol pintasan.","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\/mengubah-posisi-2\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengubah urutan data melalui pintasan Excel?","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melakukan transposisi di Excel dan semua informasi yang terkait dengan tombol pintasan.","og_url":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.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\/mengubah-posisi-2\/","url":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/","name":"\u25b7 Bagaimana cara mengubah urutan data melalui pintasan Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.png","datePublished":"2023-11-16T01:36:42+00:00","dateModified":"2023-12-06T06:18:27+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melakukan transposisi di Excel dan semua informasi yang terkait dengan tombol pintasan.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-transposer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah urutan data melalui 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\/1592","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=1592"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1592\/revisions"}],"predecessor-version":[{"id":2726,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1592\/revisions\/2726"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}