{"id":646,"date":"2023-10-14T18:35:59","date_gmt":"2023-10-14T18:35:59","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/"},"modified":"2023-12-06T11:38:22","modified_gmt":"2023-12-06T11:38:22","slug":"fundir-celulas-dissociadas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/","title":{"rendered":"Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3561072244\"><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-94424976\"><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>Mesclar e desmembrar c\u00e9lulas enquanto trabalha no Excel \u00e9 uma tarefa comum.<\/p><p> \u00c0s vezes, quando voc\u00ea obt\u00e9m dados com muitas c\u00e9lulas mescladas, provavelmente devido \u00e0 presen\u00e7a de dados relacionados em muitas c\u00e9lulas e devido ao qual voc\u00ea n\u00e3o pode filtrar e classificar os dados nas colunas com precis\u00e3o, desta vez para desagrupar essas c\u00e9lulas, voc\u00ea usa a fun\u00e7\u00e3o de desagrupar do Excel.<\/p><h2 id=\"merge-the-cells-through-the-ribbon-option\" class=\"wp-block-heading\"> Mesclar c\u00e9lulas por meio da op\u00e7\u00e3o da faixa de op\u00e7\u00f5es<\/h2><ol><li> Para mesclar c\u00e9lulas, primeiro selecione as c\u00e9lulas que deseja mesclar.<\/li><li> Depois disso, v\u00e1 para a aba Home, e aqui voc\u00ea encontrar\u00e1 a op\u00e7\u00e3o \u201cMesclar e Centralizar\u201d no grupo \u201cAlinhamento\u201d da faixa de op\u00e7\u00f5es.<\/li><li> Agora \u00e9 s\u00f3 clicar na op\u00e7\u00e3o \u201cMesclar e Centralizar\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-grupo de alinhamento de guias iniciais\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png\" sizes=\"auto, \" srcset=\"\" alt=\"home-tab-alignment-group\" width=\"511\" height=\"317\"><\/li><li> No momento em que voc\u00ea clicar na op\u00e7\u00e3o \u201cMesclar e Centralizar\u201d, voc\u00ea receber\u00e1 a op\u00e7\u00e3o pop-up e basta clicar em \u201cok\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-centro de fus\u00e3o\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-centre-de-fusion.png\" sizes=\"auto, \" srcset=\"\" alt=\"merge-&amp;-center\" width=\"513\" height=\"259\"><\/li><li> Neste ponto, o intervalo de c\u00e9lulas selecionado \u00e9 mesclado. <br><img loading=\"lazy\" decoding=\"async\" title=\"Gama de 3 c\u00e9lulas fundidas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-plages-de-cellules-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"merged-cell-range\" width=\"526\" height=\"185\"><\/li><\/ol><h2 id=\"unmerge-the-cells-through-ribbon-option\" class=\"wp-block-heading\"> Desfazer mesclagem de c\u00e9lulas da faixa de op\u00e7\u00f5es<\/h2><ol><li> Primeiro, selecione um ou mais intervalos de c\u00e9lulas mescladas que deseja desagrupar.<\/li><li> Depois disso, v\u00e1 at\u00e9 a aba inicial, e aqui voc\u00ea encontrar\u00e1 a op\u00e7\u00e3o \u201cMesclar e Centralizar\u201d destacada.<\/li><li> Agora \u00e9 s\u00f3 clicar nesta op\u00e7\u00e3o \u201cMesclar e Centralizar\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-desmesclar c\u00e9lulas atrav\u00e9s da faixa de op\u00e7\u00f5es\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cellules-non-fusionnees-a-travers-le-ruban.png\" sizes=\"auto, \" srcset=\"\" alt=\"unmerge-cells-through-ribbon\" width=\"505\" height=\"314\"><\/li><li> Neste ponto, os intervalos de c\u00e9lulas mesclados selecionados n\u00e3o ser\u00e3o mais mesclados. <br><img loading=\"lazy\" decoding=\"async\" title=\"C\u00e9lulas 5 n\u00e3o fundidas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cellules-non-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"unmerged-cells\" width=\"519\" height=\"180\"><\/li><\/ol><h2 id=\"merge-unmerge-the-cells-using-keyboard-shortcut\" class=\"wp-block-heading\"> Mesclar e desagrupar c\u00e9lulas usando um <a href=\"https:\/\/exceladvisor.org\/pt\/mesclar-celulas-dissociadas-1\/\">atalho de teclado<\/a><\/h2><p> Para economizar tempo, voc\u00ea pode mesclar e desagrupar c\u00e9lulas usando o atalho do teclado.<\/p><ol><li> Para mesclar c\u00e9lulas, selecione o intervalo de c\u00e9lulas que deseja mesclar.<\/li><li> Depois disso, pressione \u201cAlt+H+M+C\u201d ou \u201cAlt+H+M+M\u201d um ap\u00f3s o outro e clique em \u201cok\u201d na op\u00e7\u00e3o pop-up. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-mesclar usando o atalho do teclado\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-fusionner-en-utilisant-le-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"merge-using-keyboard-shortcut\" width=\"522\" height=\"324\"><br><img loading=\"lazy\" decoding=\"async\" title=\"7-ok-para mesclar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-ok-pour-fusionner.png\" sizes=\"auto, \" srcset=\"\" alt=\"ok-to-merge\" width=\"478\" height=\"261\"><\/li><li> Neste ponto, o intervalo de c\u00e9lulas selecionado \u00e9 mesclado. <br><img loading=\"lazy\" decoding=\"async\" title=\"8 c\u00e9lulas mescladas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-cellules-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"merged-cells\" width=\"522\" height=\"184\"><\/li><li> Agora, para desagrupar as c\u00e9lulas mescladas, selecione o intervalo de c\u00e9lulas mescladas que deseja desagrupar.<\/li><li> Depois disso, pressione \u201cAlt + H + M + C\u201d um ap\u00f3s o outro. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-desfazer mesclagem usando atalho de teclado\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-dissocier-a-laide-du-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"unmerge-using-keyboard-shortcut\" width=\"489\" height=\"305\"><\/li><li> Neste ponto, o intervalo selecionado de c\u00e9lulas mescladas n\u00e3o ser\u00e1 mesclado. <br><img loading=\"lazy\" decoding=\"async\" title=\"Faixa de 10 c\u00e9lulas n\u00e3o fundidas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-plages-de-cellules-non-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"unmerged-cells-range\" width=\"506\" height=\"179\"><\/li><\/ol><p> Muitas vezes voc\u00ea pode encontrar a planilha com v\u00e1rias c\u00e9lulas mescladas e para desagrupar todas as c\u00e9lulas de uma vez basta selecionar a planilha pressionando \u201cCtrl+A\u201d.<\/p><p> Ou clicando na caixa do canto superior esquerdo da planilha e toda a planilha ser\u00e1 selecionada. Depois disso, basta clicar na op\u00e7\u00e3o \u201cMesclar e Centralizar\u201d da faixa de op\u00e7\u00f5es e todas as c\u00e9lulas mescladas n\u00e3o ser\u00e3o mais mescladas na planilha de uma vez. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63920\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-multiples-cellules-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"v\u00e1rias c\u00e9lulas mescladas\" width=\"567\" height=\"350\"><\/figure><\/div><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-63921\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/12-feuille-de-calcul-non-fusionnee.png\" sizes=\"auto, \" srcset=\"\" alt=\"planilha n\u00e3o mesclada\" width=\"570\" height=\"198\"><\/figure><\/div><h2 id=\"unmerge-and-fill-the-unmerged-cells-with-the-original-value\" class=\"wp-block-heading\">Desfazer a mesclagem e preencher c\u00e9lulas n\u00e3o mescladas com o valor original<\/h2><p> O desafio que sempre surge ao mesclar c\u00e9lulas \u00e9 preencher o valor original em todas as c\u00e9lulas n\u00e3o mescladas porque quando voc\u00ea mescla um intervalo de c\u00e9lulas, o Excel aloca apenas o valor da c\u00e9lula superior ou o valor da c\u00e9lula esquerda neste intervalo mesclado com base na sele\u00e7\u00e3o do intervalo de c\u00e9lulas.<\/p><p> Portanto, ao desfazer a mesclagem dessas c\u00e9lulas mescladas, voc\u00ea ainda encontrar\u00e1 o valor na c\u00e9lula n\u00e3o mesclada superior e outras c\u00e9lulas n\u00e3o mescladas nesse intervalo selecionado ficar\u00e3o em branco.<\/p><ol><li> Comece desagrupando o intervalo de c\u00e9lulas mesclado. <br><img loading=\"lazy\" decoding=\"async\" title=\"13 c\u00e9lulas mescladas n\u00e3o mescladas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/13-cellules-fusionnees-non-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"unmerge-merged-cells\" width=\"523\" height=\"182\"><\/li><li> Depois disso, selecione as c\u00e9lulas n\u00e3o mescladas, incluindo c\u00e9lulas em branco ou todo o conjunto de dados\/tabela.<\/li><li> Agora v\u00e1 para \u201cGuia inicial\u201d e no grupo \u201cEditar\u201d, clique em \u201cLocalizar e selecionar\u201d e clique em \u201cIr para especial\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"14-go-to-especial\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/14-aller-au-special.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-special\" width=\"638\" height=\"339\"><br><img loading=\"lazy\" decoding=\"async\" title=\"15-selecionar-dados-ir-para-especial\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/15-donnees-selectionnees-aller-a-special.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-data-go-to-special\" width=\"633\" height=\"338\"><\/li><li> Depois de clicar em \u201cIr para Especial\u201d, uma op\u00e7\u00e3o pop-up ser\u00e1 aberta e selecione \u201cEm branco\u201d e clique em OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"16-selecionar op\u00e7\u00e3o em branco\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/16-selectionnez-loption-vide.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-blank-option\" width=\"574\" height=\"300\"><\/li><li> Agora voc\u00ea encontrar\u00e1 todas as c\u00e9lulas em branco selecionadas e basta inserir o sinal de igual (=), pressionar a tecla de seta para cima no teclado e pressionar o bot\u00e3o Ctrl + Enter e a f\u00f3rmula ser\u00e1 copiada para todas as c\u00e9lulas em branco. <br><img loading=\"lazy\" decoding=\"async\" title=\"17 c\u00e9lulas vazias selecionadas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/17-toutes-les-cellules-vides-selectionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"all-blank-cells-selected\" width=\"545\" height=\"191\"><\/li><li> Neste ponto, as c\u00e9lulas vazias s\u00e3o preenchidas com o valor original que voc\u00ea tinha no intervalo de c\u00e9lulas mescladas. <br><img loading=\"lazy\" decoding=\"async\" title=\"18 c\u00e9lulas vazias preenchidas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/18-cellules-vides-remplies.png\" sizes=\"auto, \" srcset=\"\" alt=\"blank-cells-filled\" width=\"542\" height=\"193\"><\/li><\/ol><h2 id=\"how-to-find-the-merged-cells\" class=\"wp-block-heading\"> Como encontrar c\u00e9lulas mescladas<\/h2><p> Muitas vezes voc\u00ea pode obter um arquivo Excel com um enorme conjunto de dados e n\u00e3o saber se ele cont\u00e9m c\u00e9lulas mescladas ou n\u00e3o, ent\u00e3o, para encontrar as c\u00e9lulas mescladas nos dados, voc\u00ea pode encontr\u00e1-las todas seguindo as etapas abaixo.<\/p><ol><li> Em primeiro lugar, clique em qualquer lugar dos dados e v\u00e1 para a aba \u201cHome\u201d e no grupo \u201cedi\u00e7\u00e3o\u201d clique em \u201cLocalizar e Selecionar\u201d e depois clique na op\u00e7\u00e3o \u201cLocalizar\u201d ou apenas pressione Ctrl + F no teclado. <br><img loading=\"lazy\" decoding=\"async\" title=\"19-encontrar-mesclar-c\u00e9lulas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/19-trouver-des-cellules-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"find-merged-cells\" width=\"588\" height=\"308\"><\/li><li> Depois de clicar na op\u00e7\u00e3o \u201cLocalizar\u201d ou pressionar Ctrl + F, voc\u00ea obter\u00e1 o menu \u201cLocalizar e Substituir\u201d e basta clicar em \u201cFormatar\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"20-menu localizar-substituir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/20-rechercher-remplacer-le-menu.png\" sizes=\"auto, \" srcset=\"\" alt=\"find-&amp;-replace-menu\" width=\"436\" height=\"234\"><\/li><li> Agora selecione \u201cAlinhamento\u201d e marque \u201cMesclar c\u00e9lulas\u201d e clique em OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"21-selecionar guia de alinhamento\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/21-selectionner-longlet-dalignement.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-alignment-tab\" width=\"451\" height=\"447\"><\/li><li> Ao final, selecione \u201cEncontrar tudo\u201d e voc\u00ea obter\u00e1 a lista de todas as c\u00e9lulas mescladas nos dados.<\/li><li> Para ver as c\u00e9lulas mescladas uma por uma, basta pressionar \u201cLocalizar pr\u00f3ximo\u201d e cada vez que voc\u00ea for para as pr\u00f3ximas c\u00e9lulas mescladas, as c\u00e9lulas mescladas ser\u00e3o destacadas ou voc\u00ea tamb\u00e9m pode fazer isso clicando na lista de c\u00e9lulas mescladas. <br><img loading=\"lazy\" decoding=\"async\" title=\"22-selecionar-encontrar tudo\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/22-selectionner-le-trouver-tout.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-find-all\" width=\"662\" height=\"323\"><\/li><\/ol><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\/desenhe-uma-linha\/\">Desenhe uma linha no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/adicionar-um-botao\/\">Adicionar um bot\u00e3o no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/verificador-ortografico\/\">Verifica\u00e7\u00e3o ortogr\u00e1fica no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/cancelamento\/\">Aumentar e diminuir o recuo no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/girar-texto\/\">Girar texto no Excel (orienta\u00e7\u00e3o do texto)<\/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-646","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u25b7 Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?<\/title>\n<meta name=\"description\" content=\"Neste tutorial voc\u00ea aprender\u00e1 como mesclar e desmesclar c\u00e9lulas. \u00c0s vezes, quando voc\u00ea obt\u00e9m dados contendo\" \/>\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\/fundir-celulas-dissociadas\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial voc\u00ea aprender\u00e1 como mesclar e desmesclar c\u00e9lulas. \u00c0s vezes, quando voc\u00ea obt\u00e9m dados contendo\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:38:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.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=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/\",\"name\":\"\u25b7 Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png\",\"datePublished\":\"2023-10-14T18:35:59+00:00\",\"dateModified\":\"2023-12-06T11:38:22+00:00\",\"description\":\"Neste tutorial voc\u00ea aprender\u00e1 como mesclar e desmesclar c\u00e9lulas. \u00c0s vezes, quando voc\u00ea obt\u00e9m dados contendo\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?\"}]},{\"@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":"\u25b7 Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?","description":"Neste tutorial voc\u00ea aprender\u00e1 como mesclar e desmesclar c\u00e9lulas. \u00c0s vezes, quando voc\u00ea obt\u00e9m dados contendo","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\/fundir-celulas-dissociadas\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?","og_description":"Neste tutorial voc\u00ea aprender\u00e1 como mesclar e desmesclar c\u00e9lulas. \u00c0s vezes, quando voc\u00ea obt\u00e9m dados contendo","og_url":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:38:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/","url":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/","name":"\u25b7 Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png","datePublished":"2023-10-14T18:35:59+00:00","dateModified":"2023-12-06T11:38:22+00:00","description":"Neste tutorial voc\u00ea aprender\u00e1 como mesclar e desmesclar c\u00e9lulas. \u00c0s vezes, quando voc\u00ea obt\u00e9m dados contendo","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-groupe-dalignement-de-longlet-daccueil.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/fundir-celulas-dissociadas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como mesclar \u2013 desfazer a mesclagem de c\u00e9lulas?"}]},{"@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\/646","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=646"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/646\/revisions"}],"predecessor-version":[{"id":1119,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/646\/revisions\/1119"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}