{"id":569,"date":"2018-06-18T10:49:22","date_gmt":"2018-06-18T10:49:22","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=569"},"modified":"2021-10-04T12:10:21","modified_gmt":"2021-10-04T12:10:21","slug":"merge-fileiras-e-colunas-dentro-excel","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel","title":{"rendered":"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<blockquote><p><span style=\"text-decoration: underline;\"><strong>Resumo:<\/strong><\/span><\/p>\n<p style=\"text-align: justify;\"><strong>Mesclar linhas e colunas no Excel parece uma tarefa dif\u00edcil para voc\u00ea? Leia este tutorial para aprender diferentes maneiras de mesclar linhas e colunas no Excel.<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify;\"><!--more--><\/p>\n<p style=\"text-align: justify;\">O Microsoft Excel \u00e9 um aplicativo muito \u00fatil e pode ser usado para realizar v\u00e1rias tarefas. Este \u00e9 o motivo pelo qual o Excel fornece v\u00e1rias fun\u00e7\u00f5es \u00fateis para tornar a tarefa mais f\u00e1cil para os usu\u00e1rios.<\/p>\n<p style=\"text-align: justify;\">Uma das tarefas mais comuns que todos precisam realizar de vez em quando \u00e9 <strong>mesclar linhas e colunas.<\/strong><\/p>\n<p style=\"text-align: justify;\">Mas o problema \u00e9 que fazer isso n\u00e3o \u00e9 uma tarefa f\u00e1cil e Excel n\u00e3o fornece nenhuma ferramenta para fazer isso.<\/p>\n<p style=\"text-align: justify;\">Isso \u00e9 bastante complicado, pois mesclar linhas e colunas em alguns casos causa perda de dados.<\/p>\n<p style=\"text-align: justify;\">Como ao tentar combinar duas ou mais linhas na planilha usando o bot\u00e3o Mesclar e Centralizar (guia Home&gt; grupo Alinhamento), voc\u00ea come\u00e7ar\u00e1 a receber a mensagem de erro:<\/p>\n<blockquote><p><span style=\"color: #ff0000;\"><em><strong>&#8220;A sele\u00e7\u00e3o cont\u00e9m v\u00e1rios valores de dados. A fus\u00e3o em uma c\u00e9lula manter\u00e1 apenas os dados mais \u00e0 esquerda.&#8221;<\/strong><\/em><\/span><\/p><\/blockquote>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-589\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/selection-contains-multiple-data.png\" alt=\"A sele\u00e7\u00e3o cont\u00e9m v\u00e1rios valores de dados\" width=\"597\" height=\"158\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/selection-contains-multiple-data.png 597w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/selection-contains-multiple-data-300x79.png 300w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><\/p>\n<p style=\"text-align: justify;\">E se voc\u00ea clicar em OK, as c\u00e9lulas mescladas conter\u00e3o apenas o valor da c\u00e9lula superior esquerda e, como resultado, todos os outros dados ser\u00e3o removidos.<\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o \u00e9 isso que te leva \u00e0 situa\u00e7\u00e3o de p\u00e2nico !!!<\/p>\n<p style=\"text-align: justify;\">Para se livrar disso, hoje neste artigo estou compartilhando diferentes maneiras de mesclar linhas e colunas facilmente no Excel sem perder nenhum dado.<\/p>\n<p style=\"text-align: justify;\">Abaixo, verifique as corre\u00e7\u00f5es sobre <strong>como mesclar linhas no Excel<\/strong> ou<strong> como mesclar colunas no Excel.<\/strong><\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Como mesclar linhas e colunas no Excel sem perder dados?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Existem diferentes m\u00e9todos para combinar texto de linhas e colunas no Excel. Aqui, verifique as maneiras, uma a uma, de mesclar dados sem perd\u00ea-los. Primeiro, verifique como mesclar linhas no Excel.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Parte 1 # Como mesclar linhas no Excel<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-588\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-rows-excel.png\" alt=\"Como mesclar linhas no Excel\" width=\"531\" height=\"251\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-rows-excel.png 531w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-rows-excel-300x142.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<p style=\"text-align: justify;\">Quando se trata de mesclar as linhas do Excel, h\u00e1 duas maneiras que permitem mesclar os dados das linhas facilmente.<\/p>\n<ol>\n<li style=\"text-align: justify;\">Mesclar linhas do Excel usando uma f\u00f3rmula<\/li>\n<li style=\"text-align: justify;\">Combine v\u00e1rias linhas usando o suplemento Merge Cells<\/li>\n<\/ol>\n<h3><span style=\"text-decoration: underline;\"><strong>1. Como mesclar v\u00e1rias linhas usando f\u00f3rmulas do Excel<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">O Excel fornece v\u00e1rias f\u00f3rmulas que ajudam voc\u00ea a combinar dados de linhas diferentes. Possivelmente, o mais f\u00e1cil \u00e9 a fun\u00e7\u00e3o CONCATENAR. Ent\u00e3o, aqui verifica alguns exemplos para concatenar v\u00e1rias linhas em uma:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Mesclar linhas com espa\u00e7os entre dados: Por exemplo = CONCATENATE (B1, \u201d\u201c, B2, \u201d\u201c, B3)<\/li>\n<li>Combine linhas sem qualquer espa\u00e7o entre os valores: Por exemplo = CONCATENATE (A1, A2, A3)<\/li>\n<li>Mesclar linhas&gt; separe os valores com v\u00edrgula: Por exemplo = CONCATENATE (A1, \u201d,\u201c, A2, \u201d,\u201c, A3)<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Agora, verifique como a f\u00f3rmula do CONCATENATE funciona nos dados reais.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-587\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/rows-to-merge.png\" alt=\"\" width=\"533\" height=\"181\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/rows-to-merge.png 533w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/rows-to-merge-300x102.png 300w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na folha, escolha uma c\u00e9lula vazia e digite a f\u00f3rmula nela. Digite a f\u00f3rmula conforme as linhas de dados<\/li>\n<li>E copie a f\u00f3rmula entre outras c\u00e9lulas inteiras na linha.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-586\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-formula.png\" alt=\"\" width=\"637\" height=\"256\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-formula.png 637w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-formula-300x121.png 300w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, simplesmente voc\u00ea est\u00e1 tendo v\u00e1rias linhas de dados mescladas em uma linha<\/li>\n<\/ul>\n<h3><strong><span style=\"text-decoration: underline;\">2. Como combinar linhas no Excel usando o suplemento Merge Cells<\/span><\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-585\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-cells-excel.png\" alt=\"\" width=\"229\" height=\"116\" \/><\/p>\n<p style=\"text-align: justify;\">O suplemento Merge Cells \u00e9 usado para mesclar v\u00e1rios tipos de c\u00e9lulas no Excel. Isso permite mesclar as c\u00e9lulas individuais e tamb\u00e9m combina dados de linhas ou colunas inteiras.<\/p>\n<p style=\"text-align: justify;\">Por favor, note: Voc\u00ea precisa baixar um suplemento de c\u00e9lula de mesclagem para sites de terceiros dispon\u00edveis on-line. pesquise no Google por suplementos.<\/p>\n<p style=\"text-align: justify;\"><strong>Siga os passos indicados para combinar duas ou mais linhas na sua tabela:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Escolha as linhas que voc\u00ea deseja mesclar&gt; clique no \u00edcone Mesclar C\u00e9lulas.<\/li>\n<li>Agora a janela de di\u00e1logo de c\u00e9lulas de mesclagem \u00e9 aberta com a tabela ou o intervalo selecionado. E na parte superior da janela, voc\u00ea pode ver as tr\u00eas coisas b\u00e1sicas:<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-584\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin.png\" alt=\"\" width=\"360\" height=\"371\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin.png 360w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin-291x300.png 291w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin-300x309.png 300w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Como voc\u00ea deseja unir c\u00e9lulas &#8211; Para combinar linhas de dados&gt; escolha &#8220;coluna por coluna&#8221;.<\/li>\n<li>Como separar valores mesclados com &#8211; uma matriz de separadores padr\u00e3o est\u00e1 dispon\u00edvel para escolher&gt; \u200b\u200bv\u00edrgula, espa\u00e7o, ponto-e-v\u00edrgula e quebra de linha. Ent\u00e3o, selecione o separador de acordo com o seu desejo.<\/li>\n<li>Onde voc\u00ea precisa colocar as c\u00e9lulas mescladas&gt; a c\u00e9lula superior ou a c\u00e9lula inferior.<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>Agora, verifique a parte inferior do Windows para verificar se voc\u00ea precisa de op\u00e7\u00f5es adicionais:<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-583\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options.png\" alt=\"\" width=\"360\" height=\"371\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options.png 360w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options-291x300.png 291w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options-300x309.png 300w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Limpar o conte\u00fado das c\u00e9lulas selecionadas &#8211; Escolha esta op\u00e7\u00e3o se precisar que os dados permane\u00e7am apenas nas c\u00e9lulas mescladas.<\/li>\n<li>Mesclar todas as \u00e1reas da sele\u00e7\u00e3o &#8211; essa op\u00e7\u00e3o permite mesclar linhas em dois ou mais intervalos n\u00e3o adjacentes.<\/li>\n<li>Ignore as c\u00e9lulas vazias e envolva o texto &#8211; Bem, elas s\u00e3o autoexplicativas.<\/li>\n<li>Por fim, criar uma c\u00f3pia de backup da planilha &#8211; essa op\u00e7\u00e3o \u00e9 marcada por padr\u00e3o. \u00c9 apenas uma precau\u00e7\u00e3o que mant\u00e9m voc\u00ea no lado seguro e evita o risco de perda de dados.<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"4\">\n<li>Clique no bot\u00e3o Mesclar&gt; para verificar o resultado &#8211; \u00e9 poss\u00edvel que as linhas mescladas de dados sejam separadas por quebras de linha.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Portanto, essas s\u00e3o as duas maneiras que permitem <strong>mesclar linhas no Excel<\/strong> sem qualquer perda de dados. Agora, verifique <strong>as maneiras de combinar duas colunas no Excel.<\/strong><\/p>\n<h3 style=\"text-align: left;\"><strong><u>Parte 2 # Como mesclar colunas no Excel<\/u><\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-582\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-2-columns-excel.png\" alt=\"\" width=\"477\" height=\"160\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-2-columns-excel.png 477w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-2-columns-excel-300x101.png 300w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/p>\n<p>Aqui, verifique as 3 maneiras de mesclar dados de v\u00e1rias colunas em uma, sem usar macro VBA.<\/p>\n<ul>\n<li>Mesclar duas colunas usando f\u00f3rmulas<\/li>\n<li>Combine os dados das colunas via Bloco de notas<\/li>\n<li>A maneira mais r\u00e1pida de unir v\u00e1rias colunas<\/li>\n<\/ul>\n<h3><span style=\"text-decoration: underline;\"><strong>1. Mesclar duas colunas usando f\u00f3rmulas do Excel<\/strong><\/span><\/h3>\n<ul style=\"text-align: justify;\">\n<li>Na sua tabela&gt; insira uma nova coluna&gt; no cabe\u00e7alho da coluna, coloque o ponteiro do mouse&gt; clique com o bot\u00e3o direito do mouse&gt; selecione Inserir no menu de contexto. Nomeie as colunas rec\u00e9m-adicionadas por ex. &#8211; &#8220;Nome completo&#8221;<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-581\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/insert-new-column.png\" alt=\"\" width=\"606\" height=\"160\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/insert-new-column.png 606w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/insert-new-column-300x79.png 300w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/p>\n<ul>\n<li>E na c\u00e9lula D2, escreva a f\u00f3rmula: = CONCATENATE (B2, \u201d\u201c, C2)<\/li>\n<li style=\"text-align: justify;\">O B2 e C2 s\u00e3o os endere\u00e7os de nome e sobrenome. E na f\u00f3rmula, as aspas &#8220;&#8221; \u00e9 o separador que ser\u00e1 inserido entre os nomes fundidos. Qualquer outro s\u00edmbolo pode ser usado como um separador, e. uma v\u00edrgula.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-580\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-2-cells-with-space.png\" alt=\"\" width=\"432\" height=\"163\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-2-cells-with-space.png 432w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-2-cells-with-space-300x113.png 300w\" sizes=\"auto, (max-width: 432px) 100vw, 432px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Da mesma forma, junte os dados de v\u00e1rias c\u00e9lulas em um, fazendo uso de qualquer separador de sua escolha.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-579\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-address-columns.png\" alt=\"\" width=\"568\" height=\"166\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-address-columns.png 568w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-address-columns-300x88.png 300w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Simplesmente copie a f\u00f3rmula para outras c\u00e9lulas da coluna Nome Completo. Se o nome ou o sobrenome for exclu\u00eddo, os dados correspondentes na coluna Nome completo tamb\u00e9m desaparecer\u00e3o.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-578\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combined-names.png\" alt=\"\" width=\"354\" height=\"167\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combined-names.png 354w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combined-names-300x142.png 300w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/p>\n<ul>\n<li>Em seguida, tente converter a f\u00f3rmula em um valor para que voc\u00ea possa remover as colunas desnecess\u00e1rias da planilha do Excel. Escolha c\u00e9lulas inteiras com dados na coluna mesclada (escolha a primeira c\u00e9lula na coluna &#8220;Nome Completo&#8221;&gt; pressione Ctrl + Shift + ArrowDown)<\/li>\n<li style=\"text-align: justify;\">Agora copie o conte\u00fado das colunas para a \u00e1rea de transfer\u00eancia&gt; clique com o bot\u00e3o direito na c\u00e9lula na mesma coluna (\u201cNome Completo\u201d)&gt; escolha o menu de contexto \u201cColar Especial\u201d&gt; escolha o bot\u00e3o de op\u00e7\u00f5es \u201cValores\u201d&gt; clique em OK.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-577\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-paste-values.png\" alt=\"\" width=\"492\" height=\"414\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-paste-values.png 492w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-paste-values-300x252.png 300w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, remova as colunas &#8220;Nome&#8221; e &#8220;Sobrenome&#8221; que n\u00e3o s\u00e3o necess\u00e1rias. Clique no cabe\u00e7alho da coluna B&gt; pressione e segure Ctrl&gt; clique no cabe\u00e7alho da coluna C<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-576\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/delete-merged-columns.png\" alt=\"\" width=\"338\" height=\"261\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/delete-merged-columns.png 338w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/delete-merged-columns-300x232.png 300w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Em seguida, clique com o bot\u00e3o direito do mouse em qualquer coluna selecionada&gt; selecione Excluir no menu de contexto:<\/li>\n<li style=\"text-align: justify;\">E \u00e9 isso, agora voc\u00ea fundiu com sucesso os nomes de 2 colunas em um<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-575\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/two-columns-combined.png\" alt=\"\" width=\"451\" height=\"166\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/two-columns-combined.png 451w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/two-columns-combined-300x110.png 300w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><\/p>\n<h3><span style=\"text-decoration: underline;\"><strong>2. Combine colunas de dados via bloco de notas<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Essa \u00e9 outra maneira que permite mesclar v\u00e1rias colunas. Aqui voc\u00ea n\u00e3o precisa de nenhuma f\u00f3rmula. Isso \u00e9 adequado para combinar colunas adjacentes usando o mesmo delimitador para todas elas.<\/p>\n<p style=\"text-align: justify;\">Por exemplo: Se estiver procurando por combinar 2 colunas com nomes e sobrenomes em uma:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha as duas colunas que voc\u00ea precisa mesclar: Clique em B1&gt; pressione Shift + ArrrowRight para escolher C1&gt; pressione Ctrl + Shift + ArrowDown para escolher c\u00e9lulas inteiras de dados com dados em duas colunas.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-574\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/customers-list.png\" alt=\"\" width=\"520\" height=\"163\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/customers-list.png 520w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/customers-list-300x94.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>E copie os dados para a \u00e1rea de transfer\u00eancia&gt; abra o Bloco de Notas&gt; insira os dados da \u00e1rea de transfer\u00eancia no Bloco de Notas<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-573\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/paste-excel-columns-notepad.png\" alt=\"\" width=\"438\" height=\"222\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/paste-excel-columns-notepad.png 438w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/paste-excel-columns-notepad-300x152.png 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Em seguida, copie o caractere de tabula\u00e7\u00e3o para a \u00e1rea de transfer\u00eancia&gt; pressione a tecla Tab no Bloco de Notas&gt; pressione Ctrl + Shift + LeftArrow&gt; pressione Ctrl + X.<\/li>\n<li>Depois disso, substitua os caracteres de tabula\u00e7\u00e3o no bloco de notas pelo<\/li>\n<li>Pressione Ctrl + H para abrir a caixa de di\u00e1logo \u201cReplace\u201d&gt; cole o caractere Tab da \u00e1rea de transfer\u00eancia no campo Find what&gt; digite o separador Space, comma etc no campo \u201cReplace with\u201d. Clique no bot\u00e3o Substituir tudo&gt; para fechar a caixa de di\u00e1logo, pressione Cancelar<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-572\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/replace-tab-spaces.png\" alt=\"\" width=\"548\" height=\"329\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/replace-tab-spaces.png 548w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/replace-tab-spaces-300x180.png 300w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora selecione todo o texto no bloco de notas e copie-o para a \u00e1rea de transfer\u00eancia.<\/li>\n<li>Em seguida, volte para a planilha do Excel (pressione Alt + Tab)&gt; escolha a c\u00e9lula B1 e cole o texto da \u00e1rea de transfer\u00eancia na sua tabela.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-571\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-text-from-two-columns.png\" alt=\"\" width=\"571\" height=\"163\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-text-from-two-columns.png 571w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-text-from-two-columns-300x86.png 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>E renomeie a coluna B para &#8220;Nome Completo&#8221; e remova a coluna &#8220;Sobrenome&#8221;.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Ent\u00e3o, esta \u00e9 a segunda maneira que permite mesclar colunas no Excel sem perda de dados.<\/p>\n<h3><span style=\"text-decoration: underline;\"><strong>3. Ingressar em colunas usando o suplemento Merge Cells for Excel<\/strong><\/span><\/h3>\n<p style=\"text-align: justify;\">Essa \u00e9 a maneira mais f\u00e1cil e r\u00e1pida de combinar dados de v\u00e1rias colunas do Excel em uma s\u00f3. Basta usar o suplemento de c\u00e9lulas de mesclagem de terceiros para o Excel.<\/p>\n<p style=\"text-align: justify;\">E com o suplemento de c\u00e9lulas de mesclagem, voc\u00ea pode mesclar dados de v\u00e1rias c\u00e9lulas usando qualquer separador desejado (por exemplo, retorno de carro ou quebra de linha). Com isso, voc\u00ea pode juntar linha por linha, coluna por coluna ou mesclar dados da c\u00e9lula selecionada em um sem qualquer perda.<\/p>\n<p style=\"text-align: justify;\">H\u00e1 muitos sites on-line de suplementos de terceiros que permitem baixar os suplementos e mesclar as c\u00e9lulas facilmente com apenas alguns cliques.<\/p>\n<h2 style=\"text-align: justify;\"><span style=\"text-decoration: underline;\"><strong>Conclus\u00e3o:<\/strong><\/span><\/h2>\n<p style=\"text-align: justify;\">Portanto, trata-se de <strong>mesclar linhas e colunas no Excel<\/strong> sem qualquer perda de dados.<\/p>\n<p style=\"text-align: justify;\">Siga as etapas fornecidas para combinar texto em linhas e colunas facilmente.<\/p>\n<p style=\"text-align: justify;\">Espero que as diferentes etapas fornecidas permitam que voc\u00ea execute a tarefa facilmente nas linhas e colunas. Aqui, descrevi diferentes m\u00e9todos de mesclar dados de linhas e colunas no Excel sem qualquer perda de dados.<\/p>\n<p style=\"text-align: justify;\">Portanto, fa\u00e7a uso de qualquer pessoa que voc\u00ea considere f\u00e1cil para voc\u00ea.<\/p>\n<p style=\"text-align: justify;\">No entanto, se voc\u00ea se deparar com algum problema ou situa\u00e7\u00e3o de perda de dados no Excel, use <a href=\"https:\/\/pt.repairmsexcel.com\/baixar-julgamento.php\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Ferramenta de reparo do MS Excel<\/strong><\/a>. Esta \u00e9 a melhor ferramenta que permite reparar e recuperar dados do arquivo Excel corrompido e danificado.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, voc\u00ea pode aprender Excel avan\u00e7ado para se tornar mais produtivo e utilizar facilmente as fun\u00e7\u00f5es e f\u00f3rmulas do Excel.<\/p>\n<br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Resumo: Mesclar linhas e colunas no Excel parece uma tarefa dif\u00edcil para voc\u00ea? Leia este tutorial para aprender diferentes maneiras &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#more-569\" aria-label=\"Read more about 5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":570,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[932,326,933,934,328],"class_list":["post-569","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-como-mesclar-linhas-no-excel","tag-mesclar-colunas-e-linhas-no-excel","tag-mesclar-colunas-no-excel","tag-mesclar-dados-de-linhas-e-colunas-no-excel","tag-mesclar-linhas-no-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados<\/title>\n<meta name=\"description\" content=\"Leia este artigo para saber como mesclar linhas e colunas no Excel sem perder nenhum dado.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados\" \/>\n<meta property=\"og:description\" content=\"Leia este artigo para saber como mesclar linhas e colunas no Excel sem perder nenhum dado.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-18T10:49:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-04T12:10:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/pt-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"690\" \/>\n\t<meta property=\"og:image:height\" content=\"370\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados\",\"datePublished\":\"2018-06-18T10:49:22+00:00\",\"dateModified\":\"2021-10-04T12:10:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel\"},\"wordCount\":1806,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/pt-1.png\",\"keywords\":[\"como mesclar linhas no excel\",\"mesclar colunas e linhas no excel\",\"mesclar colunas no excel\",\"mesclar dados de linhas e colunas no Excel\",\"Mesclar linhas no excel\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel\",\"name\":\"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/pt-1.png\",\"datePublished\":\"2018-06-18T10:49:22+00:00\",\"dateModified\":\"2021-10-04T12:10:21+00:00\",\"description\":\"Leia este artigo para saber como mesclar linhas e colunas no Excel sem perder nenhum dado.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/pt-1.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/pt-1.png\",\"width\":690,\"height\":370,\"caption\":\"mesclar dados de linhas e colunas no Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/merge-fileiras-e-colunas-dentro-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados","description":"Leia este artigo para saber como mesclar linhas e colunas no Excel sem perder nenhum dado.","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:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel","og_locale":"en_US","og_type":"article","og_title":"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados","og_description":"Leia este artigo para saber como mesclar linhas e colunas no Excel sem perder nenhum dado.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2018-06-18T10:49:22+00:00","article_modified_time":"2021-10-04T12:10:21+00:00","og_image":[{"width":690,"height":370,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/pt-1.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados","datePublished":"2018-06-18T10:49:22+00:00","dateModified":"2021-10-04T12:10:21+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel"},"wordCount":1806,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/pt-1.png","keywords":["como mesclar linhas no excel","mesclar colunas e linhas no excel","mesclar colunas no excel","mesclar dados de linhas e colunas no Excel","Mesclar linhas no excel"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel","url":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel","name":"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/pt-1.png","datePublished":"2018-06-18T10:49:22+00:00","dateModified":"2021-10-04T12:10:21+00:00","description":"Leia este artigo para saber como mesclar linhas e colunas no Excel sem perder nenhum dado.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/pt-1.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/pt-1.png","width":690,"height":370,"caption":"mesclar dados de linhas e colunas no Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/merge-fileiras-e-colunas-dentro-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"5 m\u00e9todos f\u00e1ceis para mesclar linhas e colunas no Excel sem perder dados"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=569"}],"version-history":[{"count":6,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/569\/revisions"}],"predecessor-version":[{"id":3335,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/569\/revisions\/3335"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/570"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}