{"id":41018,"date":"2019-03-06T05:47:06","date_gmt":"2019-03-06T11:47:06","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=41018"},"modified":"2024-11-07T20:57:34","modified_gmt":"2024-11-08T02:57:34","slug":"unir-celdas-en-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/unir-celdas-en-excel.html","title":{"rendered":"Unir celdas en excel"},"content":{"rendered":"<h1 style=\"text-align: center;\" id=\"t-1731033674003\">Como unir celdas en Excel paso a paso<\/h1>\n<p style=\"text-align: justify;\">Estas listo para aprender a unir celdas en excel paso a paso?&nbsp;<\/p>\n<p style=\"text-align: justify;\">Estoy seguro que te gustar\u00eda aprender a unir celdas en excel con valores, c\u00f3digos, textos y mucho mas.<\/p>\n<p><span style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Unir-Celdas-en-Excel.png\" rel=\"\"><img loading=\"lazy\" decoding=\"async\" alt=\"Unir celdas en excel\" width=\"448\" height=\"108\" title=\"Unir Celdas en Excel\" data-id=\"41257\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Unir-Celdas-en-Excel.png\" style=\"\"><\/a><\/span><\/p>\n<p style=\"text-align: justify;\">Hace d\u00edas un visitante del blog me envi\u00f3 un correo solicitando ayuda, para unir datos de fecha en una celda.<\/p>\n<p style=\"text-align: justify;\">Por lo tanto para el dia de hoy, quiero compartirte los pasos de como unir celdas en Excel paso a paso.<\/p>\n<h2 style=\"text-align: center;\" id=\"t-1731033673996\">Pasos para Unir Celdas en Excel&nbsp;<\/h2>\n<p style=\"text-align: justify;\">Para comenzar, vamos a escribir los siguientes datos en una hoja de Excel:<\/p>\n<ul>\n<li style=\"text-align: justify;\">En la Columna A2 vamos a escribir el a\u00f1o 2019.<\/li>\n<li style=\"text-align: justify;\">En la Columna B2 escribimos el mes en este caso 03 refiri\u00e9ndonos a marzo.<\/li>\n<li style=\"text-align: justify;\">Y en la C2 escribimos el d\u00eda, en este caso 06.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Puedes notar que en la celda B2 en vez de 03 este cambia a 3, igual para para la celda C2.<\/p>\n<p style=\"text-align: justify;\">Para que excel nos acepte el cero, debemos de dar formato texto, para eso seleccionamos las dos celdas y le aplicamos el formato.<\/p>\n<p style=\"text-align: justify;\">Recuerda, una vez aplicado, debes de reescribir los valores, en la celda B2 escribes 03 y en la C2 06.<\/p>\n<p style=\"text-align: justify;\">Listo, te debe de quedar asi:<\/p>\n<p><span style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Valores-en-Celda.png\" rel=\"\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" width=\"296\" height=\"96\" title=\"Valores en Celda\" data-id=\"41787\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Valores-en-Celda.png\" style=\"\"><\/a><\/span><\/p>\n<p style=\"text-align: justify;\">Muy bien, ahora que tenemos listo los datos, vamos a unir celdas en excel para mostrar un solo dato.<\/p>\n<h2 style=\"text-align: center;\" id=\"t-1731033673997\">S\u00edmbolo para Unir Celdas en Excel&nbsp;<\/h2>\n<p style=\"text-align: justify;\">A continuaci\u00f3n, te voy a compartir un imagen animada, donde podr\u00e1s ver como unir celdas en Excel paso a paso:<\/p>\n<p><span style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Unir-celdas-en-excel.gif\" rel=\"\"><img loading=\"lazy\" decoding=\"async\" alt=\"\" width=\"460\" height=\"208\" title=\"Unir celdas en excel\" data-id=\"41794\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Unir-celdas-en-excel.gif\" style=\"\"><\/a><\/span><\/p>\n<p style=\"text-align: justify;\">Puedes notar que el s\u00edmbolo que utilizamos para unir celdas es: \u00ab&amp;\u00bb, al utilizar este s\u00edmbolo podr\u00e1s unir las celdas de tu preferencia.<\/p>\n<h2 id=\"t-1731033673998\">Preguntas frecuentes de unir celdas en excel<\/h2>\n<h3 style=\"text-align: justify;\" id=\"t-1731033673999\">\u00bfC\u00f3mo juntar celdas en Excel?<\/h3>\n<p style=\"\">Para juntar celdas en excel debes de utilizar el comando \u00abCombinar y Centrar\u00bb de excel.<\/p>\n<p style=\"\">Los siguientes pasos aplican para excel de escritorio y excel mobile.<\/p>\n<p style=\"\">Ejemplo: Primeramente seleccionamos el rango que querremos juntar, en este caso la celda A1 hasta la C1 y en seguida pulsamos clic en el comando combinar y centrar.<\/p>\n<p style=\"\">\u00bfDonde se encuentra el comando Combinar y centrar?<\/p>\n<p style=\"\">Te ubicas en la pesta\u00f1a Inicio, seccion Alineacion dentro de este encontraras el comando Combinar y centrar, te dejo una imagen:<\/p>\n<p><span><img decoding=\"async\" alt=\"\" data-id=\"59443\" width=\"626\" data-init-width=\"626\" height=\"208\" data-init-height=\"208\" title=\"Comando Combinar y centrar 1\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/11\/Comando-Combinar-y-centrar-1.png\" data-width=\"626\" data-height=\"208\" style=\"aspect-ratio: auto 626 \/ 208;\" data-init- data-><\/span><\/p>\n<h3 style=\"text-align: justify;\" id=\"t-1731033674000\">\u00bfC\u00f3mo unir varias columnas en una sola en Excel?<\/h3>\n<p style=\"\">Para unir varias columnas en una sola dentro de excel, debes de utilizar el comando \u00abCombinar y centrar\u00bb de excel.<\/p>\n<p style=\"\">Ejemplo de como aplicar varias columnas en una sola:<\/p>\n<p style=\"\">Como primer paso, seleccionamos las columnas que querremos unicar, en este caso, vamos a seleccionar la columna A y la B, en seguida pulsamos clic en el comando combinar y centrar.<\/p>\n<p style=\"\">Puedes notar que ahora se ha formado una sola columna.<\/p>\n<h3 style=\"text-align: justify;\" id=\"t-1731033674001\">\u00bfC\u00f3mo agrupar las celdas en Excel?<\/h3>\n<p style=\"\">Cuando se refiere a agrupar celdas debemos de especificar que se quieres agrupar? Datos?<\/p>\n<p style=\"\">Existe una diferencia entre unir, combinar y agrupar, las dos primeras se refiere a la unificacion de celdas, pero la ultima se relaciona directamente a datos que contiene las celdas de excel.<\/p>\n<p style=\"\">Entonces, para agregar datos de celdas en excel debes de utilizar los comandos Agrupar o desagrupar.<\/p>\n<p style=\"\">\u00bfDonde encuentro estos comandos?<\/p>\n<p style=\"\">Te ubicas en la pesta\u00f1a Datos &gt;&gt; seccion Esquema &gt;&gt; Agrupar o bien Desagrupar.<\/p>\n<p style=\"\">Alli podras ver que tambien esta acompa\u00f1ado de un poderoso comando Subtotal, te compartire informacion de este comando en otro articulo.<\/p>\n<h3 style=\"text-align: justify;\" id=\"t-1731033674002\">\u00bfC\u00f3mo fijar celdas en Excel?<\/h3>\n<p style=\"\">Para fijar celdas en excel tan solo debes de utilizar el comando \u00abInmovilizar Paneles\u00bb.<\/p>\n<p style=\"\">Entonces veamos los pasos de como fijar celdas en excel:<\/p>\n<p style=\"\">Vamos a imaginarnos que en una hoja de excel en la celda A1 hasta la F1 tenemos encabezamos y queremos dejar visible estas celdas mientras nos desplazamos hacia abajo.<\/p>\n<p style=\"\">Para hacer esto, seleccionamos de la celda A2 hasta la B2 y nos ubicamos en la pesta\u00f1a Vista, seccion Ventana, desplegamos Inmovilizar y pulsamos clic sobre Inmovilizar Paneles.<\/p>\n<p style=\"\">Listo, con este paso ya habras fijado las celdas de la primera fila de la hoja.<\/p>\n<p style=\"text-align: justify;\">Que tal te pareci\u00f3 el articulo de hoy, te gusto? si te gusto comp\u00e1rtelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">facebook<\/a>, pulsando clic en el bot\u00f3n compartir:<\/p>\n<p style=\"text-align: justify;\">Para finalizar, cualquier duda o pregunta, tan solo escr\u00edbenos en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">pagina del chat<\/a> o bien a rogerperezb@gmail.com.<\/p>\n<p style=\"text-align: justify;\">Saludos,<\/p>\n<p style=\"text-align: justify;\"><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como unir celdas en Excel paso a paso Estas listo para aprender a unir celdas en excel paso a paso?&nbsp; Estoy seguro que te gustar\u00eda aprender a unir celdas en excel con valores, c\u00f3digos, textos y mucho mas. Hace d\u00edas un visitante del blog me envi\u00f3 un correo solicitando ayuda, para unir datos de fecha [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":41794,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 data-css=\"tve-u-16901818f61\" style=\"text-align: center;\" class=\"\" id=\"t-1731033674003\">Como unir celdas en Excel paso a paso<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16901831663\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-1690180f5d4\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-1690180f5d5\" style=\"text-align: justify;\">Estas listo para aprender a unir celdas en excel paso a paso?&nbsp;<\/p><p data-css=\"tve-u-1690180f5d5\" style=\"text-align: justify;\">Estoy seguro que te gustar\u00eda aprender a unir celdas en excel con valores, c\u00f3digos, textos y mucho mas.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-16901899df4\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Unir-Celdas-en-Excel.png\" rel=\"\"><img class=\"tve_image wp-image-41257\" alt=\"Unir celdas en excel\" width=\"448\" height=\"108\" title=\"Unir Celdas en Excel\" data-id=\"41257\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/02\/Unir-Celdas-en-Excel.png\" style=\"\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952be8bd9\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952b8dbb9\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952b8dbbb\" style=\"text-align: justify;\">Hace d\u00edas un visitante del blog me envi\u00f3 un correo solicitando ayuda, para unir datos de fecha en una celda.<\/p><p data-css=\"tve-u-16952b8dbbb\" style=\"text-align: justify;\">Por lo tanto para el dia de hoy, quiero compartirte los pasos de como unir celdas en Excel paso a paso.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve-toc tve-toc-expandable tcb-local-vars-root tve-elem-scroll\" data-columns=\"1\" data-ct=\"toc-60671\" data-transition=\"fade\" data-headers=\"h1,h2,h3\" data-numbering=\"basic\" data-highlight=\"heading\" data-ct-name=\"Table of Contents 03\" data-heading-style=\"{&quot;0&quot;:&quot;tve-u-19309a7115a&quot;,&quot;1&quot;:&quot;tve-u-19309a7115c&quot;,&quot;2&quot;:&quot;tve-u-19309a7115d&quot;}\" style=\"\" data-css=\"tve-u-19309a71155\" data-bullet-style=\"{&quot;0&quot;:&quot;tve-u-17399ffbddd&quot;,&quot;1&quot;:&quot;tve-u-1739a0466e5&quot;,&quot;2&quot;:&quot;tve-u-1739a04a2bb&quot;}\" data-number-style=\"{&quot;0&quot;:&quot;tve-u-19309a7115b&quot;,&quot;1&quot;:&quot;tve-u-173dc888a58&quot;,&quot;2&quot;:&quot;tve-u-173dc8891dc&quot;}\" data-state-default=\"expanded\" data-animation=\"slide\" data-animation-speed=\"fast\" data-columns-d=\"1\" data-state-default-m=\"collapsed\" data-element-name=\"Table of Contents\" data-form-settings=\"__TCB_FORM__{&quot;form_identifier&quot;:&quot;unir-celdas-en-excel-form-borvlc&quot;}__TCB_FORM__\" data-id=\"m385dc9t\"><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"5098b\":{\"name\":\"Main Accent\",\"parent\":-1},\"e7865\":{\"name\":\"Main Accent Transparent\",\"parent\":\"5098b\",\"lock\":{\"lightness\":1}}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"5098b\":{\"val\":\"rgb(253, 99, 78)\",\"hsl\":{\"h\":7,\"s\":0.97,\"l\":0.64,\"a\":1}},\"e7865\":{\"val\":\"rgba(253, 99, 78, 0.07)\",\"hsl_parent_dependency\":{\"h\":7,\"s\":0.97,\"l\":0.64,\"a\":0.07}}},\"gradients\":[]},\"original\":{\"colors\":{\"5098b\":{\"val\":\"rgb(253, 99, 78)\",\"hsl\":{\"h\":7,\"s\":0.97,\"l\":0.64,\"a\":1}},\"e7865\":{\"val\":\"rgba(253, 99, 78, 0.07)\",\"hsl_parent_dependency\":{\"h\":7,\"s\":0.97,\"l\":0.64,\"a\":0.07}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div><div class=\"tve-toc-divider\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\"><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(0, 0, 0, 0)\" data-css=\"tve-u-19309a71156\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><\/div><svg class=\"toc-icons\" style=\"position: absolute; width: 0; height: 0; overflow: hidden;\" version=\"1.1\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><symbol viewBox=\"0 0 512 512\" id=\"toc-bullet-0-m385dc9t\" data-id=\"icon-circle-outlined\"><path d=\"M256 8C119 8 8 119 8 256s111 248 248 248 248-111 248-248S393 8 256 8zm0 448c-110.5 0-200-89.5-200-200S145.5 56 256 56s200 89.5 200 200-89.5 200-200 200z\"><\/path><\/symbol><symbol viewBox=\"0 0 512 512\" id=\"toc-bullet-1-m385dc9t\" data-id=\"icon-circle-outlined\"><path d=\"M256 8C119 8 8 119 8 256s111 248 248 248 248-111 248-248S393 8 256 8zm0 448c-110.5 0-200-89.5-200-200S145.5 56 256 56s200 89.5 200 200-89.5 200-200 200z\"><\/path><\/symbol><symbol viewBox=\"0 0 512 512\" id=\"toc-bullet-2-m385dc9t\" data-id=\"icon-circle-outlined\"><path d=\"M256 8C119 8 8 119 8 256s111 248 248 248 248-111 248-248S393 8 256 8zm0 448c-110.5 0-200-89.5-200-200S145.5 56 256 56s200 89.5 200 200-89.5 200-200 200z\"><\/path><\/symbol><\/svg>\n\t<div class=\"tve-content-box-background\" data-css=\"tve-u-19309a71157\" style=\"\"><\/div>\n\t<div class=\"thrv_wrapper tve-toc-title show-icon tcb-icon-display tve-no-dropzone tve-prevent-content-edit\" data-css=\"tve-u-19309a71158\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\">\n\t\t<div class=\"tve-toc-title-icon\" data-icon-code=\"icon-arrow-circle-down-solid\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-circle-down-solid\" data-name=\"\"><path d=\"M504 256c0 137-111 248-248 248S8 393 8 256 119 8 256 8s248 111 248 248zm-143.6-28.9L288 302.6V120c0-13.3-10.7-24-24-24h-16c-13.3 0-24 10.7-24 24v182.6l-72.4-75.5c-9.3-9.7-24.8-9.9-34.3-.4l-10.9 11c-9.4 9.4-9.4 24.6 0 33.9L239 404.3c9.4 9.4 24.6 9.4 33.9 0l132.7-132.7c9.4-9.4 9.4-24.6 0-33.9l-10.9-11c-9.5-9.5-25-9.3-34.3.4z\"><\/path><\/svg><\/div>\n\t\t<div class=\"thrv_wrapper thrv_text_element tve_no_icons\">\t\t\t<div class=\"tcb-plain-text\" style=\"\">Tabla de Contenido<\/div>\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"tve-cb tve-toc-content tve-prevent-content-edit\">\n\t\t\n\n\t\t<div class=\"thrv_wrapper tve-toc-list tcb-no-delete tcb-no-save tcb-no-clone tve-no-dropzone\" data-css=\"tve-u-19309a71159\" style=\"\">\n\t\t\t<div class=\"tve-content-box-background\"><\/div>\n\t\t\t<div class=\"tve-cb\">\n\t\t\t\t<div class=\"tve_ct_content tve_clearfix\"><div class=\"ct_column\"><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H1\" data-css=\"tve-u-19309a7115a\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-number tve-toc-number0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1731033674003\" jump-animation=\"smooth\" data-element-name=\"Number Level 1\" data-level=\"0\" data-css=\"tve-u-19309a7115b\"><span class=\"tve-toc-disabled\">1<\/span><\/div><a href=\"#t-1731033674003\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Como unir celdas en Excel paso a paso<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-19309a7115c\" data-element-name=\"Heading Level 2\"><a href=\"#t-1731033673996\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Pasos para Unir Celdas en Excel&nbsp;<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-19309a7115c\" data-element-name=\"Heading Level 2\"><a href=\"#t-1731033673997\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">S\u00edmbolo para Unir Celdas en Excel&nbsp;<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-19309a7115c\" data-element-name=\"Heading Level 2\"><a href=\"#t-1731033673998\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Preguntas frecuentes de unir celdas en excel<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19309a7115d\" data-element-name=\"Heading Level 3\"><a href=\"#t-1731033673999\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo juntar celdas en Excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19309a7115d\" data-element-name=\"Heading Level 3\"><a href=\"#t-1731033674000\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo unir varias columnas en una sola en Excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19309a7115d\" data-element-name=\"Heading Level 3\"><a href=\"#t-1731033674001\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo agrupar las celdas en Excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level2 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19309a7115d\" data-element-name=\"Heading Level 3\"><a href=\"#t-1731033674002\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo fijar celdas en Excel?<\/a><\/div><\/div><div class=\"thrv_wrapper thrv-divider tve-vert-divider\" data-style=\"tve_sep-1\" data-color-d=\"rgba(0, 0, 0, 0)\" data-css=\"tve-u-19309a71156\" data-thickness-d=\"1\"><hr class=\"tve_sep tve_sep-1\" style=\"\"><\/div><\/div>\n\t\t\t<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 data-css=\"tve-u-16952bef37d\" style=\"text-align: center;\" class=\"\" id=\"t-1731033673996\">Pasos para Unir Celdas en Excel&nbsp;<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952ca124f\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952bf5b30\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952bf5b32\" style=\"text-align: justify;\">Para comenzar, vamos a escribir los siguientes datos en una hoja de Excel:<\/p><ul class=\"\"><li class=\"\" data-css=\"tve-u-16952bf5b32\" style=\"text-align: justify;\">En la Columna A2 vamos a escribir el a\u00f1o 2019.<\/li><li class=\"\" data-css=\"tve-u-16952bf5b32\" style=\"text-align: justify;\">En la Columna B2 escribimos el mes en este caso 03 refiri\u00e9ndonos a marzo.<\/li><li class=\"\" data-css=\"tve-u-16952bf5b32\" style=\"text-align: justify;\">Y en la C2 escribimos el d\u00eda, en este caso 06.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952ca3f5a\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952c3ff44\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952c3ff45\" style=\"text-align: justify;\">Puedes notar que en la celda B2 en vez de 03 este cambia a 3, igual para para la celda C2.<\/p><p data-css=\"tve-u-16952c3ff45\" style=\"text-align: justify;\">Para que excel nos acepte el cero, debemos de dar formato texto, para eso seleccionamos las dos celdas y le aplicamos el formato.<\/p><p data-css=\"tve-u-16952c3ff45\" style=\"text-align: justify;\">Recuerda, una vez aplicado, debes de reescribir los valores, en la celda B2 escribes 03 y en la C2 06.<\/p><p data-css=\"tve-u-16952c3ff45\" style=\"text-align: justify;\">Listo, te debe de quedar asi:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-16952c90984\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Valores-en-Celda.png\" rel=\"\"><img class=\"tve_image wp-image-41787\" alt=\"\" width=\"296\" height=\"96\" title=\"Valores en Celda\" data-id=\"41787\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Valores-en-Celda.png\" style=\"\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952cc1045\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952cadce5\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952cadce6\" style=\"text-align: justify;\">Muy bien, ahora que tenemos listo los datos, vamos a unir celdas en excel para mostrar un solo dato.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 data-css=\"tve-u-16952bef37d\" style=\"text-align: center;\" class=\"\" id=\"t-1731033673997\">S\u00edmbolo para Unir Celdas en Excel&nbsp;<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952de3af6\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952d5e131\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952d5e133\" style=\"text-align: justify;\">A continuaci\u00f3n, te voy a compartir un imagen animada, donde podr\u00e1s ver como unir celdas en Excel paso a paso:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-16952dd351f\"><span class=\"tve_image_frame\" style=\"width: 100%;\"><a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Unir-celdas-en-excel.gif\" rel=\"\"><img class=\"tve_image wp-image-41794\" alt=\"\" width=\"460\" height=\"208\" title=\"Unir celdas en excel\" data-id=\"41794\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2019\/03\/Unir-celdas-en-excel.gif\" style=\"\"><\/a><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952e519c0\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952e00435\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952e00437\" style=\"text-align: justify;\">Puedes notar que el s\u00edmbolo que utilizamos para unir celdas es: \"&amp;\", al utilizar este s\u00edmbolo podr\u00e1s unir las celdas de tu preferencia.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" id=\"t-1731033673998\">Preguntas frecuentes de unir celdas en excel<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><h3 class=\"\" style=\"text-align: justify;\" id=\"t-1731033673999\">\u00bfC\u00f3mo juntar celdas en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-1930798fe1e\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-1930798fe19\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para juntar celdas en excel debes de utilizar el comando \"Combinar y Centrar\" de excel.<\/p><p style=\"\">Los siguientes pasos aplican para excel de escritorio y excel mobile.<\/p><p style=\"\">Ejemplo: Primeramente seleccionamos el rango que querremos juntar, en este caso la celda A1 hasta la C1 y en seguida pulsamos clic en el comando combinar y centrar.<\/p><p style=\"\">\u00bfDonde se encuentra el comando Combinar y centrar?<\/p><p style=\"\">Te ubicas en la pesta\u00f1a Inicio, seccion Alineacion dentro de este encontraras el comando Combinar y centrar, te dejo una imagen:<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-19307dfc9c2\" style=\"\"><span class=\"tve_image_frame\"><img class=\"tve_image wp-image-59443\" alt=\"\" data-id=\"59443\" width=\"626\" data-init-width=\"626\" height=\"208\" data-init-height=\"208\" title=\"Comando Combinar y centrar 1\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2024\/11\/Comando-Combinar-y-centrar-1.png\" data-width=\"626\" data-height=\"208\" style=\"aspect-ratio: auto 626 \/ 208;\"><\/span><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><h3 class=\"\" style=\"text-align: justify;\" id=\"t-1731033674000\">\u00bfC\u00f3mo unir varias columnas en una sola en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19307e18c7c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19307e18c77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para unir varias columnas en una sola dentro de excel, debes de utilizar el comando \"Combinar y centrar\" de excel.<\/p><p style=\"\">Ejemplo de como aplicar varias columnas en una sola:<\/p><p style=\"\">Como primer paso, seleccionamos las columnas que querremos unicar, en este caso, vamos a seleccionar la columna A y la B, en seguida pulsamos clic en el comando combinar y centrar.<\/p><p style=\"\">Puedes notar que ahora se ha formado una sola columna.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><h3 class=\"\" style=\"text-align: justify;\" id=\"t-1731033674001\">\u00bfC\u00f3mo agrupar las celdas en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19307e18c7c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19307e18c77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Cuando se refiere a agrupar celdas debemos de especificar que se quieres agrupar? Datos?<\/p><p style=\"\">Existe una diferencia entre unir, combinar y agrupar, las dos primeras se refiere a la unificacion de celdas, pero la ultima se relaciona directamente a datos que contiene las celdas de excel.<\/p><p style=\"\">Entonces, para agregar datos de celdas en excel debes de utilizar los comandos Agrupar o desagrupar.<\/p><p style=\"\">\u00bfDonde encuentro estos comandos?<\/p><p style=\"\">Te ubicas en la pesta\u00f1a Datos &gt;&gt; seccion Esquema &gt;&gt; Agrupar o bien Desagrupar.<\/p><p style=\"\">Alli podras ver que tambien esta acompa\u00f1ado de un poderoso comando Subtotal, te compartire informacion de este comando en otro articulo.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><h3 class=\"\" style=\"text-align: justify;\" id=\"t-1731033674002\">\u00bfC\u00f3mo fijar celdas en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19307e18c7c\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19307e18c77\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para fijar celdas en excel tan solo debes de utilizar el comando \"Inmovilizar Paneles\".<\/p><p style=\"\">Entonces veamos los pasos de como fijar celdas en excel:<\/p><p style=\"\">Vamos a imaginarnos que en una hoja de excel en la celda A1 hasta la F1 tenemos encabezamos y queremos dejar visible estas celdas mientras nos desplazamos hacia abajo.<\/p><p style=\"\">Para hacer esto, seleccionamos de la celda A2 hasta la B2 y nos ubicamos en la pesta\u00f1a Vista, seccion Ventana, desplegamos Inmovilizar y pulsamos clic sobre Inmovilizar Paneles.<\/p><p style=\"\">Listo, con este paso ya habras fijado las celdas de la primera fila de la hoja.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952e519c0\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952e00435\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952e00437\" style=\"text-align: justify;\">Que tal te pareci\u00f3 el articulo de hoy, te gusto? si te gusto comp\u00e1rtelo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">facebook<\/a>, pulsando clic en el bot\u00f3n compartir:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_social_custom thrv_social tve_share_left\" data-counts=\"\" data-min_shares=\"0\" data-css=\"tve-u-16952e3e676\">\n<div class=\"tve_social_items tve_social_custom tve_style_1 tve_social_itb tve-prevent-content-edit\">\n<div class=\"tve_s_item tve_s_fb_share thrv_wrapper tve_share_item\" data-s=\"fb_share\" data-href=\"https:\/\/aplicaexcelcontable.com\/blog\/unir-celdas-en-excel.html\" data-label=\"Compartir\" data-css=\"tve-u-192edfe099d\">\n\t<a href=\"javascript:void(0)\" class=\"tve_s_link\"><span class=\"tve_s_icon thrv-svg-icon\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"tcb-facebook\" viewBox=\"0 0 16 28\"><path d=\"M14.984 0.187v4.125h-2.453q-1.344 0-1.813 0.562t-0.469 1.687v2.953h4.578l-0.609 4.625h-3.969v11.859h-4.781v-11.859h-3.984v-4.625h3.984v-3.406q0-2.906 1.625-4.508t4.328-1.602q2.297 0 3.563 0.187z\"><\/path><\/svg><\/span><span class=\"tve_s_text\">Compartir<\/span><span class=\"tve_s_count\">0<\/span><\/a>\n<\/div>\n<\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box\" data-css=\"tve-u-16952e6e194\">\n<div class=\"tve-content-box-background\"><\/div>\n<div class=\"tve-cb tve_empty_dropzone\" data-css=\"tve-u-16952e5a732\"><div class=\"thrv_wrapper thrv_text_element tve_empty_dropzone\"><p data-css=\"tve-u-16952e5a734\" style=\"text-align: justify;\">Para finalizar, cualquier duda o pregunta, tan solo escr\u00edbenos en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\">pagina del chat<\/a> o bien a rogerperezb@gmail.com.<\/p><p data-css=\"tve-u-16952e5a734\" style=\"text-align: justify;\">Saludos,<\/p><p data-css=\"tve-u-16952e5a734\" style=\"text-align: justify;\"><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){[data-css=\"tve-u-1690180f5d4\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-1690180f5d5\"] { color: rgb(10, 0, 0) !important; }:not(#tve) [data-css=\"tve-u-16901818f61\"] { color: rgb(249, 9, 9) !important; font-size: 30px !important; }[data-css=\"tve-u-16901831663\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16901899df4\"] { width: 448px; float: none; border: 3px dashed rgb(11, 251, 18); border-radius: 10px; overflow: hidden; box-shadow: rgba(0, 0, 0, 0.4) 12px 9px 23px 5px; margin: 0px auto !important; }[data-css=\"tve-u-16952b8dbb9\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16952b8dbbb\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16952be8bd9\"] { margin-top: 20px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-16952bef37d\"] { font-size: 27px !important; color: rgb(27, 5, 244) !important; }[data-css=\"tve-u-16952bf5b30\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16952bf5b32\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16952c3ff44\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16952c3ff45\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16952c90984\"] { width: 296px; float: none; border: 3px dashed rgb(11, 240, 31); border-radius: 10px; overflow: hidden; margin: 0px auto !important; }[data-css=\"tve-u-16952ca124f\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16952ca3f5a\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16952cadce5\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16952cadce6\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16952cc1045\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16952d5e131\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16952d5e133\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16952dd351f\"] { width: 460px; float: none; border: 3px dashed rgb(236, 11, 215); border-radius: 10px; overflow: hidden; margin: 0px auto !important; }[data-css=\"tve-u-16952de3af6\"] { margin-top: 0px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16952e00435\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16952e00437\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16952e3e676\"] { float: none; margin: 0px auto !important; }[data-css=\"tve-u-16952e519c0\"] { margin-top: 10px !important; margin-bottom: 0px !important; }[data-css=\"tve-u-16952e5a732\"] p { margin: 0px 0px 11px !important; padding: 0px !important; }:not(#tve) [data-css=\"tve-u-16952e5a734\"] { color: rgb(10, 0, 0) !important; }[data-css=\"tve-u-16952e6e194\"] { margin-top: 10px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1930798fe19\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1930798fe19\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-1930798fe19\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-1930798fe1e\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-19307dfc9c2\"] { width: 626px; margin-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19307e18c77\"] { --tve-font-size: 20px; --tve-color: rgb(7,0,0); --tve-applied---tve-color: rgb(7,0,0); text-align: justify; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19307e18c77\"] h6 { color: var(--tve-color,rgb(7,0,0)); --tve-applied-color: var$(--tve-color,rgb(7,0,0)); --tcb-applied-color: rgb(7,0,0); }[data-css=\"tve-u-19307e18c77\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19307e18c7c\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-19309a71155\"] { --tve-toc-indent: 15px; max-width: 500px; float: none; --tcb-local-color-5098b: rgb(253,99,78); --tcb-local-color-e7865: rgba(253,99,78,0.07); padding: 20px 15px 15px !important; margin-left: auto !important; margin-right: auto !important; }[data-css=\"tve-u-19309a71157\"] { box-shadow: rgba(0, 0, 0, 0.13) 0px 4px 24px -2px; border: none !important; background-color: transparent !important; background-image: linear-gradient(rgb(255, 255, 255), rgb(255, 255, 255)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-19309a71159\"] { margin-bottom: 0px !important; padding: 1px !important; margin-top: 15px !important; }[data-css=\"tve-u-19309a7115a\"] { --g-regular-weight: 400; border-width: initial; border-style: none; border-color: initial; --g-bold-weight: 600; font-size: var(--tve-font-size,16px); --tve-font-size: 16px; color: var(--tve-color,rgb(51,51,51)); --tve-color: rgb(51,51,51); --tcb-applied-color: rgb(51,51,51); font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); --tve-font-weight: var(--g-bold-weight,bold); line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; margin: 0px !important; padding: 10px 15px !important; background-image: linear-gradient(rgb(238, 238, 238), rgb(238, 238, 238)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }:not(#tve) [data-css=\"tve-u-19309a7115a\"]:hover { color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; text-decoration: var(--tve-text-decoration,none) !important; --tve-text-decoration: none !important; background-image: linear-gradient(var(--tcb-local-color-5098b),var(--tcb-local-color-5098b)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-19309a7115c\"] { --g-regular-weight: 400; --g-bold-weight: 500; border: none; font-size: var(--tve-font-size,16px); --tve-font-size: 16px; color: var(--tve-color,rgb(120,120,120)); --tve-color: rgb(120,120,120); --tcb-applied-color: rgb(120,120,120); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; padding: 10px 15px !important; margin-top: 0px !important; margin-bottom: 0px !important; background-color: transparent !important; }:not(#tve) [data-css=\"tve-u-19309a7115c\"]:hover { font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; background-image: linear-gradient(var(--tcb-local-color-5098b),var(--tcb-local-color-5098b)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-19309a7115c\"].tve-state-expanded { font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); --tve-font-weight: var(--g-bold-weight,bold); color: var(--tve-color,rgb(51,51,51)); --tve-color: rgb(51,51,51); --tcb-applied-color: rgb(51,51,51); background-image: linear-gradient(var(--tcb-local-color-e7865),var(--tcb-local-color-e7865)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-19309a7115d\"] { --g-regular-weight: 400; --g-bold-weight: 500; border: none; font-size: var(--tve-font-size,16px); --tve-font-size: 16px; color: var(--tve-color,rgb(120,120,120)); --tve-color: rgb(120,120,120); --tcb-applied-color: rgb(120,120,120); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); line-height: var(--tve-line-height,1.4em); --tve-line-height: 1.4em; padding: 10px 15px !important; margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-19309a7115d\"]:hover { font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; color: var(--tve-color,rgb(255,255,255)) !important; --tve-color: rgb(255,255,255) !important; --tcb-applied-color: rgb(255,255,255) !important; background-image: linear-gradient(var(--tcb-local-color-5098b),var(--tcb-local-color-5098b)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-19309a7115d\"].tve-state-expanded { font-weight: var(--tve-font-weight,var(--g-bold-weight,bold)); --tve-font-weight: var(--g-bold-weight,bold); color: var(--tve-color,rgb(51,51,51)); --tve-color: rgb(51,51,51); --tcb-applied-color: rgb(51,51,51); background-image: linear-gradient(var(--tcb-local-color-e7865),var(--tcb-local-color-e7865)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-19309a7115a\"].tve-state-expanded { color: var(--tve-color,rgb(51,51,51)); --tve-color: rgb(51,51,51); --tcb-applied-color: rgb(51,51,51); background-image: linear-gradient(var(--tcb-local-color-e7865),var(--tcb-local-color-e7865)) !important; background-size: auto !important; background-position: 50% 50% !important; background-attachment: scroll !important; background-repeat: no-repeat !important; }[data-css=\"tve-u-19309a71158\"] { --tve-color: var(--tcb-local-color-5098b); --tve-applied---tve-color: var$(--tcb-local-color-5098b); padding: 0px 0px 15px !important; margin: 0px !important; border-bottom: 2px solid var(--tcb-local-color-5098b) !important; }[data-css=\"tve-u-19309a71158\"] .tve-toc-title-icon { font-size: 18px !important; width: 18px !important; height: 18px !important; }[data-css=\"tve-u-19309a71158\"].tve-state-expanded { --animation-angle: -90deg; }[data-css=\"tve-u-19309a71156\"] .tve_sep { background-image: linear-gradient(rgba(0, 0, 0, 0), rgba(0, 0, 0, 0)) !important; width: 1px !important; --tve-applied-background-image: linear-gradient(rgba(0,0,0,0),rgba(0,0,0,0)) !important; }:not(#tve) [data-css=\"tve-u-19309a71158\"] p, :not(#tve) [data-css=\"tve-u-19309a71158\"] li, :not(#tve) [data-css=\"tve-u-19309a71158\"] blockquote, :not(#tve) [data-css=\"tve-u-19309a71158\"] address, :not(#tve) [data-css=\"tve-u-19309a71158\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-19309a71158\"] label, :not(#tve) [data-css=\"tve-u-19309a71158\"] h1, :not(#tve) [data-css=\"tve-u-19309a71158\"] h2, :not(#tve) [data-css=\"tve-u-19309a71158\"] h3, :not(#tve) [data-css=\"tve-u-19309a71158\"] h4, :not(#tve) [data-css=\"tve-u-19309a71158\"] h5, :not(#tve) [data-css=\"tve-u-19309a71158\"] h6 { color: var(--tve-color,var(--tcb-local-color-5098b)); --tve-applied-color: var$(--tve-color,var$(--tcb-local-color-5098b)); --tcb-applied-color: var$(--tcb-local-color-5098b); }[data-css=\"tve-u-19309a7115b\"] { padding: 0px !important; }[data-css=\"tve-u-173dc888a58\"] { padding: 0px !important; }[data-css=\"tve-u-173dc8891dc\"] { padding: 0px !important; }}@media (max-width: 767px){[data-css=\"tve-u-19309a7115a\"] { font-size: var(--tve-font-size,14px); --tve-font-size: 14px; padding: 8px !important; }[data-css=\"tve-u-19309a7115c\"] { font-size: var(--tve-font-size,14px); --tve-font-size: 14px; padding: 8px !important; }[data-css=\"tve-u-19309a7115d\"] { font-size: var(--tve-font-size,14px); --tve-font-size: 14px; padding: 8px !important; }[data-css=\"tve-u-19309a71155\"] { padding: 15px 10px !important; }[data-css=\"tve-u-19309a71158\"] { padding-bottom: 10px !important; }[data-css=\"tve-u-19309a71158\"] .tve-toc-title-icon { font-size: 14px !important; width: 14px !important; height: 14px !important; }[data-css=\"tve-u-19309a71159\"] { margin-top: 10px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[3],"tags":[6139,6137,6138],"class_list":["post-41018","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aprender-excel","tag-celdas-en-excel","tag-como-unir-celdas-en-excel","tag-unir-celdas-en-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/41018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/comments?post=41018"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/41018\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/41794"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=41018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=41018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=41018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}