{"id":403,"date":"2023-10-30T10:57:01","date_gmt":"2023-10-30T10:57:01","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/"},"modified":"2023-12-25T10:26:37","modified_gmt":"2023-12-25T10:26:37","slug":"ordenar-horizontalmente","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/","title":{"rendered":"\u00bfc\u00f3mo ordenar horizontalmente en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1433067307\"><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>\u00bfAlguna vez te has preguntado c\u00f3mo ordenar datos horizontalmente en Excel? Quiero decir, puedes ordenar columnas como ordenas filas. \u00bfQuieres saber lo mejor?<\/p>\n<p> Por eso, hoy en este art\u00edculo, me gustar\u00eda compartir con ustedes un paso sencillo para ordenar datos horizontalmente. Y aparte de eso, tambi\u00e9n me gustar\u00eda compartir un ajuste simple que puedes hacer para ordenar las columnas en orden personalizado.<\/p>\n<p class=\"qt-tip\"> <strong>Nota r\u00e1pida<\/strong> : Este es uno de esos <a href=\"https:\/\/exceladvisor.org\/es\/consejo\/\" data-wpil=\"url\">consejos de Excel<\/a> que pueden ayudar a mejorar <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/es\/habilidades-de-sobresalir\/\">las habilidades b\u00e1sicas de Excel<\/a> .<\/p>\n<h2 class=\"wp-block-heading\"> Pasos para ordenar columnas en Excel<\/h2>\n<ul>\n<li> Primero, seleccione los datos que desea ordenar. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"Datos a utilizar para ordenar horizontalmente en Excel.\"><\/figure>\n<\/div>\n<ul>\n<li> Vaya a la pesta\u00f1a Datos \u2192 Ordenar y filtrar \u2192 Haga clic en el bot\u00f3n Ordenar. Ahora aparecer\u00e1 una ventana emergente. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"abrir opciones de clasificaci\u00f3n para ordenar horizontalmente\"><\/figure>\n<\/div>\n<ul>\n<li> Tambi\u00e9n puede utilizar la tecla de acceso directo Alt+A+S+S para ordenar las ventanas emergentes.<\/li>\n<li> Haga clic en el bot\u00f3n Opciones \u2192 Seleccione ordenar de izquierda a derecha y haga clic en Aceptar. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"seleccione ordenar de izquierda a derecha para ordenar horizontalmente en Excel\"><\/figure>\n<\/div>\n<ul>\n<li> Ahora seleccione la fila seg\u00fan la cual desea ordenar sus datos y haga clic en Aceptar. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"seleccione la fila para ordenar horizontalmente en Excel\"><\/figure>\n<\/div>\n<p> \u00a1Felicidades! Ha ordenado sus datos horizontalmente. <\/p>\n<div class=\"wp-block-image\">\n<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=\"ordenar datos horizontalmente con ordenar columnas en la t\u00e9cnica de Excel\"><\/figure>\n<\/div>\n<p> Con tablas de Excel, no puedes utilizar esta t\u00e9cnica.<\/p>\n<h2 class=\"wp-block-heading\"> [Orden personalizado] Clasificaci\u00f3n horizontal<\/h2>\n<p> En la vida real, es m\u00e1s necesario ordenar las columnas en un orden personalizado que en orden alfab\u00e9tico. Siga estos sencillos pasos.<\/p>\n<ul>\n<li> Agregue una fila de encabezado temporal en la parte superior de su conjunto de datos y use n\u00fameros para crear un comando personalizado. <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<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=\"Pasos para ordenar columnas personalizadas en Excel\"><\/figure>\n<\/div>\n<ul>\n<li> Ahora abre tu ventana de clasificaci\u00f3n.<\/li>\n<li> Y ordene las columnas usando su fila temporal como base.<\/li>\n<li> Despu\u00e9s de eso, simplemente elimine el encabezado temporal ahora.<\/li>\n<\/ul>\n<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\/es\/conceptos-basicos-de-excel\/\">Conceptos b\u00e1sicos de Microsoft Excel (componentes, piezas y notas de conocimiento)<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ordenar-por-fecha\/\">Ordenar por fecha, fecha y hora y ordenar por fecha inversa<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/aleatorizar-la-lista\/\">Aleatorizar una lista (clasificaci\u00f3n aleatoria)<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ordenar-el-rango\/\">Ordenar rango usando VBA<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-50067b57\">\n<div class=\"gb-container gb-container-50067b57\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfAlguna vez te has preguntado c\u00f3mo ordenar datos horizontalmente en Excel? Quiero decir, puedes ordenar columnas como ordenas filas. \u00bfQuieres saber lo mejor? Por eso, hoy en este art\u00edculo, me gustar\u00eda compartir con ustedes un paso sencillo para ordenar datos horizontalmente. Y aparte de eso, tambi\u00e9n me gustar\u00eda compartir un ajuste simple que puedes hacer [&hellip;]<\/p>\n","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-403","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>\u00bfc\u00f3mo ordenar horizontalmente en excel?<\/title>\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\/es\/ordenar-horizontalmente\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo ordenar horizontalmente en excel?\" \/>\n<meta property=\"og:description\" content=\"\u00bfAlguna vez te has preguntado c\u00f3mo ordenar datos horizontalmente en Excel? Quiero decir, puedes ordenar columnas como ordenas filas. \u00bfQuieres saber lo mejor? Por eso, hoy en este art\u00edculo, me gustar\u00eda compartir con ustedes un paso sencillo para ordenar datos horizontalmente. Y aparte de eso, tambi\u00e9n me gustar\u00eda compartir un ajuste simple que puedes hacer [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:26: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=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/\",\"name\":\"\u00bfc\u00f3mo ordenar horizontalmente en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#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-25T10:26:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#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\/es\/ordenar-horizontalmente\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo ordenar horizontalmente en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo ordenar horizontalmente en excel?","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\/es\/ordenar-horizontalmente\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo ordenar horizontalmente en excel?","og_description":"\u00bfAlguna vez te has preguntado c\u00f3mo ordenar datos horizontalmente en Excel? Quiero decir, puedes ordenar columnas como ordenas filas. \u00bfQuieres saber lo mejor? Por eso, hoy en este art\u00edculo, me gustar\u00eda compartir con ustedes un paso sencillo para ordenar datos horizontalmente. Y aparte de eso, tambi\u00e9n me gustar\u00eda compartir un ajuste simple que puedes hacer [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:26: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":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/","url":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/","name":"\u00bfc\u00f3mo ordenar horizontalmente en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#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-25T10:26:37+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/ordenar-horizontalmente\/#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\/es\/ordenar-horizontalmente\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo ordenar horizontalmente en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/403","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=403"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/403\/revisions"}],"predecessor-version":[{"id":1151,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/403\/revisions\/1151"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=403"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}