{"id":402,"date":"2023-10-30T10:57:01","date_gmt":"2023-10-30T10:57:01","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/"},"modified":"2023-12-06T11:35:15","modified_gmt":"2023-12-06T11:35:15","slug":"classificar-horizontalmente","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/","title":{"rendered":"Como classificar horizontalmente no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-1192292596\"><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><div class=\"excel-before-content\" id=\"excel-3539651791\"><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>Voc\u00ea j\u00e1 se perguntou como classificar dados horizontalmente no Excel? Quero dizer, voc\u00ea pode classificar colunas da mesma forma que classifica linhas. Quer saber o melhor?<\/p><p> Ent\u00e3o, hoje neste artigo, gostaria de compartilhar com voc\u00eas uma etapa simples para classificar dados horizontalmente. Al\u00e9m disso, gostaria de compartilhar um ajuste simples que voc\u00ea pode fazer para classificar as colunas em ordem personalizada.<\/p><p class=\"qt-tip\"> <strong>Nota r\u00e1pida<\/strong> : Esta \u00e9 uma daquelas <a href=\"https:\/\/exceladvisor.org\/pt\/conselho\/\" data-wpil=\"url\">dicas do Excel<\/a> que podem ajudar a melhorar <a style=\"outline: none;\" href=\"https:\/\/exceladvisor.org\/pt\/habilidades-de-excelencia\/\">as habilidades b\u00e1sicas do Excel<\/a> .<\/p><h2 class=\"wp-block-heading\"> Etapas para classificar colunas no Excel<\/h2><ul><li> Primeiro, selecione os dados que deseja classificar. <\/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=\"dados a serem usados para classificar horizontalmente no Excel\"><\/figure><\/div><ul><li> V\u00e1 para a guia Dados \u2192 Classificar e Filtrar \u2192 Clique no bot\u00e3o Classificar. Agora voc\u00ea receber\u00e1 uma janela 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=\"abra op\u00e7\u00f5es de classifica\u00e7\u00e3o para classificar horizontalmente\"><\/figure><\/div><ul><li> Voc\u00ea tamb\u00e9m pode usar a tecla de atalho Alt+A+S+S para classificar pop-ups.<\/li><li> Clique no bot\u00e3o Op\u00e7\u00f5es \u2192 Selecione classificar da esquerda para a direita e clique em 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=\"selecione classificar da esquerda para a direita para classificar horizontalmente no Excel\"><\/figure><\/div><ul><li> Agora selecione a linha com base na qual deseja classificar seus dados e clique em 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=\"selecione a linha para classificar horizontalmente no Excel\"><\/figure><\/div><p> Parab\u00e9ns! Voc\u00ea classificou seus dados horizontalmente. <\/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=\"classificar dados horizontalmente com classificar colunas na t\u00e9cnica Excel\"><\/figure><\/div><p> Com tabelas do Excel, voc\u00ea n\u00e3o pode usar esta t\u00e9cnica.<\/p><h2 class=\"wp-block-heading\"> [Ordem personalizada] Classifica\u00e7\u00e3o horizontal<\/h2><p> Na vida real, \u00e9 mais necess\u00e1rio classificar suas colunas em uma ordem personalizada do que em ordem alfab\u00e9tica. Siga estes passos simples.<\/p><ul><li> Adicione uma linha de cabe\u00e7alho tempor\u00e1ria ao topo do seu conjunto de dados e use n\u00fameros para criar um comando personalizado. <\/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=\"Etapas para classificar colunas personalizadas no Excel\"><\/figure><\/div><ul><li> Agora abra sua janela de classifica\u00e7\u00e3o.<\/li><li> E classifique as colunas usando sua linha tempor\u00e1ria como base.<\/li><li> Depois disso, basta remover o cabe\u00e7alho tempor\u00e1rio agora.<\/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\/pt\/nocoes-basicas-de-excel\/\">No\u00e7\u00f5es b\u00e1sicas do Microsoft Excel (componentes, pe\u00e7as e notas de conhecimento)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/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\/pt\/classificar-por-data\/\">Classifique por data, data e hora e classifique por data reversa<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/randomizar-a-lista\/\">Randomizar uma lista (classifica\u00e7\u00e3o aleat\u00f3ria)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/classificar-o-intervalo\/\">Classificar intervalo usando 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-402","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>Como classificar horizontalmente no Excel? [Classificando colunas]<\/title>\n<meta name=\"description\" content=\"Quer classificar colunas no Excel? Classificar colunas no Excel significa classificar os dados da esquerda para a direita [dire\u00e7\u00e3o 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\/pt\/classificar-horizontalmente\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como classificar horizontalmente no Excel? [Classificando colunas]\" \/>\n<meta property=\"og:description\" content=\"Quer classificar colunas no Excel? Classificar colunas no Excel significa classificar os dados da esquerda para a direita [dire\u00e7\u00e3o horizontal].\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:35:15+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=\"Tempo estimado de leitura\" \/>\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\/pt\/classificar-horizontalmente\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/\",\"name\":\"Como classificar horizontalmente no Excel? [Classificando colunas]\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/classificar-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-06T11:35:15+00:00\",\"description\":\"Quer classificar colunas no Excel? Classificar colunas no Excel significa classificar os dados da esquerda para a direita [dire\u00e7\u00e3o horizontal].\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/classificar-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\/pt\/classificar-horizontalmente\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como classificar horizontalmente no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como classificar horizontalmente no Excel? [Classificando colunas]","description":"Quer classificar colunas no Excel? Classificar colunas no Excel significa classificar os dados da esquerda para a direita [dire\u00e7\u00e3o 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\/pt\/classificar-horizontalmente\/","og_locale":"pt_PT","og_type":"article","og_title":"Como classificar horizontalmente no Excel? [Classificando colunas]","og_description":"Quer classificar colunas no Excel? Classificar colunas no Excel significa classificar os dados da esquerda para a direita [dire\u00e7\u00e3o horizontal].","og_url":"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:35:15+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":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/","url":"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/","name":"Como classificar horizontalmente no Excel? [Classificando colunas]","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/classificar-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-06T11:35:15+00:00","description":"Quer classificar colunas no Excel? Classificar colunas no Excel significa classificar os dados da esquerda para a direita [dire\u00e7\u00e3o horizontal].","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/classificar-horizontalmente\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/classificar-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\/pt\/classificar-horizontalmente\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como classificar horizontalmente no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=402"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/402\/revisions"}],"predecessor-version":[{"id":891,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/402\/revisions\/891"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}