{"id":1453,"date":"2020-06-01T19:00:13","date_gmt":"2020-06-01T22:00:13","guid":{"rendered":"https:\/\/excelformulaonline.com\/?p=1453"},"modified":"2020-05-31T11:17:00","modified_gmt":"2020-05-31T14:17:00","slug":"mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens","status":"publish","type":"post","link":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/","title":{"rendered":"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!"},"content":{"rendered":"\n<div class=\"kk-star-ratings\n     kksr-valign-top     kksr-align-left    \"\n    data-payload=\"{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;1453&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;explicit&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;}\">\n    \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n    \n<div class=\"kksr-legend\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n<\/div>\n\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1453\" class=\"elementor elementor-1453\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-724a829d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"724a829d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-73a95e87\" data-id=\"73a95e87\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-36a696a3 elementor-widget elementor-widget-text-editor\" data-id=\"36a696a3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<span style=\"font-size: 12pt; color: #000000;\">Como o pr\u00f3prio nome j\u00e1 diz, mesclar c\u00e9lulas no Excel \u00e9 basicamente a combina\u00e7\u00e3o de duas ou mais c\u00e9lulas. No entanto, h\u00e1 duas formas diferentes para realizar isso no Excel.<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Uma delas que \u00e9 mais comum \u00e9 atrav\u00e9s do bot\u00e3o \u201cMesclar e Centralizar\u201d, e a outra op\u00e7\u00e3o \u00e9 com o uso de uma f\u00f3rmula. Veja a seguir por que n\u00e3o mesclar c\u00e9lulas no Excel e quais suas vantagens.<\/span>\r\n<h2><span style=\"font-size: 14pt; color: #000000;\"><strong>Como mesclar c\u00e9lulas no Excel?<\/strong><\/span><\/h2>\r\n<figure id=\"attachment_1703\" aria-describedby=\"caption-attachment-1703\" style=\"width: 2000px\" class=\"wp-caption alignnone\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-1703 size-full\" src=\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-Passo-a-Passo.png\" alt=\"mesclar c\u00e9lulas no excel - Passo a Passo\" width=\"2000\" height=\"1004\" srcset=\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-Passo-a-Passo.png 2000w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-Passo-a-Passo-300x151.png 300w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-Passo-a-Passo-1024x514.png 1024w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-Passo-a-Passo-768x386.png 768w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-Passo-a-Passo-1536x771.png 1536w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-Passo-a-Passo-370x186.png 370w\" sizes=\"(max-width: 2000px) 100vw, 2000px\" \/><figcaption id=\"caption-attachment-1703\" class=\"wp-caption-text\">mesclar c\u00e9lulas no excel &#8211; Passo a Passo<\/figcaption><\/figure>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Como vimos acima, uma das melhores formas de mesclar c\u00e9lulas no Excel \u00e9 atrav\u00e9s da op\u00e7\u00e3o localizada na p\u00e1gina inicial.<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">No entanto, o problema de mesclar c\u00e9lulas \u00e9 que ao tentar realizar alguma opera\u00e7\u00e3o de c\u00e1lculo ou at\u00e9 mesmo filtro de texto, os valores obtidos n\u00e3o ser\u00e3o fieis, pois acabam trazendo somente alguns resultados. Vamos imaginar que temos um conjunto de dados.<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Ao selecionarmos as c\u00e9lulas A1 e B1 ao usar a op\u00e7\u00e3o mesclar e centralizar, o Excel manter\u00e1 o texto da c\u00e9lula a esquerda e excluir\u00e1 o texto de todas as outras c\u00e9lulas. No entanto, o Excel nos alerta antes que isso aconte\u00e7a. Assim ao tentar mesclar essas c\u00e9lulas o Excel abrir\u00e1 uma janela de aviso. Ao prosseguir dando OK, O Excel far\u00e1 a mescla das c\u00e9lulas e manter\u00e1 o texto da primeira c\u00e9lula.<\/span>\r\n<h2><span style=\"font-size: 14pt; color: #000000;\"><strong>Mesclar c\u00e9lulas com f\u00f3rmulas<\/strong><\/span><\/h2>\r\n<span style=\"font-size: 12pt; color: #000000;\">No entanto, se voc\u00ea quer mesclar c\u00e9lulas no Excel e manter seus dados, voc\u00ea pode usar a fun\u00e7\u00e3o CONCATENAR. Como essa fun\u00e7\u00e3o, como o pr\u00f3prio nome j\u00e1 diz, ir\u00e1 unir duas ou mais op\u00e7\u00f5es de textos. A sintaxe dessa op\u00e7\u00e3o \u00e9: =CONCATENAR(A1;\u201d\u201d;B1)<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Neste caso, iremos combinar os dados da c\u00e9lula A1 e B1 e entre eles temos o caractere de espa\u00e7o como separador. Caso voc\u00ea n\u00e3o queira usar nenhum separador, pode usar a f\u00f3rmula simples: =CONTACENAR(A1;B1).<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Voc\u00ea pode usar qualquer outro separador, ponto, v\u00edrgula ou ponto e v\u00edrgula. Dessa forma, voc\u00ea pode copi\u00e1-lo na c\u00e9lula que voc\u00ea deseja mesclar.<\/span>\r\n<h3><span style=\"font-size: 14pt; color: #000000;\"><strong>Por que n\u00e3o mesclar<\/strong><\/span><\/h3>\r\n<figure id=\"attachment_1704\" aria-describedby=\"caption-attachment-1704\" style=\"width: 1688px\" class=\"wp-caption alignnone\"><img decoding=\"async\" class=\"wp-image-1704 size-full\" src=\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.jpg\" alt=\"mesclar c\u00e9lulas no excel\" width=\"1688\" height=\"1125\" srcset=\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.jpg 1688w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-300x200.jpg 300w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-1024x682.jpg 1024w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-768x512.jpg 768w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-1536x1024.jpg 1536w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-370x247.jpg 370w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel-272x182.jpg 272w\" sizes=\"(max-width: 1688px) 100vw, 1688px\" \/><figcaption id=\"caption-attachment-1704\" class=\"wp-caption-text\">mesclar c\u00e9lulas no excel<\/figcaption><\/figure>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Como vimos usar c\u00e9lulas mescladas tem suas vantagens e \u00e9 um recurso muito \u00fatil. No entanto, elas podem atrapalhar a funcionalidade da sua planilha, por exemplo, voc\u00ea pode perder a capacidade de classificar corretamente seus dados ou executar c\u00f3digos em <a href=\"https:\/\/pt.wikipedia.org\/wiki\/Visual_Basic_for_Applications\" target=\"_blank\" rel=\"noopener noreferrer\">VBA<\/a>.<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Ao usar a op\u00e7\u00e3o \u201cMesclar e Centralizar\u201d ela tira a op\u00e7\u00e3o de classificar esse conjunto de dados atrav\u00e9s da ferramenta de filtros do Excel, assim ao tentar classificar esse conjunto o Excel apresentar\u00e1 um erro.<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Assim, essa mescla de informa\u00e7\u00f5es pode ser um empecilho caso voc\u00ea precise usar uma tabela din\u00e2mica, ou na hora de usar f\u00f3rmulas como SOMASE, <a href=\"https:\/\/excelformulaonline.com\/2-funcoes-de-contagem-no-excel-cont-se-e-cont-ses\/\" target=\"_blank\" rel=\"noopener noreferrer\">CONT.SE<\/a>, entre outras. Entretanto, caso sua planilha seja simples voc\u00ea pode us\u00e1-la sem problemas, &#8220;Mas n\u00e3o \u00e9 aconselh\u00e1vel&#8221;.<\/span>\r\n\r\n<span style=\"font-size: 12pt; color: #000000;\">Com a fun\u00e7\u00e3o de mesclar c\u00e9lulas voc\u00ea pode unir uma ou mais c\u00e9lulas diferentes em uma s\u00f3. Ela \u00e9 bastante \u00fatil para melhorar o layout da sua planilha. Assim permitindo, por exemplo, a cria\u00e7\u00e3o de um r\u00f3tulo com uma melhor visualiza\u00e7\u00e3o e interpreta\u00e7\u00e3o de dados. Assim, uma planilha bem organizada e com uma boa representa\u00e7\u00e3o seus dados ser\u00e3o bem recebidos. Se voc\u00ea gostou deste conte\u00fado deixe o seu coment\u00e1rio e compartilhe a sua opni\u00e3o.<\/span>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-86a0cbc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"86a0cbc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-42437204\" data-id=\"42437204\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2d18c94a elementor-invisible elementor-widget elementor-widget-image\" data-id=\"2d18c94a\" data-element_type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;tada&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"http:\/\/art.excelformulaonline.com\/blogfuncmescccel\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"1024\" src=\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2019\/06\/seta-completa-cortada-1024x1024.png\" class=\"attachment-large size-large wp-image-1920\" alt=\"\" srcset=\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2019\/06\/seta-completa-cortada-1024x1024.png 1024w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2019\/06\/seta-completa-cortada-300x300.png 300w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2019\/06\/seta-completa-cortada-150x150.png 150w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2019\/06\/seta-completa-cortada-768x768.png 768w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2019\/06\/seta-completa-cortada-370x370.png 370w, https:\/\/excelformulaonline.com\/wp-content\/uploads\/2019\/06\/seta-completa-cortada.png 1080w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Rate this post Como o pr\u00f3prio nome j\u00e1 diz, mesclar c\u00e9lulas no Excel \u00e9 basicamente a combina\u00e7\u00e3o de duas ou mais c\u00e9lulas. No entanto, h\u00e1 duas formas diferentes para realizar isso no Excel. Uma delas que \u00e9 mais comum \u00e9 atrav\u00e9s do bot\u00e3o \u201cMesclar e Centralizar\u201d, e a outra op\u00e7\u00e3o \u00e9 com o uso de uma f\u00f3rmula. Veja a seguir por que n\u00e3o mesclar c\u00e9lulas no Excel e quais suas vantagens. Como mesclar c\u00e9lulas no Excel? Como vimos acima, uma das melhores formas de mesclar <a href=\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/\" class=\"more-link\"><span>Leia mais<\/span>\u2192<\/a><\/p>\n","protected":false},"author":1,"featured_media":1793,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!<\/title>\n<meta name=\"description\" content=\"Entenda de uma vez por toda, o porque n\u00e3o se deve mesclar c\u00e9lulas no excel. E saiba quais suas vantagens. Acesse e confira!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!\" \/>\n<meta property=\"og:description\" content=\"Entenda de uma vez por toda, o porque n\u00e3o se deve mesclar c\u00e9lulas no excel. E saiba quais suas vantagens. Acesse e confira!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel F\u00f3rmula Online\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/profile.php?id=100041260182847\" \/>\n<meta property=\"article:published_time\" content=\"2020-06-01T22:00:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-31T14:17:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1042\" \/>\n\t<meta property=\"og:image:height\" content=\"684\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Rafael\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rafael\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/\",\"url\":\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/\",\"name\":\"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!\",\"isPartOf\":{\"@id\":\"https:\/\/excelformulaonline.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png\",\"datePublished\":\"2020-06-01T22:00:13+00:00\",\"dateModified\":\"2020-05-31T14:17:00+00:00\",\"author\":{\"@id\":\"https:\/\/excelformulaonline.com\/#\/schema\/person\/34cfc13ab25e161cb2c418c889ed4f73\"},\"description\":\"Entenda de uma vez por toda, o porque n\u00e3o se deve mesclar c\u00e9lulas no excel. E saiba quais suas vantagens. Acesse e confira!\",\"breadcrumb\":{\"@id\":\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#primaryimage\",\"url\":\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png\",\"contentUrl\":\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png\",\"width\":1042,\"height\":684,\"caption\":\"mesclar c\u00e9lulas no excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/excelformulaonline.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelformulaonline.com\/#website\",\"url\":\"https:\/\/excelformulaonline.com\/\",\"name\":\"Excel F\u00f3rmula Online\",\"description\":\"Como Aprender Excel de Forma F\u00e1cil e R\u00e1pida\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelformulaonline.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelformulaonline.com\/#\/schema\/person\/34cfc13ab25e161cb2c418c889ed4f73\",\"name\":\"Rafael\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/excelformulaonline.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/02\/IMG_20190907_104627316-120x120.jpg\",\"contentUrl\":\"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/02\/IMG_20190907_104627316-120x120.jpg\",\"caption\":\"Rafael\"},\"description\":\"Oi, eu sou Rafael Sousa, analista e desenvolvedor de sistemas e com mais de 10 anos de experi\u00eancia com a ferramenta mais utilizada do mundo \u201cExcel\u201d. Depois de ter passado por v\u00e1rias frustra\u00e7\u00f5es no mercado de trabalho e ter revertido, desenvolvi um m\u00e9todo para dominar o Excel a partir do zero at\u00e9 o n\u00edvel Expert, com ele venho mudando a vida de v\u00e1rias pessoas (a maioria completamente iniciante). Meus conte\u00fados online sobre Excel s\u00e3o publicados semanalmente em minhas redes sociais... E s\u00e3o exemplos pr\u00e1ticos, sempre buscando facilita\u00e7\u00e3o de trabalhos manuais por meio da l\u00f3gica computacional.\",\"sameAs\":[\"https:\/\/www.facebook.com\/profile.php?id=100041260182847\",\"https:\/\/www.youtube.com\/channel\/UCjBlId_wC7iYCWAzcfTUPHA\/\"],\"url\":\"https:\/\/excelformulaonline.com\/author\/rosi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!","description":"Entenda de uma vez por toda, o porque n\u00e3o se deve mesclar c\u00e9lulas no excel. E saiba quais suas vantagens. Acesse e confira!","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:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/","og_locale":"pt_BR","og_type":"article","og_title":"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!","og_description":"Entenda de uma vez por toda, o porque n\u00e3o se deve mesclar c\u00e9lulas no excel. E saiba quais suas vantagens. Acesse e confira!","og_url":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/","og_site_name":"Excel F\u00f3rmula Online","article_author":"https:\/\/www.facebook.com\/profile.php?id=100041260182847","article_published_time":"2020-06-01T22:00:13+00:00","article_modified_time":"2020-05-31T14:17:00+00:00","og_image":[{"width":1042,"height":684,"url":"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png","type":"image\/png"}],"author":"Rafael","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Rafael","Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/","url":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/","name":"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!","isPartOf":{"@id":"https:\/\/excelformulaonline.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#primaryimage"},"image":{"@id":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#primaryimage"},"thumbnailUrl":"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png","datePublished":"2020-06-01T22:00:13+00:00","dateModified":"2020-05-31T14:17:00+00:00","author":{"@id":"https:\/\/excelformulaonline.com\/#\/schema\/person\/34cfc13ab25e161cb2c418c889ed4f73"},"description":"Entenda de uma vez por toda, o porque n\u00e3o se deve mesclar c\u00e9lulas no excel. E saiba quais suas vantagens. Acesse e confira!","breadcrumb":{"@id":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#primaryimage","url":"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png","contentUrl":"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png","width":1042,"height":684,"caption":"mesclar c\u00e9lulas no excel"},{"@type":"BreadcrumbList","@id":"https:\/\/excelformulaonline.com\/mesclar-celulas-excel-veja-o-porque-nao-fazer-e-quais-suas-ventagens\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/excelformulaonline.com\/"},{"@type":"ListItem","position":2,"name":"Mesclar C\u00e9lulas no Excel, veja o porque n\u00e3o fazer!"}]},{"@type":"WebSite","@id":"https:\/\/excelformulaonline.com\/#website","url":"https:\/\/excelformulaonline.com\/","name":"Excel F\u00f3rmula Online","description":"Como Aprender Excel de Forma F\u00e1cil e R\u00e1pida","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelformulaonline.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Person","@id":"https:\/\/excelformulaonline.com\/#\/schema\/person\/34cfc13ab25e161cb2c418c889ed4f73","name":"Rafael","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/excelformulaonline.com\/#\/schema\/person\/image\/","url":"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/02\/IMG_20190907_104627316-120x120.jpg","contentUrl":"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/02\/IMG_20190907_104627316-120x120.jpg","caption":"Rafael"},"description":"Oi, eu sou Rafael Sousa, analista e desenvolvedor de sistemas e com mais de 10 anos de experi\u00eancia com a ferramenta mais utilizada do mundo \u201cExcel\u201d. Depois de ter passado por v\u00e1rias frustra\u00e7\u00f5es no mercado de trabalho e ter revertido, desenvolvi um m\u00e9todo para dominar o Excel a partir do zero at\u00e9 o n\u00edvel Expert, com ele venho mudando a vida de v\u00e1rias pessoas (a maioria completamente iniciante). Meus conte\u00fados online sobre Excel s\u00e3o publicados semanalmente em minhas redes sociais... E s\u00e3o exemplos pr\u00e1ticos, sempre buscando facilita\u00e7\u00e3o de trabalhos manuais por meio da l\u00f3gica computacional.","sameAs":["https:\/\/www.facebook.com\/profile.php?id=100041260182847","https:\/\/www.youtube.com\/channel\/UCjBlId_wC7iYCWAzcfTUPHA\/"],"url":"https:\/\/excelformulaonline.com\/author\/rosi\/"}]}},"jetpack_featured_media_url":"https:\/\/excelformulaonline.com\/wp-content\/uploads\/2020\/04\/mesclar-c\u00e9lulas-no-excel.png","_links":{"self":[{"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/posts\/1453"}],"collection":[{"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/comments?post=1453"}],"version-history":[{"count":16,"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/posts\/1453\/revisions"}],"predecessor-version":[{"id":2096,"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/posts\/1453\/revisions\/2096"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/media\/1793"}],"wp:attachment":[{"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/media?parent=1453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/categories?post=1453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelformulaonline.com\/wp-json\/wp\/v2\/tags?post=1453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}