{"id":1877,"date":"2023-10-30T10:57:01","date_gmt":"2023-10-30T10:57:01","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/"},"modified":"2023-12-06T06:18:37","modified_gmt":"2023-12-06T06:18:37","slug":"urutkan-secara-horizontal","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/","title":{"rendered":"Bagaimana cara mengurutkan secara horizontal di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3965274219\"><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>Pernahkah Anda bertanya-tanya bagaimana cara mengurutkan data secara horizontal di Excel? Maksud saya, Anda dapat mengurutkan kolom seperti Anda mengurutkan baris. Ingin tahu yang terbaik?<\/p><p> Jadi hari ini di artikel ini, saya ingin berbagi dengan Anda langkah sederhana untuk mengurutkan data secara horizontal. Selain itu, saya juga ingin berbagi penyesuaian sederhana yang dapat Anda lakukan untuk mengurutkan kolom dalam urutan khusus.<\/p><p class=\"qt-tip\"> <strong>Catatan Singkat<\/strong> : Ini adalah salah satu <a href=\"https:\/\/exceladvisor.org\/id\/nasihat\/\" data-wpil=\"url\">tips Excel<\/a> yang dapat membantu meningkatkan <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/id\/keterampilan-unggul\/\">keterampilan dasar Excel<\/a> .<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah mengurutkan kolom di Excel<\/h2><ul><li> Pertama, pilih data yang ingin Anda urutkan. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.png\" sizes=\"\" srcset=\"\" alt=\"data yang akan digunakan untuk mengurutkan secara horizontal di excel\"><\/figure><\/div><ul><li> Buka tab Data \u2192 Urutkan &amp; Filter \u2192 Klik tombol Urutkan. Sekarang Anda akan mendapatkan jendela pop-up. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-3-1.png\" sizes=\"\" srcset=\"\" alt=\"buka opsi penyortiran untuk mengurutkan secara horizontal\"><\/figure><\/div><ul><li> Anda juga dapat menggunakan tombol pintas Alt+A+S+S untuk mengurutkan pop-up.<\/li><li> Klik tombol Opsi \u2192 Pilih urutkan dari kiri ke kanan dan klik OK. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-4-1.png\" sizes=\"\" srcset=\"\" alt=\"pilih urutkan dari kiri ke kanan untuk mengurutkan secara horizontal di excel\"><\/figure><\/div><ul><li> Sekarang pilih baris berdasarkan mana Anda ingin mengurutkan data dan klik OK. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-5-1.png\" sizes=\"\" srcset=\"\" alt=\"pilih baris untuk mengurutkan secara horizontal di excel\"><\/figure><\/div><p> Selamat! Anda telah mengurutkan data Anda secara horizontal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-6-1.png\" sizes=\"\" srcset=\"\" alt=\"mengurutkan data secara horizontal dengan teknik sortir kolom pada excel\"><\/figure><\/div><p> Dengan tabel Excel, Anda tidak bisa menggunakan teknik ini.<\/p><h2 class=\"wp-block-heading\"> [Pesanan khusus] Penyortiran horizontal<\/h2><p> Dalam kehidupan nyata, lebih penting untuk mengurutkan kolom dalam urutan khusus daripada menggunakan urutan abjad. Ikuti langkah-langkah sederhana ini.<\/p><ul><li> Tambahkan baris header sementara ke bagian atas kumpulan data Anda dan gunakan angka untuk membuat perintah khusus. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-7-1.png\" sizes=\"\" srcset=\"\" alt=\"Langkah-langkah Mengurutkan Kolom Secara Kustom di Excel\"><\/figure><\/div><ul><li> Sekarang buka jendela pengurutan Anda.<\/li><li> Dan urutkan kolom menggunakan baris sementara Anda sebagai basis.<\/li><li> Setelah itu hapus saja header sementaranya sekarang.<\/li><\/ul><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\/urutkan-berdasarkan-tanggal\/\">Urutkan berdasarkan tanggal, tanggal dan waktu dan urutkan berdasarkan tanggal terbalik<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengacak-daftarnya\/\">Mengacak daftar (mengurutkan secara acak)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/urutkan-rentangnya\/\">Urutkan rentang menggunakan VBA<\/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-1877","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 mengurutkan secara horizontal di Excel? [Menyortir kolom]<\/title>\n<meta name=\"description\" content=\"Ingin mengurutkan kolom di Excel? Mengurutkan kolom di Excel berarti mengurutkan data dari kiri ke kanan [arah horizontal].\" \/>\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\/urutkan-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 mengurutkan secara horizontal di Excel? [Menyortir kolom]\" \/>\n<meta property=\"og:description\" content=\"Ingin mengurutkan kolom di Excel? Mengurutkan kolom di Excel berarti mengurutkan data dari kiri ke kanan [arah horizontal].\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.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\/urutkan-secara-horizontal\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/\",\"name\":\"Bagaimana cara mengurutkan secara horizontal di Excel? [Menyortir kolom]\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.png\",\"datePublished\":\"2023-10-30T10:57:01+00:00\",\"dateModified\":\"2023-12-06T06:18:37+00:00\",\"description\":\"Ingin mengurutkan kolom di Excel? Mengurutkan kolom di Excel berarti mengurutkan data dari kiri ke kanan [arah horizontal].\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengurutkan secara horizontal 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 mengurutkan secara horizontal di Excel? [Menyortir kolom]","description":"Ingin mengurutkan kolom di Excel? Mengurutkan kolom di Excel berarti mengurutkan data dari kiri ke kanan [arah horizontal].","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\/urutkan-secara-horizontal\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengurutkan secara horizontal di Excel? [Menyortir kolom]","og_description":"Ingin mengurutkan kolom di Excel? Mengurutkan kolom di Excel berarti mengurutkan data dari kiri ke kanan [arah horizontal].","og_url":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:37+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.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\/urutkan-secara-horizontal\/","url":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/","name":"Bagaimana cara mengurutkan secara horizontal di Excel? [Menyortir kolom]","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.png","datePublished":"2023-10-30T10:57:01+00:00","dateModified":"2023-12-06T06:18:37+00:00","description":"Ingin mengurutkan kolom di Excel? Mengurutkan kolom di Excel berarti mengurutkan data dari kiri ke kanan [arah horizontal].","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Comment-trier-les-colonnes-de-gauche-a-droite-dans-Excel-2-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/urutkan-secara-horizontal\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengurutkan secara horizontal 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\/1877","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=1877"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1877\/revisions"}],"predecessor-version":[{"id":2748,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1877\/revisions\/2748"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1877"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}