{"id":60896,"date":"2025-01-05T20:46:43","date_gmt":"2025-01-06T02:46:43","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=60896"},"modified":"2026-11-07T14:51:12","modified_gmt":"2026-11-07T20:51:12","slug":"desbordamiento-en-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/desbordamiento-en-excel.html","title":{"rendered":"Desbordamiento en Excel"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"60896\" class=\"elementor elementor-60896 elementor-bc-flex-widget\" data-elementor-post-type=\"post\">\n\t\t\t\t<section class=\"elementor-element elementor-element-2aba4b57 e-con e-atomic-element e-div-block-base e-default-section e-63d0f36b-32a9 \" data-id=\"2aba4b57\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"2aba4b57\" data-e-type=\"e-div-block\" data-id=\"2aba4b57\">\n    <div class=\"elementor-element elementor-element-292d3717 e-con e-atomic-element e-flexbox-base e-default-div e-759ac717-ceb4 \" data-id=\"292d3717\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"292d3717\" data-e-type=\"e-flexbox\" data-id=\"292d3717\">\n    <div class=\"elementor-element elementor-element-119ffce8 e-con e-atomic-element e-grid-base e-default-div e-2d330134-818f \" data-id=\"119ffce8\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"119ffce8\" data-e-type=\"e-grid\" data-id=\"119ffce8\">\n    <div class=\"elementor-element elementor-element-22a956f5 e-con e-atomic-element e-flexbox-base e-default-div e-e4fb5e9-5599 \" data-id=\"22a956f5\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"22a956f5\" data-e-type=\"e-flexbox\" data-id=\"22a956f5\">\n    \t\t\t<p class=\"e-73502bc8-b245 e-paragraph-base e-default-p\" data-interaction-id=\"2e0bb68a\" data-e-type=\"widget\" data-id=\"2e0bb68a\">EXCEL 2021 Y MICROSOFT 365  \/  MATRICES DIN\u00c1MICAS<\/p>\n\t\t\t\t\t<h1 data-interaction-id=\"2ed0a553\" class=\"e-7f09c6ba-7851 e-heading-base e-default-h1\" data-e-type=\"widget\" data-id=\"2ed0a553\">Desbordamiento en Excel: 6 funciones con ejemplos<\/h1>\n\t\t\t\t\t<p class=\"e-58bab7f8-b4a7 e-paragraph-base e-default-p\" data-interaction-id=\"35620984\" data-e-type=\"widget\" data-id=\"35620984\">Una f\u00f3rmula puede devolver una lista completa de clientes o un reporte de facturas pendientes. Aprende a usar seis funciones de matrices din\u00e1micas, comprueba sus resultados y encuentra la causa cuando Excel muestra un error.<\/p>\n\t\t<div class=\"elementor-element elementor-element-24f4bd28 e-con e-atomic-element e-flexbox-base e-default-div e-68cd43ba-c0f1 \" data-id=\"24f4bd28\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"24f4bd28\" data-e-type=\"e-flexbox\" data-id=\"24f4bd28\">\n    \t\t\t<a href=\"#t-1736125624216\" target=\"_self\" class=\"e-b9c66a-843b e-button-base e-default-a\" data-interaction-id=\"5a82e729\" data-e-type=\"widget\" data-id=\"5a82e729\">\n\tVer las 6 funciones\n<\/a>\n\t\t\t\t\t<a href=\"#videos-desbordamiento-excel\" target=\"_self\" class=\"e-5eae93cf-11ac e-button-base e-default-a\" data-interaction-id=\"679ee826\" data-e-type=\"widget\" data-id=\"679ee826\">\n\tVer los 3 videos\n<\/a>\n\t\t\n<\/div>\n\t\t\t<p class=\"e-5e3ca8cf-a118 e-paragraph-base e-default-p\" data-interaction-id=\"5588474c\" data-e-type=\"widget\" data-id=\"5588474c\">Por Roger P\u00e9rez \u00b7 Publicado el 5 de enero de 2025<\/p><div id=\"aplic-1729355503\" class=\"gas_fallback-ad_66423--placement_66425\" role=\"region\" aria-label=\"Publicidad\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-9769554880758744\" crossorigin=\"anonymous\"><\/script><insclass=\"adsbygoogle\" style=\"display:inline-block;width:728px;height:90px;\" data-ad-client=\"ca-pub-9769554880758744\" data-ad-slot=\"7268988160\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-1e6ceae1 e-con e-atomic-element e-flexbox-base e-default-div e-5b6c0e5d-1d11 \" data-id=\"1e6ceae1\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"1e6ceae1\" data-e-type=\"e-flexbox\" data-id=\"1e6ceae1\">\n    \t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2025\/01\/Desbordamiento-Excel.png\" target=\"_blank\" class=\"e-image-link-base e-default-a\" data-interaction-id=\"7a289bba\"\n\t><img fetchpriority=\"high\" decoding=\"async\" class=\"e-image-base e-default-img e-4e3dc439-c930\" data-e-type=\"widget\" data-id=\"7a289bba\" id=\"60898\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2025\/01\/Desbordamiento-Excel.png\" width=\"628\" height=\"344\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2025\/01\/Desbordamiento-Excel.png 628w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2025\/01\/Desbordamiento-Excel-300x164.png 300w\" alt=\"Desbordamiento en Excel con seis funciones de matrices din\u00e1micas\"\/>\t<\/a>\t\t\t\t\t<p class=\"e-3c0952e1-73a4 e-paragraph-base e-default-p\" data-interaction-id=\"698d0543\" data-e-type=\"widget\" data-id=\"698d0543\">Portada de la gu\u00eda de desbordamiento en Excel.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/div>\n\n<\/section>\n<nav class=\"elementor-element elementor-element-3094e02a e-con e-atomic-element e-div-block-base e-default-nav e-16e7d2fe-c082 \" data-id=\"3094e02a\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"3094e02a\" data-e-type=\"e-div-block\" data-id=\"3094e02a\">\n    <div class=\"elementor-element elementor-element-6aa25813 e-con e-atomic-element e-flexbox-base e-default-div e-58d3b146-c457 \" data-id=\"6aa25813\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"6aa25813\" data-e-type=\"e-flexbox\" data-id=\"6aa25813\">\n    \t\t\t<p class=\"e-30af4e23-43c6 e-paragraph-base e-default-p\" data-interaction-id=\"714967f0\" data-e-type=\"widget\" data-id=\"714967f0\">EN ESTA GU\u00cdA<\/p>\n\t\t<div class=\"elementor-element elementor-element-3753aef7 e-con e-atomic-element e-flexbox-base e-default-div e-2cdd5cb-e22b \" data-id=\"3753aef7\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"3753aef7\" data-e-type=\"e-flexbox\" data-id=\"3753aef7\">\n    \t\t\t<a href=\"#t-1736125624213\" target=\"_self\" class=\"e-26781694-5348 e-button-base e-default-a\" data-interaction-id=\"6743767\" data-e-type=\"widget\" data-id=\"6743767\">\n\tQu\u00e9 es\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624215\" target=\"_self\" class=\"e-7298af32-51c9 e-button-base e-default-a\" data-interaction-id=\"6b966ce3\" data-e-type=\"widget\" data-id=\"6b966ce3\">\n\tReglas de uso\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624216\" target=\"_self\" class=\"e-7cc2d390-9ba1 e-button-base e-default-a\" data-interaction-id=\"7f86c977\" data-e-type=\"widget\" data-id=\"7f86c977\">\n\t6 funciones\n<\/a>\n\t\t\t\t\t<a href=\"#practica-reporte-facturas\" target=\"_self\" class=\"e-6f863b8f-12af e-button-base e-default-a\" data-interaction-id=\"6f863b8f\" data-e-type=\"widget\" data-id=\"6f863b8f\">\n\tPr\u00e1ctica guiada\n<\/a>\n\t\t\t\t\t<a href=\"#solucionar-error-desbordamiento\" target=\"_self\" class=\"e-26c47900-9bfd e-button-base e-default-a\" data-interaction-id=\"5d1d6169\" data-e-type=\"widget\" data-id=\"5d1d6169\">\n\tC\u00f3mo corregir el error\n<\/a>\n\t\t\t\t\t<a href=\"#videos-desbordamiento-excel\" target=\"_self\" class=\"e-6ffbe619-351a e-button-base e-default-a\" data-interaction-id=\"595f9329\" data-e-type=\"widget\" data-id=\"595f9329\">\n\t3 videos\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624223\" target=\"_self\" class=\"e-40e22d55-1c30 e-button-base e-default-a\" data-interaction-id=\"6e13eecb\" data-e-type=\"widget\" data-id=\"6e13eecb\">\n\tPreguntas frecuentes\n<\/a>\n\t\t\t\t\t<a href=\"#comentario\" target=\"_self\" class=\"e-3134bd11-b69e e-button-base e-default-a\" data-interaction-id=\"5bad3cae\" data-e-type=\"widget\" data-id=\"5bad3cae\">\n\tComentarios\n<\/a>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/nav>\n<section class=\"elementor-element elementor-element-77e39bcf e-con e-atomic-element e-div-block-base e-default-section e-6774a7fe-a8af \" data-id=\"77e39bcf\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"77e39bcf\" data-e-type=\"e-div-block\" data-id=\"77e39bcf\">\n    <div class=\"elementor-element elementor-element-66439a52 e-con e-atomic-element e-flexbox-base e-default-div e-3c451e08-a022 \" data-id=\"66439a52\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"66439a52\" data-e-type=\"e-flexbox\" data-id=\"66439a52\">\n    \t\t\t<p class=\"e-447c8fa8-ec7e e-paragraph-base e-default-p\" data-interaction-id=\"3043cdff\" data-e-type=\"widget\" data-id=\"3043cdff\">QU\u00c9 HACE LA F\u00d3RMULA<\/p>\n\t\t\t\t\t<h2 data-interaction-id=\"6b2d376e\" class=\"e-5c45876c-8a6e e-heading-base e-default-h2\" id=\"t-1736125624213\" data-e-type=\"widget\" data-id=\"6b2d376e\">\u00bfQu\u00e9 significa el desbordamiento en Excel?<\/h2>\n\t\t<div class=\"elementor-element elementor-element-68dbb171 e-con e-atomic-element e-grid-base e-default-div e-795478d3-377f \" data-id=\"68dbb171\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"68dbb171\" data-e-type=\"e-grid\" data-id=\"68dbb171\">\n    <div class=\"elementor-element elementor-element-6b33131e e-con e-atomic-element e-flexbox-base e-default-div e-78dee450-baeb \" data-id=\"6b33131e\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"6b33131e\" data-e-type=\"e-flexbox\" data-id=\"6b33131e\">\n    \t\t\t<p class=\"e-1f85c038-50c5 e-paragraph-base e-default-p\" data-interaction-id=\"2c3711d9\" data-e-type=\"widget\" data-id=\"2c3711d9\">El desbordamiento en Excel ocurre cuando una f\u00f3rmula devuelve varios valores y Excel los coloca en las celdas vecinas. Escribe la f\u00f3rmula una vez, en la celda superior izquierda. Las dem\u00e1s celdas del rango muestran los resultados que dependen de ella.<\/p>\n\t\t\t\t\t<p class=\"e-27a948df-3600 e-paragraph-base e-default-p\" data-interaction-id=\"2d920c\" data-e-type=\"widget\" data-id=\"2d920c\">Para ver el comportamiento, escribe esta f\u00f3rmula en F2, con F2:F5 libres, y pulsa Entrar.<\/p>\n\t\t\t\t\t<p class=\"e-1c0d8bf3-6ac4 e-paragraph-base e-default-p\" data-interaction-id=\"32158904\" data-e-type=\"widget\" data-id=\"32158904\">=SECUENCIA(4)<\/p>\n\t\t\t\t\t<p class=\"e-201b11a2-94a8 e-paragraph-base e-default-p\" data-interaction-id=\"4bb3c416\" data-e-type=\"widget\" data-id=\"4bb3c416\">Ver\u00e1s 1, 2, 3 y 4 en F2:F5. Cambia el 4 por 6 en F2 para ampliar el rango. Esta es la diferencia entre una matriz din\u00e1mica y un resultado de tama\u00f1o fijo.<\/p>\n\t\t\t\t\t<p class=\"e-3aa72d71-90f7 e-paragraph-base e-default-p\" data-interaction-id=\"1cff58d\" data-e-type=\"widget\" data-id=\"1cff58d\">Puedes usar este comportamiento en reportes contables, inventarios o an\u00e1lisis de ventas. Un filtro puede devolver solo las facturas pendientes, y una lista de valores \u00fanicos puede mostrar cada cliente una vez.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-2acfb4d3 e-con e-atomic-element e-flexbox-base e-default-div e-345903a2-65c6 \" data-id=\"2acfb4d3\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2acfb4d3\" data-e-type=\"e-flexbox\" data-id=\"2acfb4d3\">\n    \t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Gif-Formulas-desbordadas.gif\" target=\"_blank\" class=\"e-image-link-base e-default-a\" data-interaction-id=\"1c107b14\"\n\t><img decoding=\"async\" class=\"e-image-base e-default-img e-40f60b39-f69a\" data-e-type=\"widget\" data-id=\"1c107b14\" id=\"48250\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Gif-Formulas-desbordadas.gif\" width=\"440\" height=\"346\" srcset=\"\" alt=\"Animaci\u00f3n de una f\u00f3rmula que muestra resultados en varias celdas de Excel\"\/>\t<\/a>\t\t\t\t\t<p class=\"e-67bc35b2-e42f e-paragraph-base e-default-p\" data-interaction-id=\"384ad10b\" data-e-type=\"widget\" data-id=\"384ad10b\">Demostraci\u00f3n animada de una f\u00f3rmula que llena varias celdas.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\t\t\t<h2 data-interaction-id=\"95ac349\" class=\"e-33c611de-d2f6 e-heading-base e-default-h2\" id=\"t-1736125624214\" data-e-type=\"widget\" data-id=\"95ac349\">6 funciones que generan desbordamiento en Excel<\/h2>\n\t\t\t\t\t<p class=\"e-56801b75-98cd e-paragraph-base e-default-p\" data-interaction-id=\"76564c75\" data-e-type=\"widget\" data-id=\"76564c75\">Las seis funciones est\u00e1n disponibles en Excel 2021 y Microsoft 365, adem\u00e1s de versiones posteriores compatibles. Elige la funci\u00f3n seg\u00fan el resultado que necesitas. La secci\u00f3n de sintaxis incluye un ejemplo de cada una.<\/p>\n\t\t<div class=\"elementor-element elementor-element-5eccad22 e-con e-atomic-element e-flexbox-base e-default-div e-41eb4856-f542 \" data-id=\"5eccad22\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5eccad22\" data-e-type=\"e-flexbox\" data-id=\"5eccad22\">\n    \t\t\t<a href=\"#t-1736125624217\" target=\"_self\" class=\"e-1f5de8ee-edec e-button-base e-default-a\" data-interaction-id=\"f6b7855\" data-e-type=\"widget\" data-id=\"f6b7855\">\n\tFILTRAR\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624218\" target=\"_self\" class=\"e-2c7e9e23-f78a e-button-base e-default-a\" data-interaction-id=\"6745ca27\" data-e-type=\"widget\" data-id=\"6745ca27\">\n\tORDENAR\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624219\" target=\"_self\" class=\"e-145befac-d88f e-button-base e-default-a\" data-interaction-id=\"4ab5ccfb\" data-e-type=\"widget\" data-id=\"4ab5ccfb\">\n\tORDENARPOR\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624220\" target=\"_self\" class=\"e-29181744-a89b e-button-base e-default-a\" data-interaction-id=\"32ab66b6\" data-e-type=\"widget\" data-id=\"32ab66b6\">\n\tUNICOS\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624221\" target=\"_self\" class=\"e-71033f13-7b82 e-button-base e-default-a\" data-interaction-id=\"34e8fbfa\" data-e-type=\"widget\" data-id=\"34e8fbfa\">\n\tSECUENCIA\n<\/a>\n\t\t\t\t\t<a href=\"#t-1736125624222\" target=\"_self\" class=\"e-33a86982-dacf e-button-base e-default-a\" data-interaction-id=\"2f3f4ec2\" data-e-type=\"widget\" data-id=\"2f3f4ec2\">\n\tMATRIZALEAT\n<\/a>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-57832f54 e-con e-atomic-element e-div-block-base e-default-section e-31b1e56c-6d4a \" data-id=\"57832f54\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"57832f54\" data-e-type=\"e-div-block\" data-id=\"57832f54\">\n    <div class=\"elementor-element elementor-element-78cbf28d e-con e-atomic-element e-flexbox-base e-default-div e-60c624e3-1bba \" data-id=\"78cbf28d\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"78cbf28d\" data-e-type=\"e-flexbox\" data-id=\"78cbf28d\">\n    \t\t\t<p class=\"e-1de15344-fbaf e-paragraph-base e-default-p\" data-interaction-id=\"79436895\" data-e-type=\"widget\" data-id=\"79436895\">ANTES DE ESCRIBIR LA F\u00d3RMULA<\/p>\n\t\t\t\t\t<h2 data-interaction-id=\"1969b136\" class=\"e-651f4b97-992d e-heading-base e-default-h2\" id=\"t-1736125624215\" data-e-type=\"widget\" data-id=\"1969b136\">C\u00f3mo trabajar con un rango desbordado<\/h2>\n\t\t<div class=\"elementor-element elementor-element-2e8de4b9 e-con e-atomic-element e-grid-base e-default-div e-46a95f4b-32b1 \" data-id=\"2e8de4b9\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"2e8de4b9\" data-e-type=\"e-grid\" data-id=\"2e8de4b9\">\n    <div class=\"elementor-element elementor-element-2fdde29c e-con e-atomic-element e-flexbox-base e-default-div e-6ec3ce5b-2dad \" data-id=\"2fdde29c\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2fdde29c\" data-e-type=\"e-flexbox\" data-id=\"2fdde29c\">\n    \t\t\t<p class=\"e-3ee5294f-b69c e-paragraph-base e-default-p\" data-interaction-id=\"52a4577c\" data-e-type=\"widget\" data-id=\"52a4577c\"><strong>Confirma con Entrar.<\/strong> Excel calcula el tama\u00f1o del rango de salida y lo ajusta cuando la f\u00f3rmula devuelve m\u00e1s o menos elementos.<\/p>\n\t\t\t\t\t<p class=\"e-7f806fa1-49fc e-paragraph-base e-default-p\" data-interaction-id=\"37ce7dcd\" data-e-type=\"widget\" data-id=\"37ce7dcd\"><strong>Usa la tabla como origen.<\/strong> Puedes filtrar datos de una tabla de Excel con referencias estructuradas, pero escribe la f\u00f3rmula en una celda fuera de ella para que tenga espacio para desbordarse.<\/p>\n\t\t\t\t\t<p class=\"e-2e3e4108-efe2 e-paragraph-base e-default-p\" data-interaction-id=\"319e002e\" data-e-type=\"widget\" data-id=\"319e002e\"><strong>Identifica la celda que contiene la f\u00f3rmula.<\/strong> Al seleccionar una celda del resultado, Excel resalta el rango con un borde. Solo se edita la celda superior izquierda. En las otras celdas, la barra de f\u00f3rmulas muestra el texto atenuado.<\/p>\n\t\t\t\t\t<p class=\"e-1b2b7f43-f275 e-paragraph-base e-default-p\" data-interaction-id=\"5de6a50b\" data-e-type=\"widget\" data-id=\"5de6a50b\">Si necesitas actualizar el criterio, cambia la f\u00f3rmula en la celda de origen y confirma con Entrar. El borde desaparece al seleccionar una celda fuera del rango.<\/p>\n\t\t\t\t\t<p class=\"e-6a0d6748-5447 e-paragraph-base e-default-p\" data-interaction-id=\"167021d8\" data-e-type=\"widget\" data-id=\"167021d8\"><strong>Referencia todo el resultado con #.<\/strong> Si la f\u00f3rmula de desbordamiento en Excel comienza en F2, F2# representa el rango completo y se adapta cuando cambia su tama\u00f1o. Consulta <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/dynamic-array-formulas-and-spilled-array-behavior\" target=\"_blank\" rel=\"noopener\">el comportamiento de las matrices din\u00e1micas<\/a>.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-3d7ce3ff e-con e-atomic-element e-flexbox-base e-default-div e-517b9583-6902 \" data-id=\"3d7ce3ff\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"3d7ce3ff\" data-e-type=\"e-flexbox\" data-id=\"3d7ce3ff\">\n    \t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Area-de-desbordamiento.png\" target=\"_blank\" class=\"e-image-link-base e-default-a\" data-interaction-id=\"58d49cbf\"><img decoding=\"async\" class=\"e-image-base e-default-img e-12a35243-ceb6\" data-e-type=\"widget\" data-id=\"58d49cbf\" id=\"48253\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Area-de-desbordamiento.png\" width=\"616\" height=\"207\" srcset=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Area-de-desbordamiento.png 616w, https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Area-de-desbordamiento-300x101.png 300w\" alt=\"Borde del rango de desbordamiento en Excel y celda inicial de la f\u00f3rmula\"\/>\t<\/a>\t\t\t\t\t<p class=\"e-6f5c7572-14c6 e-paragraph-base e-default-p\" data-interaction-id=\"7e618a6c\" data-e-type=\"widget\" data-id=\"7e618a6c\">Borde de selecci\u00f3n que identifica el \u00e1rea de desbordamiento.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-411e38f9 e-con e-atomic-element e-div-block-base e-default-section e-6f355401-3252 \" data-id=\"411e38f9\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"411e38f9\" data-e-type=\"e-div-block\" data-id=\"411e38f9\">\n    <div class=\"elementor-element elementor-element-2879cccc e-con e-atomic-element e-flexbox-base e-default-div e-6ceec567-124d \" data-id=\"2879cccc\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2879cccc\" data-e-type=\"e-flexbox\" data-id=\"2879cccc\">\n    \t\t\t<p class=\"e-7ad2c019-2447 e-paragraph-base e-default-p\" data-interaction-id=\"1698429\" data-e-type=\"widget\" data-id=\"1698429\">EJEMPLOS PARA COPIAR<\/p>\n\t\t\t\t\t<h2 data-interaction-id=\"22be4cf\" class=\"e-433ad4e5-8e84 e-heading-base e-default-h2\" id=\"t-1736125624216\" data-e-type=\"widget\" data-id=\"22be4cf\">Sintaxis y ejemplos de desbordamiento en Excel<\/h2>\n\t\t\t\t\t<p class=\"e-d0e9414-3a65 e-paragraph-base e-default-p\" data-interaction-id=\"1804b64e\" data-e-type=\"widget\" data-id=\"1804b64e\">Los argumentos entre corchetes son opcionales. Los ejemplos usan punto y coma como separador de argumentos. Si tu configuraci\u00f3n regional usa comas, adapta el separador al pegar la f\u00f3rmula.<\/p>\n\t\t<div class=\"elementor-element elementor-element-2da51732 e-con e-atomic-element e-flexbox-base e-default-div e-28fb65a0-7599 \" data-id=\"2da51732\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2da51732\" data-e-type=\"e-flexbox\" data-id=\"2da51732\">\n    \t\t\t<h3 data-interaction-id=\"5af2a53d\" class=\"e-78f3b787-783e e-heading-base e-default-h3\" id=\"datos-de-practica\" data-e-type=\"widget\" data-id=\"5af2a53d\">Datos para practicar en A1:D6<\/h3>\n\t\t\t\t\t<p class=\"e-67e83a2e-ce34 e-paragraph-base e-default-p\" data-interaction-id=\"63b4859e\" data-e-type=\"widget\" data-id=\"63b4859e\">Para reproducir los ejemplos de desbordamiento en Excel, copia estos datos con los encabezados en la fila 1. Escribe las f\u00f3rmulas en un \u00e1rea libre, fuera de la tabla de origen. Prueba cada ejemplo por separado o usa distintas zonas de la hoja para que sus resultados tengan espacio.<\/p>\n\t\t<div class=\"elementor-element elementor-element-51653c9 e-con e-atomic-element e-flexbox-base e-default-div e-6e7cabf2-d5e8 \" data-id=\"51653c9\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"51653c9\" data-e-type=\"e-flexbox\" data-id=\"51653c9\">\n    <div class=\"elementor-element elementor-element-29c1ac8a e-con e-atomic-element e-grid-base e-default-div e-3ee1ff48-3eea \" data-id=\"29c1ac8a\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"29c1ac8a\" data-e-type=\"e-grid\" data-id=\"29c1ac8a\">\n    \t\t\t<p class=\"e-15a5255b-16da e-paragraph-base e-default-p\" data-interaction-id=\"185feb40\" data-e-type=\"widget\" data-id=\"185feb40\">Cliente<\/p>\n\t\t\t\t\t<p class=\"e-223505b8-71e4 e-paragraph-base e-default-p\" data-interaction-id=\"26f83254\" data-e-type=\"widget\" data-id=\"26f83254\">Factura<\/p>\n\t\t\t\t\t<p class=\"e-39c024e4-d38c e-paragraph-base e-default-p\" data-interaction-id=\"4860971c\" data-e-type=\"widget\" data-id=\"4860971c\">Estado<\/p>\n\t\t\t\t\t<p class=\"e-175e2df1-54f3 e-paragraph-base e-default-p\" data-interaction-id=\"6a34a848\" data-e-type=\"widget\" data-id=\"6a34a848\">Saldo<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-3e408f2f e-con e-atomic-element e-grid-base e-default-div e-7685060a-f654 \" data-id=\"3e408f2f\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"3e408f2f\" data-e-type=\"e-grid\" data-id=\"3e408f2f\">\n    \t\t\t<p class=\"e-64c9f00e-16b5 e-paragraph-base e-default-p\" data-interaction-id=\"38c022ac\" data-e-type=\"widget\" data-id=\"38c022ac\">Ana<\/p>\n\t\t\t\t\t<p class=\"e-176a76ee-1747 e-paragraph-base e-default-p\" data-interaction-id=\"4c7062c5\" data-e-type=\"widget\" data-id=\"4c7062c5\">F-101<\/p>\n\t\t\t\t\t<p class=\"e-782c4933-ed9c e-paragraph-base e-default-p\" data-interaction-id=\"1cdaf5c1\" data-e-type=\"widget\" data-id=\"1cdaf5c1\">Pendiente<\/p>\n\t\t\t\t\t<p class=\"e-79c8a214-cc6d e-paragraph-base e-default-p\" data-interaction-id=\"1d34c90c\" data-e-type=\"widget\" data-id=\"1d34c90c\">120<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-500901f1 e-con e-atomic-element e-grid-base e-default-div e-229bf1a6-4aa2 \" data-id=\"500901f1\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"500901f1\" data-e-type=\"e-grid\" data-id=\"500901f1\">\n    \t\t\t<p class=\"e-57af8ad0-124f e-paragraph-base e-default-p\" data-interaction-id=\"5886fd9b\" data-e-type=\"widget\" data-id=\"5886fd9b\">Luis<\/p>\n\t\t\t\t\t<p class=\"e-6814ebfd-69eb e-paragraph-base e-default-p\" data-interaction-id=\"1af93557\" data-e-type=\"widget\" data-id=\"1af93557\">F-102<\/p>\n\t\t\t\t\t<p class=\"e-75e713c9-3823 e-paragraph-base e-default-p\" data-interaction-id=\"770c3bb6\" data-e-type=\"widget\" data-id=\"770c3bb6\">Pagada<\/p>\n\t\t\t\t\t<p class=\"e-59a51b51-d118 e-paragraph-base e-default-p\" data-interaction-id=\"5de2c8c0\" data-e-type=\"widget\" data-id=\"5de2c8c0\">0<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-5de88adb e-con e-atomic-element e-grid-base e-default-div e-b95b2c1-763d \" data-id=\"5de88adb\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"5de88adb\" data-e-type=\"e-grid\" data-id=\"5de88adb\">\n    \t\t\t<p class=\"e-662b312b-e562 e-paragraph-base e-default-p\" data-interaction-id=\"292566fd\" data-e-type=\"widget\" data-id=\"292566fd\">Ana<\/p>\n\t\t\t\t\t<p class=\"e-68f2a17-32c7 e-paragraph-base e-default-p\" data-interaction-id=\"2aafb7e0\" data-e-type=\"widget\" data-id=\"2aafb7e0\">F-103<\/p>\n\t\t\t\t\t<p class=\"e-2cb5e27d-5cfc e-paragraph-base e-default-p\" data-interaction-id=\"6eaf2eaa\" data-e-type=\"widget\" data-id=\"6eaf2eaa\">Pendiente<\/p>\n\t\t\t\t\t<p class=\"e-7819cca4-b760 e-paragraph-base e-default-p\" data-interaction-id=\"199e98ba\" data-e-type=\"widget\" data-id=\"199e98ba\">75<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-39823719 e-con e-atomic-element e-grid-base e-default-div e-779bf802-1673 \" data-id=\"39823719\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"39823719\" data-e-type=\"e-grid\" data-id=\"39823719\">\n    \t\t\t<p class=\"e-7e820b5-39e8 e-paragraph-base e-default-p\" data-interaction-id=\"27396db0\" data-e-type=\"widget\" data-id=\"27396db0\">Marta<\/p>\n\t\t\t\t\t<p class=\"e-77c42aa7-b5d5 e-paragraph-base e-default-p\" data-interaction-id=\"54a14186\" data-e-type=\"widget\" data-id=\"54a14186\">F-104<\/p>\n\t\t\t\t\t<p class=\"e-4dbe7a63-a1e7 e-paragraph-base e-default-p\" data-interaction-id=\"1eee4005\" data-e-type=\"widget\" data-id=\"1eee4005\">Pendiente<\/p>\n\t\t\t\t\t<p class=\"e-439ff8d9-803a e-paragraph-base e-default-p\" data-interaction-id=\"cf9af7\" data-e-type=\"widget\" data-id=\"cf9af7\">240<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-1262c12d e-con e-atomic-element e-grid-base e-default-div e-7488193b-490a \" data-id=\"1262c12d\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"1262c12d\" data-e-type=\"e-grid\" data-id=\"1262c12d\">\n    \t\t\t<p class=\"e-fca5756-d85c e-paragraph-base e-default-p\" data-interaction-id=\"415c3086\" data-e-type=\"widget\" data-id=\"415c3086\">Luis<\/p>\n\t\t\t\t\t<p class=\"e-6cf84c25-61cf e-paragraph-base e-default-p\" data-interaction-id=\"36821ee4\" data-e-type=\"widget\" data-id=\"36821ee4\">F-105<\/p>\n\t\t\t\t\t<p class=\"e-741cb126-33d6 e-paragraph-base e-default-p\" data-interaction-id=\"6964a373\" data-e-type=\"widget\" data-id=\"6964a373\">Pagada<\/p>\n\t\t\t\t\t<p class=\"e-692f1a99-2769 e-paragraph-base e-default-p\" data-interaction-id=\"22c888ff\" data-e-type=\"widget\" data-id=\"22c888ff\">0<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/div>\n<div class=\"elementor-element elementor-element-1f66c0d2 e-con e-atomic-element e-grid-base e-default-div e-7868cf5f-1a9e \" data-id=\"1f66c0d2\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"1f66c0d2\" data-e-type=\"e-grid\" data-id=\"1f66c0d2\">\n    <article class=\"elementor-element elementor-element-2314735d e-con e-atomic-element e-flexbox-base e-default-article e-1ad1920c-dea9 \" data-id=\"2314735d\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2314735d\" data-e-type=\"e-flexbox\" data-id=\"2314735d\">\n    \t\t\t<h3 data-interaction-id=\"51871167\" class=\"e-7130c5fb-b09d e-heading-base e-default-h3\" id=\"t-1736125624217\" data-e-type=\"widget\" data-id=\"51871167\">FILTRAR<\/h3>\n\t\t\t\t\t<p class=\"e-304b3f71-5f94 e-paragraph-base e-default-p\" data-interaction-id=\"2793e1b2\" data-e-type=\"widget\" data-id=\"2793e1b2\">FILTRAR(matriz; incluir; [si_vac\u00edo])<\/p>\n\t\t\t\t\t<p class=\"e-68295717-ead8 e-paragraph-base e-default-p\" data-interaction-id=\"568e3e2\" data-e-type=\"widget\" data-id=\"568e3e2\">Matriz es el rango de origen que quieres filtrar. Incluir es una matriz de valores l\u00f3gicos del mismo alto o ancho que la matriz, seg\u00fan filtres filas o columnas. Si_vac\u00edo indica qu\u00e9 devolver cuando ninguna entrada cumple la condici\u00f3n.<\/p>\n\t\t\t\t\t<p class=\"e-2083b4be-d568 e-paragraph-base e-default-p\" data-interaction-id=\"7ad026da\" data-e-type=\"widget\" data-id=\"7ad026da\">EJEMPLO<\/p>\n\t\t<div class=\"elementor-element elementor-element-3ef6e2ee e-con e-atomic-element e-div-block-base e-default-div e-57a4bb13-b4c3 \" data-id=\"3ef6e2ee\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"3ef6e2ee\" data-e-type=\"e-div-block\" data-id=\"3ef6e2ee\">\n    \t\t<div class=\"elementor-element elementor-element-5ee6ca85 elementor-widget elementor-widget-html\" data-id=\"5ee6ca85\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<div style=\"background:#e8f5ed;border:1px solid #d1e4dd;border-radius:.48rem;padding:.65rem .75rem;color:#174639\"><code style=\"font-family:ui-monospace,Consolas,monospace;font-size:.87rem;line-height:1.55;white-space:pre-wrap;overflow-wrap:anywhere;user-select:text\">=FILTRAR(A2:D6;D2:D6&gt;0;&quot;Sin pendientes&quot;)<\/code><\/div>\t\t\t\t<\/div>\n\t\t\n<\/div>\n\t\t\t<p class=\"e-2f5f13db-6fd5 e-paragraph-base e-default-p\" data-interaction-id=\"153710c4\" data-e-type=\"widget\" data-id=\"153710c4\">Muestra las tres facturas con saldo mayor que cero. Si escribes la f\u00f3rmula en F2, los resultados ocupan F2:I4. Cuando no haya facturas pendientes, aparecer\u00e1 el texto \u00abSin pendientes\u00bb.<\/p>\n\t\t\t\t\t<p class=\"e-1c993410-d64f e-paragraph-base e-default-p\" data-interaction-id=\"405fb922\" data-e-type=\"widget\" data-id=\"405fb922\"><a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/filter-function\" target=\"_blank\" rel=\"noopener\">Referencia de FILTRAR<\/a><\/p>\n\t\t\t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/la-funcion-filtrar.html\" target=\"_self\" class=\"e-5316ff9c-1309 e-button-base e-default-a\" data-interaction-id=\"2f780972\" data-e-type=\"widget\" data-id=\"2f780972\">\n\tVer la lecci\u00f3n de FILTRAR\n<\/a>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-5f55318b e-con e-atomic-element e-flexbox-base e-default-article e-6094dad4-2d7a \" data-id=\"5f55318b\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5f55318b\" data-e-type=\"e-flexbox\" data-id=\"5f55318b\">\n    \t\t\t<h3 data-interaction-id=\"2bf740d9\" class=\"e-1bd03595-e9f1 e-heading-base e-default-h3\" id=\"t-1736125624218\" data-e-type=\"widget\" data-id=\"2bf740d9\">ORDENAR<\/h3>\n\t\t\t\t\t<p class=\"e-62f7e3f6-270e e-paragraph-base e-default-p\" data-interaction-id=\"9bc37c8\" data-e-type=\"widget\" data-id=\"9bc37c8\">ORDENAR(matriz; [\u00edndice_orden]; [orden]; [por_col])<\/p>\n\t\t\t\t\t<p class=\"e-6bfde475-c65d e-paragraph-base e-default-p\" data-interaction-id=\"326162c3\" data-e-type=\"widget\" data-id=\"326162c3\">Matriz es el rango que quieres ordenar. \u00cdndice_orden se\u00f1ala la fila o columna que sirve de criterio. Usa 1 para ascendente y -1 para descendente. Por_col es FALSO de forma predeterminada para ordenar filas y VERDADERO para ordenar columnas.<\/p>\n\t\t\t\t\t<p class=\"e-40a8f830-5894 e-paragraph-base e-default-p\" data-interaction-id=\"65db233c\" data-e-type=\"widget\" data-id=\"65db233c\">EJEMPLO<\/p>\n\t\t\t\t\t<p class=\"e-6174566b-5e92 e-paragraph-base e-default-p\" data-interaction-id=\"4a1a821d\" data-e-type=\"widget\" data-id=\"4a1a821d\">=ORDENAR(A2:D6;4;-1)<\/p>\n\t\t\t\t\t<p class=\"e-692faedb-7473 e-paragraph-base e-default-p\" data-interaction-id=\"714ae149\" data-e-type=\"widget\" data-id=\"714ae149\">En este ejemplo de desbordamiento en Excel, ORDENAR organiza las filas por la cuarta columna, Saldo, de mayor a menor. La factura de 240 aparece primero y las de saldo cero quedan al final.<\/p>\n\t\t\t\t\t<p class=\"e-10341430-93bb e-paragraph-base e-default-p\" data-interaction-id=\"6e801d96\" data-e-type=\"widget\" data-id=\"6e801d96\"><a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/sort-function\" target=\"_blank\" rel=\"noopener\">Referencia de ORDENAR<\/a><\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-2e2931fa e-con e-atomic-element e-flexbox-base e-default-article e-34bb2b20-a999 \" data-id=\"2e2931fa\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2e2931fa\" data-e-type=\"e-flexbox\" data-id=\"2e2931fa\">\n    \t\t\t<h3 data-interaction-id=\"5b8a8c27\" class=\"e-28c6b2a5-3935 e-heading-base e-default-h3\" id=\"t-1736125624219\" data-e-type=\"widget\" data-id=\"5b8a8c27\">ORDENARPOR<\/h3>\n\t\t\t\t\t<p class=\"e-d4b4b26-abab e-paragraph-base e-default-p\" data-interaction-id=\"5a849e5b\" data-e-type=\"widget\" data-id=\"5a849e5b\">ORDENARPOR(matriz; por_matriz1; [orden1]; [por_matriz2]; [orden2]; ...)<\/p>\n\t\t\t\t\t<p class=\"e-25f22f0a-876f e-paragraph-base e-default-p\" data-interaction-id=\"70de4411\" data-e-type=\"widget\" data-id=\"70de4411\">Indica qu\u00e9 matriz vas a mostrar y el rango que define el primer criterio. Usa 1 para ascendente y -1 para descendente. Puedes agregar otro par de rango y orden. Cada rango de ordenaci\u00f3n debe corresponder a las filas o columnas de la matriz.<\/p>\n\t\t\t\t\t<p class=\"e-47ace818-2bd1 e-paragraph-base e-default-p\" data-interaction-id=\"105bd6c6\" data-e-type=\"widget\" data-id=\"105bd6c6\">EJEMPLO<\/p>\n\t\t\t\t\t<p class=\"e-40a1c35a-2441 e-paragraph-base e-default-p\" data-interaction-id=\"4d066154\" data-e-type=\"widget\" data-id=\"4d066154\">=ORDENARPOR(A2:D6;A2:A6;1;D2:D6;-1)<\/p>\n\t\t\t\t\t<p class=\"e-2c6c0365-f685 e-paragraph-base e-default-p\" data-interaction-id=\"120288ef\" data-e-type=\"widget\" data-id=\"120288ef\">Ordena primero por cliente y, dentro de cada cliente, por saldo de mayor a menor. As\u00ed, las dos facturas de Ana aparecen juntas y la de 120 precede a la de 75.<\/p>\n\t\t\t\t\t<p class=\"e-6beda816-18c9 e-paragraph-base e-default-p\" data-interaction-id=\"6e8c1192\" data-e-type=\"widget\" data-id=\"6e8c1192\"><a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/sortby-function\" target=\"_blank\" rel=\"noopener\">Referencia de ORDENARPOR<\/a><\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-52787471 e-con e-atomic-element e-flexbox-base e-default-article e-22d5f697-4878 \" data-id=\"52787471\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"52787471\" data-e-type=\"e-flexbox\" data-id=\"52787471\">\n    \t\t\t<h3 data-interaction-id=\"74b0a6f1\" class=\"e-bd53e3f-6ba6 e-heading-base e-default-h3\" id=\"t-1736125624220\" data-e-type=\"widget\" data-id=\"74b0a6f1\">UNICOS<\/h3>\n\t\t\t\t\t<p class=\"e-6e789c11-96de e-paragraph-base e-default-p\" data-interaction-id=\"6ff18f8\" data-e-type=\"widget\" data-id=\"6ff18f8\">UNICOS(matriz; [por_col]; [exactamente_una_vez])<\/p>\n\t\t\t\t\t<p class=\"e-73100346-b784 e-paragraph-base e-default-p\" data-interaction-id=\"13ce1f88\" data-e-type=\"widget\" data-id=\"13ce1f88\">Por_col en FALSO u omitido compara filas, y VERDADERO compara columnas. Exactamente_una_vez en VERDADERO devuelve solo las entradas que aparecen una vez. Si se omite o es FALSO, devuelve los valores distintos.<\/p>\n\t\t\t\t\t<p class=\"e-2b960c5a-ebea e-paragraph-base e-default-p\" data-interaction-id=\"7ccde1f1\" data-e-type=\"widget\" data-id=\"7ccde1f1\">EJEMPLO<\/p>\n\t\t\t\t\t<p class=\"e-36e3cc06-f725 e-paragraph-base e-default-p\" data-interaction-id=\"67243c86\" data-e-type=\"widget\" data-id=\"67243c86\">=UNICOS(A2:A6)<\/p>\n\t\t\t\t\t<p class=\"e-59426ca6-e581 e-paragraph-base e-default-p\" data-interaction-id=\"4d6f66ea\" data-e-type=\"widget\" data-id=\"4d6f66ea\">Devuelve Ana, Luis y Marta. Si quieres solo clientes con una aparici\u00f3n en esta lista, usa VERDADERO en el tercer argumento. En estos datos, el resultado ser\u00eda Marta.<\/p>\n\t\t\t\t\t<p class=\"e-6e83648c-7b84 e-paragraph-base e-default-p\" data-interaction-id=\"3214f515\" data-e-type=\"widget\" data-id=\"3214f515\"><a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/unique-function\" target=\"_blank\" rel=\"noopener\">Referencia de UNICOS<\/a><\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-7a061316 e-con e-atomic-element e-flexbox-base e-default-article e-2c8bd4d6-b139 \" data-id=\"7a061316\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"7a061316\" data-e-type=\"e-flexbox\" data-id=\"7a061316\">\n    \t\t\t<h3 data-interaction-id=\"4040fb04\" class=\"e-9a09b44-3293 e-heading-base e-default-h3\" id=\"t-1736125624221\" data-e-type=\"widget\" data-id=\"4040fb04\">SECUENCIA<\/h3>\n\t\t\t\t\t<p class=\"e-75b8b801-8973 e-paragraph-base e-default-p\" data-interaction-id=\"739d18b8\" data-e-type=\"widget\" data-id=\"739d18b8\">SECUENCIA(filas; [columnas]; [inicio]; [paso])<\/p>\n\t\t\t\t\t<p class=\"e-2a5fd4e2-a641 e-paragraph-base e-default-p\" data-interaction-id=\"487c276c\" data-e-type=\"widget\" data-id=\"487c276c\">Filas y columnas fijan las dimensiones de la matriz. Inicio define el primer n\u00famero y paso cu\u00e1nto aumenta o disminuye cada valor. Con una columna puedes generar una lista vertical de identificadores de prueba.<\/p>\n\t\t\t\t\t<p class=\"e-2e3969e6-cf0c e-paragraph-base e-default-p\" data-interaction-id=\"4607e9db\" data-e-type=\"widget\" data-id=\"4607e9db\">EJEMPLO<\/p>\n\t\t\t\t\t<p class=\"e-7b25d030-687e e-paragraph-base e-default-p\" data-interaction-id=\"750626ba\" data-e-type=\"widget\" data-id=\"750626ba\">=SECUENCIA(4;1;1001;1)<\/p>\n\t\t\t\t\t<p class=\"e-8991306-4759 e-paragraph-base e-default-p\" data-interaction-id=\"212aaf8\" data-e-type=\"widget\" data-id=\"212aaf8\">Con SECUENCIA, el desbordamiento en Excel genera 1001, 1002, 1003 y 1004. Cambia el argumento filas para ampliar la lista o usa m\u00e1s columnas si necesitas una cuadr\u00edcula.<\/p>\n\t\t\t\t\t<p class=\"e-1038ef75-3587 e-paragraph-base e-default-p\" data-interaction-id=\"46cc2bc2\" data-e-type=\"widget\" data-id=\"46cc2bc2\"><a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/sequence-function\" target=\"_blank\" rel=\"noopener\">Referencia de SECUENCIA<\/a><\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-5c3401d9 e-con e-atomic-element e-flexbox-base e-default-article e-2f97cb60-400d \" data-id=\"5c3401d9\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5c3401d9\" data-e-type=\"e-flexbox\" data-id=\"5c3401d9\">\n    \t\t\t<h3 data-interaction-id=\"15b6e7fd\" class=\"e-560b0875-a15b e-heading-base e-default-h3\" id=\"t-1736125624222\" data-e-type=\"widget\" data-id=\"15b6e7fd\">MATRIZALEAT<\/h3>\n\t\t\t\t\t<p class=\"e-655c706f-3844 e-paragraph-base e-default-p\" data-interaction-id=\"4d3342ab\" data-e-type=\"widget\" data-id=\"4d3342ab\">MATRIZALEAT([filas]; [columnas]; [m\u00ednimo]; [m\u00e1ximo]; [entero])<\/p>\n\t\t\t\t\t<p class=\"e-1b9ce5b0-7ba1 e-paragraph-base e-default-p\" data-interaction-id=\"13ac1e33\" data-e-type=\"widget\" data-id=\"13ac1e33\">Filas y columnas definen el tama\u00f1o. M\u00ednimo y m\u00e1ximo acotan los valores. El \u00faltimo argumento es VERDADERO para obtener enteros y FALSO para obtener decimales.<\/p>\n\t\t\t\t\t<p class=\"e-3df3234f-4e03 e-paragraph-base e-default-p\" data-interaction-id=\"3c0abd19\" data-e-type=\"widget\" data-id=\"3c0abd19\">EJEMPLO<\/p>\n\t\t\t\t\t<p class=\"e-19211d57-d6d1 e-paragraph-base e-default-p\" data-interaction-id=\"6ad9ab2b\" data-e-type=\"widget\" data-id=\"6ad9ab2b\">=MATRIZALEAT(3;2;10;50;VERDADERO)<\/p>\n\t\t\t\t\t<p class=\"e-4c9cd48d-b34d e-paragraph-base e-default-p\" data-interaction-id=\"32b0476b\" data-e-type=\"widget\" data-id=\"32b0476b\">Genera tres filas y dos columnas de enteros entre 10 y 50. Los valores pueden cambiar al recalcular. Si necesitas conservar una muestra de prueba, copia el resultado y p\u00e9galo como valores.<\/p>\n\t\t\t\t\t<p class=\"e-2e75a0e3-28b4 e-paragraph-base e-default-p\" data-interaction-id=\"2e0e50d\" data-e-type=\"widget\" data-id=\"2e0e50d\"><a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/functions\/randarray-function\" target=\"_blank\" rel=\"noopener\">Referencia de MATRIZALEAT<\/a><\/p>\n\t\t\n<\/article>\n\n<\/div>\n<div class=\"elementor-element elementor-element-16d5e294 e-con e-atomic-element e-flexbox-base e-default-div e-3d42bb4f-9920 \" data-id=\"16d5e294\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"16d5e294\" data-e-type=\"e-flexbox\" data-id=\"16d5e294\">\n    \t\t\t<h3 data-interaction-id=\"13c003f\" class=\"e-66b96adf-aa39 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"13c003f\">Cuenta las filas sin fijar el tama\u00f1o del rango<\/h3>\n\t\t\t\t\t<p class=\"e-7dad1f1f-5f0d e-paragraph-base e-default-p\" data-interaction-id=\"9a721fb\" data-e-type=\"widget\" data-id=\"9a721fb\">Despu\u00e9s de probar FILTRAR en F2, escribe esta f\u00f3rmula en una zona libre. Cuenta las filas del resultado usando el operador #. Con los datos del ejemplo devuelve 3 y se ajusta si cambia la cantidad de facturas pendientes.<\/p>\n\t\t\t\t\t<p class=\"e-3c178492-ec2d e-paragraph-base e-default-p\" data-interaction-id=\"638275d1\" data-e-type=\"widget\" data-id=\"638275d1\">=FILAS(F2#)<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-4dc8c818 e-con e-atomic-element e-flexbox-base e-default-div e-4dc8c818-6b36 \" data-id=\"4dc8c818\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"4dc8c818\" data-e-type=\"e-flexbox\" data-id=\"4dc8c818\">\n    \t\t\t<h3 data-interaction-id=\"7f2a2b21\" class=\"e-7f2a2b21-d8a2 e-heading-base e-default-h3\" id=\"practica-reporte-facturas\" data-e-type=\"widget\" data-id=\"7f2a2b21\">Un reporte de facturas con desbordamiento en Excel<\/h3>\n\t\t\t\t\t<p class=\"e-8f470dd6-f0af e-paragraph-base e-default-p\" data-interaction-id=\"8f470dd6\" data-e-type=\"widget\" data-id=\"8f470dd6\">Construye un reporte que se actualice cuando agregues una factura. Usa los datos de pr\u00e1ctica de A1:D6 en una copia del libro. Deja las columnas F:I para mostrar el resultado y utiliza K2 y K3 para revisar el n\u00famero de facturas y el saldo pendiente.<\/p>\n\t\t\t\t\t<p class=\"e-ad8c5533-0116 e-paragraph-base e-default-p\" data-interaction-id=\"ad8c5533\" data-e-type=\"widget\" data-id=\"ad8c5533\"><strong>1. Convierte la base en tabla.<\/strong> Selecciona A1:D6 y elige Insertar \u2192 Tabla. Indica que la primera fila contiene los encabezados y asigna el nombre Facturas en Dise\u00f1o de tabla. Verifica que el encabezado de D1 sea Saldo. El desbordamiento en Excel puede consultar una tabla como origen y devolver sus resultados en una zona separada.<\/p>\n\t\t\t\t\t<p class=\"e-c22ac8eb-dc30 e-paragraph-base e-default-p\" data-interaction-id=\"c22ac8eb\" data-e-type=\"widget\" data-id=\"c22ac8eb\"><strong>2. Crea el reporte en F2.<\/strong> Escribe la siguiente f\u00f3rmula fuera de la tabla. Al usar Facturas y Facturas[Saldo], Excel toma las filas de la tabla y mantiene alineado el criterio de saldo con cada registro. Las referencias se ajustan al incorporar filas en Facturas.<\/p>\n\t\t\t\t<div class=\"elementor-element elementor-element-18c878fa elementor-widget elementor-widget-html\" data-id=\"18c878fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<div style=\"background:#e8f5ed;border:1px solid #d1e4dd;border-radius:.48rem;padding:.65rem .75rem;color:#174639\"><code style=\"font-family:ui-monospace,Consolas,monospace;font-size:.87rem;line-height:1.55;white-space:pre-wrap;overflow-wrap:anywhere;user-select:text\">=FILTRAR(Facturas;Facturas[Saldo]&gt;0;&quot;Sin pendientes&quot;)<\/code><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t<p class=\"e-c5d4f4b9-9839 e-paragraph-base e-default-p\" data-interaction-id=\"c5d4f4b9\" data-e-type=\"widget\" data-id=\"c5d4f4b9\"><strong>3. Comprueba el resultado con dos indicadores.<\/strong> En K2 cuenta las facturas con saldo positivo. En K3 suma esos mismos saldos. Con los datos iniciales, deber\u00edas obtener tres facturas y un saldo de 435. Estos indicadores permiten verificar el reporte sin depender de cu\u00e1ntas celdas ocupe el desbordamiento en Excel.<\/p>\n\t\t\t\t<div class=\"elementor-element elementor-element-9891b935 elementor-widget elementor-widget-html\" data-id=\"9891b935\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<div style=\"background:#e8f5ed;border:1px solid #d1e4dd;border-radius:.48rem;padding:.65rem .75rem;color:#174639\"><code style=\"font-family:ui-monospace,Consolas,monospace;font-size:.87rem;line-height:1.55;white-space:pre-wrap;overflow-wrap:anywhere;user-select:text\">=CONTAR.SI(Facturas[Saldo];&quot;&gt;0&quot;)<\/code><\/div>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8af2c8af elementor-widget elementor-widget-html\" data-id=\"8af2c8af\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<div style=\"background:#e8f5ed;border:1px solid #d1e4dd;border-radius:.48rem;padding:.65rem .75rem;color:#174639\"><code style=\"font-family:ui-monospace,Consolas,monospace;font-size:.87rem;line-height:1.55;white-space:pre-wrap;overflow-wrap:anywhere;user-select:text\">=SUMAR.SI(Facturas[Saldo];&quot;&gt;0&quot;;Facturas[Saldo])<\/code><\/div>\t\t\t\t<\/div>\n\t\t\t\t\t<p class=\"e-4608ce23-fd42 e-paragraph-base e-default-p\" data-interaction-id=\"4608ce23\" data-e-type=\"widget\" data-id=\"4608ce23\"><strong>4. Agrega una factura al final de la tabla.<\/strong> Escribe Marta, F-106, Pendiente y 60 en la fila siguiente. Comprueba que la nueva fila pertenezca a Facturas. El reporte debe pasar de F2:I4 a F2:I5, y los indicadores deben mostrar cuatro facturas y 495 de saldo.<\/p>\n\t\t\t\t\t<p class=\"e-616632c0-5a84 e-paragraph-base e-default-p\" data-interaction-id=\"616632c0\" data-e-type=\"widget\" data-id=\"616632c0\">Para comprobar que el desbordamiento en Excel se ajusta al registrar un pago, cambia el saldo de F-101 a cero y marca su estado como Pagada. Debe desaparecer del reporte, y los indicadores deben bajar a tres facturas y 375 de saldo. Si la fila sigue visible, revisa el saldo de origen y confirma que lo cambiaste en la tabla Facturas.<\/p>\n\t\t\t\t\t<p class=\"e-10bdf1aa-1a40 e-paragraph-base e-default-p\" data-interaction-id=\"10bdf1aa\" data-e-type=\"widget\" data-id=\"10bdf1aa\">Si tu tabla usa otro nombre o encabezado, sustituye esos nombres en las f\u00f3rmulas. Puedes consultar la <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/using-structured-references-with-excel-tables\" target=\"_blank\" rel=\"noopener\">gu\u00eda de referencias estructuradas de Microsoft<\/a> para adaptar el ejemplo a tu archivo.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-4fc75e82 e-con e-atomic-element e-div-block-base e-default-section e-68d7bb60-4d6b \" data-id=\"4fc75e82\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"4fc75e82\" data-e-type=\"e-div-block\" data-id=\"4fc75e82\">\n    <div class=\"elementor-element elementor-element-5baa3016 e-con e-atomic-element e-flexbox-base e-default-div e-49208236-2d03 \" data-id=\"5baa3016\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5baa3016\" data-e-type=\"e-flexbox\" data-id=\"5baa3016\">\n    \t\t\t<p class=\"e-439a835a-e06b e-paragraph-base e-default-p\" data-interaction-id=\"4fe7d1a1\" data-e-type=\"widget\" data-id=\"4fe7d1a1\">ENCUENTRA LA CAUSA<\/p>\n\t\t\t\t\t<h2 data-interaction-id=\"2b7bfa24\" class=\"e-6159613-9da1 e-heading-base e-default-h2\" id=\"solucionar-error-desbordamiento\" data-e-type=\"widget\" data-id=\"2b7bfa24\">C\u00f3mo corregir el error #\u00a1DESBORDAMIENTO!<\/h2>\n\t\t\t\t\t<p class=\"e-2165da17-a8b4 e-paragraph-base e-default-p\" data-interaction-id=\"13570fb3\" data-e-type=\"widget\" data-id=\"13570fb3\">El error de desbordamiento en Excel aparece cuando una f\u00f3rmula devuelve varios valores y Excel no puede colocarlos en la cuadr\u00edcula. Empieza por identificar el \u00e1rea de salida prevista y qu\u00e9 la est\u00e1 bloqueando.<\/p>\n\t\t<div class=\"elementor-element elementor-element-4d7df0a1 e-con e-atomic-element e-grid-base e-default-div e-3f174cb7-7140 \" data-id=\"4d7df0a1\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"4d7df0a1\" data-e-type=\"e-grid\" data-id=\"4d7df0a1\">\n    <article class=\"elementor-element elementor-element-5fe41647 e-con e-atomic-element e-flexbox-base e-default-article e-1b53e619-a2c2 \" data-id=\"5fe41647\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5fe41647\" data-e-type=\"e-flexbox\" data-id=\"5fe41647\">\n    \t\t\t<h3 data-interaction-id=\"23baeb2b\" class=\"e-3604b570-1fa1 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"23baeb2b\">Rango ocupado<\/h3>\n\t\t\t\t\t<p class=\"e-78972d51-285a e-paragraph-base e-default-p\" data-interaction-id=\"28eaf3fe\" data-e-type=\"widget\" data-id=\"28eaf3fe\">Selecciona la celda con el error para ver el borde discontinuo del \u00e1rea prevista. Abre la advertencia y usa Seleccionar celdas con obstrucci\u00f3n. Mueve la anotaci\u00f3n o la f\u00f3rmula a otra zona si necesitas conservarla.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-3144e75b e-con e-atomic-element e-flexbox-base e-default-article e-5a4a4b26-424b \" data-id=\"3144e75b\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"3144e75b\" data-e-type=\"e-flexbox\" data-id=\"3144e75b\">\n    \t\t\t<h3 data-interaction-id=\"6e674ef6\" class=\"e-296464f3-b762 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"6e674ef6\">Celdas que parecen vac\u00edas<\/h3>\n\t\t\t\t\t<p class=\"e-214f1eaa-7a41 e-paragraph-base e-default-p\" data-interaction-id=\"36cbadcc\" data-e-type=\"widget\" data-id=\"36cbadcc\">Una f\u00f3rmula que devuelve una cadena vac\u00eda sigue ocupando la celda. Revisa la barra de f\u00f3rmulas de la celda se\u00f1alada y mueve esa f\u00f3rmula antes de probar UNICOS otra vez.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-431aa2cc e-con e-atomic-element e-flexbox-base e-default-article e-3d4fd2ef-b8e6 \" data-id=\"431aa2cc\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"431aa2cc\" data-e-type=\"e-flexbox\" data-id=\"431aa2cc\">\n    \t\t\t<h3 data-interaction-id=\"432f3831\" class=\"e-1488851b-aa50 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"432f3831\">Celdas combinadas<\/h3>\n\t\t\t\t\t<p class=\"e-716ec3ca-7411 e-paragraph-base e-default-p\" data-interaction-id=\"57f4174d\" data-e-type=\"widget\" data-id=\"57f4174d\">Si el rango cruza una celda combinada, separa esa combinaci\u00f3n o traslada la f\u00f3rmula a otra \u00e1rea. Comprueba que todo el espacio previsto quede disponible.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-5a9640a0 e-con e-atomic-element e-flexbox-base e-default-article e-5bcbe79-bf82 \" data-id=\"5a9640a0\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5a9640a0\" data-e-type=\"e-flexbox\" data-id=\"5a9640a0\">\n    \t\t\t<h3 data-interaction-id=\"3611ffd4\" class=\"e-58d4b157-5145 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"3611ffd4\">F\u00f3rmula dentro de una tabla<\/h3>\n\t\t\t\t\t<p class=\"e-3e3b2baa-2d4d e-paragraph-base e-default-p\" data-interaction-id=\"4f8780b7\" data-e-type=\"widget\" data-id=\"4f8780b7\">Para usar SECUENCIA o FILTRAR con una tabla de Excel como origen, escribe la f\u00f3rmula fuera de la tabla. La tabla puede seguir guardando tus datos y ampliarse con nuevas filas.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-59c15048 e-con e-atomic-element e-flexbox-base e-default-article e-15adcf24-8341 \" data-id=\"59c15048\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"59c15048\" data-e-type=\"e-flexbox\" data-id=\"59c15048\">\n    \t\t\t<h3 data-interaction-id=\"6a46beaa\" class=\"e-755da6c5-355d e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"6a46beaa\">Resultados que salen de la hoja<\/h3>\n\t\t\t\t\t<p class=\"e-5915b299-13f6 e-paragraph-base e-default-p\" data-interaction-id=\"ce8f092\" data-e-type=\"widget\" data-id=\"ce8f092\">Si el desbordamiento en Excel intenta pasar de la \u00faltima fila, mueve la f\u00f3rmula a una zona con espacio o reduce el rango que usa ORDENARPOR. Evita columnas completas si puedes usar un rango definido.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-41a7a480 e-con e-atomic-element e-flexbox-base e-default-article e-52444a8-f857 \" data-id=\"41a7a480\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"41a7a480\" data-e-type=\"e-flexbox\" data-id=\"41a7a480\">\n    \t\t\t<h3 data-interaction-id=\"21286395\" class=\"e-51914ce-bf5d e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"21286395\">Tama\u00f1o que cambia durante el c\u00e1lculo<\/h3>\n\t\t\t\t\t<p class=\"e-19d8ac89-51c4 e-paragraph-base e-default-p\" data-interaction-id=\"4128de1f\" data-e-type=\"widget\" data-id=\"4128de1f\">Una dimensi\u00f3n aleatoria puede impedir que Excel determine cu\u00e1ntas celdas necesita. Usa un n\u00famero fijo para las filas y columnas de prueba. En MATRIZALEAT pueden variar los valores y mantenerse fijas las dimensiones.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-6cc65c10 e-con e-atomic-element e-flexbox-base e-default-article e-802c3ff-87c4 \" data-id=\"6cc65c10\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"6cc65c10\" data-e-type=\"e-flexbox\" data-id=\"6cc65c10\">\n    \t\t\t<h3 data-interaction-id=\"602eb780\" class=\"e-7a6986c1-fba7 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"602eb780\">Rango demasiado grande<\/h3>\n\t\t\t\t\t<p class=\"e-5710056b-70e7 e-paragraph-base e-default-p\" data-interaction-id=\"713c49f9\" data-e-type=\"widget\" data-id=\"713c49f9\">Si Excel indica memoria insuficiente, prueba con menos filas o columnas. Usa una tabla de origen o un rango que incluya solo los registros que necesitas.<\/p>\n\t\t\n<\/article>\n\n<\/div>\n\t\t\t<p class=\"e-50ef6129-d3c2 e-paragraph-base e-default-p\" data-interaction-id=\"24c32cf1\" data-e-type=\"widget\" data-id=\"24c32cf1\">Consulta <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/how-to-correct-a-spill-error\" target=\"_blank\" rel=\"noopener\">la gu\u00eda de Microsoft para corregir #\u00a1DESBORDAMIENTO!<\/a> si la advertencia muestra una causa distinta.<\/p>\n\t\t<div class=\"elementor-element elementor-element-9f77047a e-con e-atomic-element e-flexbox-base e-default-div e-9f77047a-9234 \" data-id=\"9f77047a\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"9f77047a\" data-e-type=\"e-flexbox\" data-id=\"9f77047a\">\n    \t\t\t<h3 data-interaction-id=\"022cce94\" class=\"e-022cce94-beb8 e-heading-base e-default-h3\" id=\"ejercicio-error-desbordamiento\" data-e-type=\"widget\" data-id=\"022cce94\">Ejercicio para corregir un error de desbordamiento en Excel<\/h3>\n\t\t\t\t\t<p class=\"e-9fc44c5e-dde9 e-paragraph-base e-default-p\" data-interaction-id=\"9fc44c5e\" data-e-type=\"widget\" data-id=\"9fc44c5e\">Haz el ejercicio en una copia. Si probaste el reporte anterior y agregaste F-106, vuelve a los datos iniciales de A1:D6. La f\u00f3rmula de FILTRAR con esos cinco registros debe mostrar tres filas y cuatro columnas desde F2.<\/p>\n\t\t\t\t\t<p class=\"e-d0bb3972-4b1b e-paragraph-base e-default-p\" data-interaction-id=\"d0bb3972\" data-e-type=\"widget\" data-id=\"d0bb3972\"><strong>1. Reproduce la obstrucci\u00f3n.<\/strong> Quita temporalmente la f\u00f3rmula de F2 y escribe una nota de prueba en G3. Vuelve a introducir el ejemplo de FILTRAR en F2. Ver\u00e1s el error porque G3 queda dentro de F2:I4. Al seleccionar F2, el borde discontinuo indica d\u00f3nde intentaba colocar los resultados el desbordamiento en Excel.<\/p>\n\t\t\t\t\t<p class=\"e-e6c192e4-fde9 e-paragraph-base e-default-p\" data-interaction-id=\"e6c192e4\" data-e-type=\"widget\" data-id=\"e6c192e4\"><strong>2. Ubica la celda que bloquea.<\/strong> Abre el men\u00fa de advertencia junto a F2 y usa Seleccionar celdas con obstrucci\u00f3n. Mueve la nota de G3 a K6 para conservarla. La f\u00f3rmula en F2 debe recalcularse y volver a mostrar las tres facturas. Compara sus n\u00fameros con F-101, F-103 y F-104.<\/p>\n\t\t\t\t\t<p class=\"e-992b87d5-343e e-paragraph-base e-default-p\" data-interaction-id=\"992b87d5\" data-e-type=\"widget\" data-id=\"992b87d5\"><strong>3. Comprueba una celda que parece vac\u00eda.<\/strong> Retira otra vez la f\u00f3rmula de F2 y coloca en G3 una f\u00f3rmula que devuelva texto vac\u00edo. Al volver a introducir FILTRAR, el desbordamiento en Excel se bloquea aunque G3 no muestre texto. Selecciona G3 y mira la barra de f\u00f3rmulas para identificar el contenido.<\/p>\n\t\t\t\t\t<p class=\"e-1277688a-1ec3 e-paragraph-base e-default-p\" data-interaction-id=\"1277688a\" data-e-type=\"widget\" data-id=\"1277688a\">Si la f\u00f3rmula de G3 debe permanecer donde est\u00e1, mueve FILTRAR a una zona libre, como F8:I10. Comprueba las tres filas y actualiza cualquier f\u00f3rmula de resumen que todav\u00eda apunte a F2#. Trasladar la f\u00f3rmula tambi\u00e9n sirve cuando el \u00e1rea original atraviesa una celda combinada.<\/p>\n\t\t\n<\/div>\n<div class=\"elementor-element elementor-element-7f438c2f e-con e-atomic-element e-flexbox-base e-default-div e-7f438c2f-bee2 \" data-id=\"7f438c2f\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"7f438c2f\" data-e-type=\"e-flexbox\" data-id=\"7f438c2f\">\n    \t\t\t<h3 data-interaction-id=\"c62fcbc1\" class=\"e-c62fcbc1-1ab1 e-heading-base e-default-h3\" id=\"diferencias-errores-de-excel\" data-e-type=\"widget\" data-id=\"c62fcbc1\">C\u00f3mo distinguir el desbordamiento en Excel de otros errores<\/h3>\n\t\t\t\t\t<p class=\"e-ef416518-6893 e-paragraph-base e-default-p\" data-interaction-id=\"ef416518\" data-e-type=\"widget\" data-id=\"ef416518\">Empieza por leer el mensaje de la celda. Una matriz puede tener espacio suficiente y mostrar otro error por el criterio de b\u00fasqueda, la versi\u00f3n de Excel o el origen de los datos. Estas comprobaciones te ayudan a elegir la correcci\u00f3n adecuada.<\/p>\n\t\t\t\t\t<p class=\"e-b7517f29-88db e-paragraph-base e-default-p\" data-interaction-id=\"b7517f29\" data-e-type=\"widget\" data-id=\"b7517f29\"><strong>FILTRAR sin resultados.<\/strong> Prueba un criterio que ninguna factura cumpla, como un saldo mayor que 500 en la base inicial. Si omitiste el argumento si_vac\u00edo, Excel puede devolver un error de c\u00e1lculo porque la matriz quedar\u00eda vac\u00eda. Agrega el mensaje \u00abSin pendientes\u00bb como tercer argumento. En este caso, despejar celdas no cambia el resultado.<\/p>\n\t\t\t\t\t<p class=\"e-7e1d6166-971b e-paragraph-base e-default-p\" data-interaction-id=\"7e1d6166\" data-e-type=\"widget\" data-id=\"7e1d6166\"><strong>#\u00bfNOMBRE? o prefijo _xlfn.<\/strong> Si una funci\u00f3n de desbordamiento en Excel no se reconoce, verifica su nombre en el idioma de tu aplicaci\u00f3n y comprueba que tu versi\u00f3n admita la funci\u00f3n. En un libro compartido con alguien que usa una versi\u00f3n anterior, conviene comprobar la compatibilidad antes de enviar el reporte.<\/p>\n\t\t\t\t\t<p class=\"e-93be7a06-774f e-paragraph-base e-default-p\" data-interaction-id=\"93be7a06\" data-e-type=\"widget\" data-id=\"93be7a06\"><strong>#\u00a1REF! en un archivo vinculado.<\/strong> Las matrices din\u00e1micas vinculadas entre libros tienen compatibilidad limitada cuando se cierra el archivo de origen. Abre ambos archivos para comprobarlo. Si el reporte debe funcionar por separado, considera reunir la tabla de origen y la f\u00f3rmula en el mismo libro.<\/p>\n\t\t\t\t\t<p class=\"e-e23cea5d-bd2c e-paragraph-base e-default-p\" data-interaction-id=\"e23cea5d\" data-e-type=\"widget\" data-id=\"e23cea5d\"><strong>Solo ves un valor.<\/strong> Revisa si la f\u00f3rmula contiene el operador @. Puede indicar que Excel toma un solo elemento de un rango. Si buscas una lista con desbordamiento en Excel, revisa el prop\u00f3sito de la f\u00f3rmula original antes de cambiar ese operador y confirma que haya espacio para la lista.<\/p>\n\t\t\t\t\t<p class=\"e-50a724f3-85ae e-paragraph-base e-default-p\" data-interaction-id=\"50a724f3\" data-e-type=\"widget\" data-id=\"50a724f3\">Por \u00faltimo, prueba con un registro que cumpla el criterio y otro que no lo cumpla. Si la salida cambia al editar la base, el reporte sigue siendo din\u00e1mico. Si pegaste los resultados como valores, repite la f\u00f3rmula cuando necesites actualizar la lista.<\/p>\n\t\t\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-620f2612 e-con e-atomic-element e-div-block-base e-default-section e-509d0610-a2f7 \" data-id=\"620f2612\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"620f2612\" data-e-type=\"e-div-block\" data-id=\"620f2612\">\n    <div class=\"elementor-element elementor-element-2122cb0b e-con e-atomic-element e-flexbox-base e-default-div e-69398ee5-9c86 \" data-id=\"2122cb0b\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2122cb0b\" data-e-type=\"e-flexbox\" data-id=\"2122cb0b\">\n    \t\t\t<p class=\"e-492ae3b8-faec e-paragraph-base e-default-p\" data-interaction-id=\"2adf124\" data-e-type=\"widget\" data-id=\"2adf124\">CURSO EN VIDEO<\/p>\n\t\t\t\t\t<h2 data-interaction-id=\"6087da0a\" class=\"e-627c56b8-13f0 e-heading-base e-default-h2\" id=\"videos-desbordamiento-excel\" data-e-type=\"widget\" data-id=\"6087da0a\">Desbordamiento en Excel en 3 videos<\/h2>\n\t\t\t\t\t<p class=\"e-45f4a7cc-4675 e-paragraph-base e-default-p\" data-interaction-id=\"6ac421b7\" data-e-type=\"widget\" data-id=\"6ac421b7\">Mira primero c\u00f3mo funcionan las matrices din\u00e1micas. Despu\u00e9s identifica la causa del error y aplica las correcciones a los mismos ejercicios.<\/p>\n\t\t<div class=\"elementor-element elementor-element-244bd742 e-con e-atomic-element e-grid-base e-default-div e-5161dfba-b11b \" data-id=\"244bd742\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"244bd742\" data-e-type=\"e-grid\" data-id=\"244bd742\">\n    <article class=\"elementor-element elementor-element-235a3059 e-con e-atomic-element e-flexbox-base e-default-article e-41f7aa8f-5cdf \" data-id=\"235a3059\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"235a3059\" data-e-type=\"e-flexbox\" data-id=\"235a3059\">\n    \t\t\t<p class=\"e-118f491b-abb9 e-paragraph-base e-default-p\" data-interaction-id=\"3da1cadc\" data-e-type=\"widget\" data-id=\"3da1cadc\">PARTE 1 DE 3<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"1cfb94d9\" class=\"e-1ff0738e-4322 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"1cfb94d9\">Seis funciones de matrices din\u00e1micas<\/h3>\n\t\t\t\t\t<div data-id=\"65fd01e0\" data-interaction-id=\"65fd01e0\" data-e-type=\"e-youtube\" class=\"e-3a5f497f-7640 e-youtube-base e-default-div\" data-e-type=\"widget\" data-id=\"65fd01e0\" data-settings=\"&#x7B;&quot;source&quot;&#x3A;&quot;https&#x3A;&#x5C;&#x2F;&#x5C;&#x2F;www.youtube.com&#x5C;&#x2F;watch&#x3F;v&#x3D;lqQotWfpW-E&quot;,&quot;autoplay&quot;&#x3A;false,&quot;mute&quot;&#x3A;false,&quot;controls&quot;&#x3A;true,&quot;cc_load_policy&quot;&#x3A;false,&quot;loop&quot;&#x3A;false,&quot;rel&quot;&#x3A;true,&quot;start&quot;&#x3A;null,&quot;end&quot;&#x3A;null,&quot;privacy&quot;&#x3A;true,&quot;lazyload&quot;&#x3A;true&#x7D;\"><\/div>\n\t\t\t\t\t<p class=\"e-1e49a2fa-1e08 e-paragraph-base e-default-p\" data-interaction-id=\"4b1a7c36\" data-e-type=\"widget\" data-id=\"4b1a7c36\">Empieza con ejemplos de facturas, clientes y saldos pendientes. Aprende a reconocer qu\u00e9 celdas necesita cada f\u00f3rmula para devolver sus resultados.<\/p>\n\t\t\t\t\t<a href=\"https:\/\/www.youtube.com\/watch?v=lqQotWfpW-E\" target=\"_self\" class=\"e-5c2dc1b9-7336 e-button-base e-default-a\" data-interaction-id=\"4ca9ac63\" data-e-type=\"widget\" data-id=\"4ca9ac63\" rel=\"noopener\">\n\tVer en YouTube\n<\/a>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-6cfa3b79 e-con e-atomic-element e-flexbox-base e-default-article e-1c969303-8d31 \" data-id=\"6cfa3b79\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"6cfa3b79\" data-e-type=\"e-flexbox\" data-id=\"6cfa3b79\">\n    \t\t\t<p class=\"e-5bcd5875-a744 e-paragraph-base e-default-p\" data-interaction-id=\"4d57f192\" data-e-type=\"widget\" data-id=\"4d57f192\">PARTE 2 DE 3<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"70579121\" class=\"e-79b99075-8c4a e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"70579121\">Causas del error de desbordamiento<\/h3>\n\t\t\t\t\t<div data-id=\"69cc1c12\" data-interaction-id=\"69cc1c12\" data-e-type=\"e-youtube\" class=\"e-48fa3605-5a85 e-youtube-base e-default-div\" data-e-type=\"widget\" data-id=\"69cc1c12\" data-settings=\"&#x7B;&quot;source&quot;&#x3A;&quot;https&#x3A;&#x5C;&#x2F;&#x5C;&#x2F;www.youtube.com&#x5C;&#x2F;watch&#x3F;v&#x3D;Kl3UbaKW3Aw&quot;,&quot;autoplay&quot;&#x3A;false,&quot;mute&quot;&#x3A;false,&quot;controls&quot;&#x3A;true,&quot;cc_load_policy&quot;&#x3A;false,&quot;loop&quot;&#x3A;false,&quot;rel&quot;&#x3A;true,&quot;start&quot;&#x3A;null,&quot;end&quot;&#x3A;null,&quot;privacy&quot;&#x3A;true,&quot;lazyload&quot;&#x3A;true&#x7D;\"><\/div>\n\t\t\t\t\t<p class=\"e-533380c3-92bf e-paragraph-base e-default-p\" data-interaction-id=\"2ab5f9e9\" data-e-type=\"widget\" data-id=\"2ab5f9e9\">Identifica qu\u00e9 bloquea los resultados en seis ejercicios, desde una anotaci\u00f3n o una f\u00f3rmula que parece vac\u00eda hasta una tabla o el final de la hoja.<\/p>\n\t\t\t\t\t<a href=\"https:\/\/www.youtube.com\/watch?v=Kl3UbaKW3Aw\" target=\"_self\" class=\"e-3020b779-db4e e-button-base e-default-a\" data-interaction-id=\"175c1f20\" data-e-type=\"widget\" data-id=\"175c1f20\" rel=\"noopener\">\n\tVer en YouTube\n<\/a>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-7eb69b2b e-con e-atomic-element e-flexbox-base e-default-article e-109628fe-5d56 \" data-id=\"7eb69b2b\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"7eb69b2b\" data-e-type=\"e-flexbox\" data-id=\"7eb69b2b\">\n    \t\t\t<p class=\"e-61b34a24-181a e-paragraph-base e-default-p\" data-interaction-id=\"2d8a5f44\" data-e-type=\"widget\" data-id=\"2d8a5f44\">PARTE 3 DE 3<\/p>\n\t\t\t\t\t<h3 data-interaction-id=\"3489178b\" class=\"e-71342391-fa04 e-heading-base e-default-h3\" data-e-type=\"widget\" data-id=\"3489178b\">Soluciones paso a paso<\/h3>\n\t\t\t\t\t<div data-id=\"38d3cd20\" data-interaction-id=\"38d3cd20\" data-e-type=\"e-youtube\" class=\"e-377bf10f-e5e2 e-youtube-base e-default-div\" data-e-type=\"widget\" data-id=\"38d3cd20\" data-settings=\"&#x7B;&quot;source&quot;&#x3A;&quot;https&#x3A;&#x5C;&#x2F;&#x5C;&#x2F;www.youtube.com&#x5C;&#x2F;watch&#x3F;v&#x3D;GcEcM2vhvLk&quot;,&quot;autoplay&quot;&#x3A;false,&quot;mute&quot;&#x3A;false,&quot;controls&quot;&#x3A;true,&quot;cc_load_policy&quot;&#x3A;false,&quot;loop&quot;&#x3A;false,&quot;rel&quot;&#x3A;true,&quot;start&quot;&#x3A;null,&quot;end&quot;&#x3A;null,&quot;privacy&quot;&#x3A;true,&quot;lazyload&quot;&#x3A;true&#x7D;\"><\/div>\n\t\t\t\t\t<p class=\"e-6569e30f-2abb e-paragraph-base e-default-p\" data-interaction-id=\"5ae14d71\" data-e-type=\"widget\" data-id=\"5ae14d71\">Corrige el desbordamiento en Excel en los ejercicios de la parte anterior y comprueba que la matriz vuelve a ocupar las celdas esperadas.<\/p>\n\t\t\t\t\t<a href=\"https:\/\/www.youtube.com\/watch?v=GcEcM2vhvLk\" target=\"_self\" class=\"e-28dcf3d2-e2a2 e-button-base e-default-a\" data-interaction-id=\"5a0c394b\" data-e-type=\"widget\" data-id=\"5a0c394b\" rel=\"noopener\">\n\tVer en YouTube\n<\/a>\n\t\t\n<\/article>\n\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-8308c7b e-con e-atomic-element e-div-block-base e-default-section e-1cb8b04b-de83 \" data-id=\"8308c7b\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"8308c7b\" data-e-type=\"e-div-block\" data-id=\"8308c7b\">\n    <div class=\"elementor-element elementor-element-483efb15 e-con e-atomic-element e-flexbox-base e-default-div e-7a3650f9-9748 \" data-id=\"483efb15\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"483efb15\" data-e-type=\"e-flexbox\" data-id=\"483efb15\">\n    \t\t\t<p class=\"e-7d68639d-4108 e-paragraph-base e-default-p\" data-interaction-id=\"9430fd1\" data-e-type=\"widget\" data-id=\"9430fd1\">DUDAS HABITUALES<\/p>\n\t\t\t\t\t<h2 data-interaction-id=\"64edb160\" class=\"e-2d56fbd3-db01 e-heading-base e-default-h2\" id=\"t-1736125624223\" data-e-type=\"widget\" data-id=\"64edb160\">Preguntas frecuentes sobre el desbordamiento en Excel<\/h2>\n\t\t<div class=\"elementor-element elementor-element-1d104b6d e-con e-atomic-element e-grid-base e-default-div e-14cdce75-5c53 \" data-id=\"1d104b6d\" data-element_type=\"e-grid\" data-e-type=\"e-grid\" data-interaction-id=\"1d104b6d\" data-e-type=\"e-grid\" data-id=\"1d104b6d\">\n    <article class=\"elementor-element elementor-element-2543b7dd e-con e-atomic-element e-flexbox-base e-default-article e-5834b028-eff3 \" data-id=\"2543b7dd\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"2543b7dd\" data-e-type=\"e-flexbox\" data-id=\"2543b7dd\">\n    \t\t\t<h3 data-interaction-id=\"724729d2\" class=\"e-f822190-c074 e-heading-base e-default-h3\" id=\"t-1736125624224\" data-e-type=\"widget\" data-id=\"724729d2\">\u00bfC\u00f3mo solucionar el error de desbordamiento en Excel?<\/h3>\n\t\t\t\t\t<p class=\"e-30ebde7e-8244 e-paragraph-base e-default-p\" data-interaction-id=\"45be2350\" data-e-type=\"widget\" data-id=\"45be2350\">Selecciona la celda con el error, revisa el \u00e1rea prevista y localiza las obstrucciones. Mueve la f\u00f3rmula fuera de la tabla si se encuentra dentro de ella. <a href=\"#solucionar-error-desbordamiento\">Ver el diagn\u00f3stico por causa<\/a>.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-3effe112 e-con e-atomic-element e-flexbox-base e-default-article e-67737a4d-49cc \" data-id=\"3effe112\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"3effe112\" data-e-type=\"e-flexbox\" data-id=\"3effe112\">\n    \t\t\t<h3 data-interaction-id=\"f0f3287\" class=\"e-44283bed-3805 e-heading-base e-default-h3\" id=\"t-1736125624225\" data-e-type=\"widget\" data-id=\"f0f3287\">\u00bfC\u00f3mo detener el desbordamiento de celdas en Excel?<\/h3>\n\t\t\t\t\t<p class=\"e-208df3e5-1e3e e-paragraph-base e-default-p\" data-interaction-id=\"4730603e\" data-e-type=\"widget\" data-id=\"4730603e\">Si solo necesitas un resultado de la matriz, elige qu\u00e9 fila o columna devolver. Por ejemplo, INDICE(F2#;1;1) obtiene el primer valor del rango desbordado. Si quieres conservar una lista fija, copia el resultado y p\u00e9galo como valores.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-7e25dd71 e-con e-atomic-element e-flexbox-base e-default-article e-1a7cd32d-de21 \" data-id=\"7e25dd71\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"7e25dd71\" data-e-type=\"e-flexbox\" data-id=\"7e25dd71\">\n    \t\t\t<h3 data-interaction-id=\"4e05e586\" class=\"e-b4b2930-be6e e-heading-base e-default-h3\" id=\"t-1736125624226\" data-e-type=\"widget\" data-id=\"4e05e586\">\u00bfC\u00f3mo hacer para que no se desborde el texto en Excel?<\/h3>\n\t\t\t\t\t<p class=\"e-54522d2b-f8e0 e-paragraph-base e-default-p\" data-interaction-id=\"467b2fa2\" data-e-type=\"widget\" data-id=\"467b2fa2\">Para mostrar el texto dentro de la propia celda, selecciona Inicio \u2192 Alineaci\u00f3n \u2192 Ajustar texto o ampl\u00eda el ancho de la columna. Esta opci\u00f3n cambia la presentaci\u00f3n del texto. <a href=\"https:\/\/support.microsoft.com\/es-es\/excel\/wrap-text-in-a-cell-in-excel\" target=\"_blank\" rel=\"noopener\">Ver los pasos para ajustar texto en Excel<\/a>.<\/p>\n\t\t\n<\/article>\n<article class=\"elementor-element elementor-element-17c349a0 e-con e-atomic-element e-flexbox-base e-default-article e-71ad7bac-9894 \" data-id=\"17c349a0\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"17c349a0\" data-e-type=\"e-flexbox\" data-id=\"17c349a0\">\n    \t\t\t<h3 data-interaction-id=\"16141acf\" class=\"e-5f80990c-a6f0 e-heading-base e-default-h3\" id=\"t-1736125624227\" data-e-type=\"widget\" data-id=\"16141acf\">\u00bfCu\u00e1ndo se produce el desbordamiento?<\/h3>\n\t\t\t\t\t<p class=\"e-15020502-9f2f e-paragraph-base e-default-p\" data-interaction-id=\"7d39a2cf\" data-e-type=\"widget\" data-id=\"7d39a2cf\">El desbordamiento en Excel se produce cuando una f\u00f3rmula devuelve varios valores y tiene espacio para mostrarlos. FILTRAR, ORDENAR, ORDENARPOR, UNICOS, SECUENCIA y MATRIZALEAT son ejemplos. El error aparece cuando Excel no puede colocar el resultado en el \u00e1rea requerida.<\/p>\n\t\t\n<\/article>\n\n<\/div>\n\n<\/div>\n\n<\/section>\n<section class=\"elementor-element elementor-element-1869ff99 e-con e-atomic-element e-div-block-base e-default-section e-5ec2108d-f388 \" data-id=\"1869ff99\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"1869ff99\" data-e-type=\"e-div-block\" data-id=\"1869ff99\">\n    <div class=\"elementor-element elementor-element-5f691545 e-con e-atomic-element e-flexbox-base e-default-div e-34cc2e35-14d1 \" data-id=\"5f691545\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"5f691545\" data-e-type=\"e-flexbox\" data-id=\"5f691545\">\n    <div class=\"elementor-element elementor-element-442494e6 e-con e-atomic-element e-flexbox-base e-default-div e-4e41dac0-6fdb \" data-id=\"442494e6\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"442494e6\" data-e-type=\"e-flexbox\" data-id=\"442494e6\">\n    \t\t\t<p class=\"e-6f4b9471-44d1 e-paragraph-base e-default-p\" data-interaction-id=\"73e08f6b\" data-e-type=\"widget\" data-id=\"73e08f6b\">PARA SEGUIR PRACTICANDO<\/p>\n\t\t\t\t\t<h2 data-interaction-id=\"659d9993\" class=\"e-14135734-ef47 e-heading-base e-default-h2\" id=\"lista-desbordamiento-excel\" data-e-type=\"widget\" data-id=\"659d9993\">Contin\u00faa con la lista de reproducci\u00f3n de YouTube<\/h2>\n\t\t\t\t\t<p class=\"e-1f75eb96-7e9d e-paragraph-base e-default-p\" data-interaction-id=\"4d65c649\" data-e-type=\"widget\" data-id=\"4d65c649\">La lista \u00abDesbordamiento en Excel: funciones, causas y soluciones\u00bb re\u00fane los tres videos de ExcelyContabilidad. Para seguir los ejercicios en el orden de la gu\u00eda, empieza por la parte 1 y contin\u00faa con la 2 y la 3.<\/p>\n\t\t<div class=\"elementor-element elementor-element-70e43b69 e-con e-atomic-element e-flexbox-base e-default-div e-78c46da4-fa55 \" data-id=\"70e43b69\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"70e43b69\" data-e-type=\"e-flexbox\" data-id=\"70e43b69\">\n    \t\t\t<a href=\"https:\/\/www.youtube.com\/playlist?list=PLYHkn7Cx2PNs\" target=\"_self\" class=\"e-7cbea768-d2c6 e-button-base e-default-a\" data-interaction-id=\"246b121\" data-e-type=\"widget\" data-id=\"246b121\" rel=\"noopener\">\n\tVer la lista completa en YouTube\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/aplicaexcelcontable.com\/blog\/mini-curso\" target=\"_self\" class=\"e-1d15ae68-40a6 e-button-base e-default-a\" data-interaction-id=\"473e3308\" data-e-type=\"widget\" data-id=\"473e3308\">\n\tVer los cursos gratuitos\n<\/a>\n\t\t\n<\/div>\n\n<\/div>\n\t\t\t<p class=\"e-5cc31f03-f366 e-paragraph-base e-default-p\" data-interaction-id=\"486f31a9\" data-e-type=\"widget\" data-id=\"486f31a9\">Si necesitas ayuda, d\u00e9jame tu duda en los comentarios o escr\u00edbeme por <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\">el chat<\/a>, <a href=\"https:\/\/aplicaexcelcontable.com\/go\/whatsapp-en-leads\">WhatsApp<\/a> o <a href=\"mailto:rogerperez@aplicaexcelcontable.com\">correo electr\u00f3nico<\/a>. \u2014 Roger P\u00e9rez, Aplica Excel Contable.<\/p>\n\t\t<div class=\"elementor-element elementor-element-671c6b1c e-con e-atomic-element e-flexbox-base e-default-div e-4547d75d-c788 \" data-id=\"671c6b1c\" data-element_type=\"e-flexbox\" data-e-type=\"e-flexbox\" data-interaction-id=\"671c6b1c\" data-e-type=\"e-flexbox\" data-id=\"671c6b1c\">\n    \t\t\t<a href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fdesbordamiento-en-excel.html\" target=\"_self\" class=\"e-609df417-5618 e-button-base e-default-a\" data-interaction-id=\"1f92db3b\" data-e-type=\"widget\" data-id=\"1f92db3b\">\n\tCompartir en Facebook\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fdesbordamiento-en-excel.html\" target=\"_self\" class=\"e-6c6161b5-5850 e-button-base e-default-a\" data-interaction-id=\"1a8b1351\" data-e-type=\"widget\" data-id=\"1a8b1351\">\n\tCompartir en X\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/pinterest.com\/pin\/create\/button\/?url=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fdesbordamiento-en-excel.html&amp;media=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fwp-content%2Fuploads%2F2025%2F01%2FDesbordamiento-Excel.png\" target=\"_self\" class=\"e-6e6b57a6-7549 e-button-base e-default-a\" data-interaction-id=\"1fe7992\" data-e-type=\"widget\" data-id=\"1fe7992\">\n\tCompartir en Pinterest\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/wa.me\/?text=https%3A%2F%2Faplicaexcelcontable.com%2Fblog%2Fdesbordamiento-en-excel.html\" target=\"_self\" class=\"e-5a0df24f-f6a2 e-button-base e-default-a\" data-interaction-id=\"2f3f509f\" data-e-type=\"widget\" data-id=\"2f3f509f\">\n\tCompartir por WhatsApp\n<\/a>\n\t\t\t\t\t<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_self\" class=\"e-7d730ddc-6075 e-button-base e-default-a\" data-interaction-id=\"2c166a60\" data-e-type=\"widget\" data-id=\"2c166a60\" rel=\"noopener\">\n\tSeguir a AEC en Facebook\n<\/a>\n\t\t\n<\/div>\n\t\t\t<h2 data-interaction-id=\"2e894edd\" class=\"e-6586d47d-5eee e-heading-base e-default-h2\" id=\"comentario\" data-e-type=\"widget\" data-id=\"2e894edd\">Comentarios y dudas<\/h2>\n\t\t\t\t\t<p class=\"e-5e34c344-4514 e-paragraph-base e-default-p\" data-interaction-id=\"26fdff6d\" data-e-type=\"widget\" data-id=\"26fdff6d\">Si te aparece un error de desbordamiento en Excel, cu\u00e9ntame qu\u00e9 funci\u00f3n usas, d\u00f3nde empieza la f\u00f3rmula y qu\u00e9 hay en el \u00e1rea de salida.<\/p>\n\t\t<div class=\"elementor-element elementor-element-6ed99df9 e-con e-atomic-element e-div-block-base e-default-div e-6f1e9d44-ee36 \" data-id=\"6ed99df9\" data-element_type=\"e-div-block\" data-e-type=\"e-div-block\" data-interaction-id=\"6ed99df9\" data-e-type=\"e-div-block\" data-id=\"6ed99df9\">\n    \n<\/div>\n\n<\/div>\n\n<\/section>\n\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>EXCEL 2021 Y MICROSOFT 365 \/ MATRICES DIN\u00c1MICAS Desbordamiento en Excel: 6 funciones con ejemplos Una f\u00f3rmula puede devolver una lista completa de clientes o un reporte de facturas pendientes. Aprende a usar seis funciones de matrices din\u00e1micas, comprueba sus resultados y encuentra la causa cuando Excel muestra un error. Ver las 6 funciones Ver [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":60898,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"page_builder":"","footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 style=\"text-align: center;\" data-css=\"tve-u-677b210c0ddae8\" class=\"\">\u00bfQue es el Desbordamiento Excel ?<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-677b210c0ddb63\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-677b210c0ddb95\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Estas listo para aprender a crear <em><strong>desbordamiento Excel<\/strong><\/em> con las <strong>6 Funciones<\/strong> geniales que Microsoft puso a nuestra disposici\u00f3n?<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-677b210c0ddbc4\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-60898\" alt=\"Desbordamiento Excel\" data-id=\"60898\" width=\"521\" data-init-width=\"628\" height=\"285\" data-init-height=\"344\" title=\"Desbordamiento Excel\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2025\/01\/Desbordamiento-Excel.png\" data-width=\"521\" data-height=\"285\" style=\"aspect-ratio: auto 628 \/ 344;\"><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Al llegar Excel 2021 y las actualizaciones en office 365, ahora tenemos nuevas funciones para crear desbordamientos Excel con tus formulas.<\/p><\/div><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Hola soy <strong>Roger P\u00e9rez<\/strong>, y en este video, quiero compartir contigo la nueva lista de funciones para crear <em><strong>desbordamiento Excel<\/strong><\/em> y ahorrar tiempo en tus labores diarios.<\/p><p style=\"\">Estas listo ?<\/p><p style=\"\">Comencemos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve-toc tve-elem-scroll tcb-local-vars-root tve-toc-expandable\" data-columns=\"1\" data-ct=\"toc-63146\" data-transition=\"slide\" data-headers=\"h2,h3\" data-numbering=\"bullet_advanced\" data-highlight=\"progressive\" data-ct-name=\"Tabel of Contents 19\" data-heading-style=\"{&quot;0&quot;:&quot;tve-u-19439370b6b&quot;,&quot;1&quot;:&quot;tve-u-19439370b6d&quot;,&quot;2&quot;:&quot;tve-u-19439370b6f&quot;}\" data-css=\"tve-u-19439370b64\" style=\"\" data-element-name=\"Table of Contents\" data-bullet-style=\"{&quot;0&quot;:&quot;tve-u-19439370b6c&quot;,&quot;1&quot;:&quot;tve-u-19439370b6e&quot;,&quot;2&quot;:&quot;tve-u-19439370b70&quot;}\" data-number-style=\"{&quot;0&quot;:&quot;tve-u-173dc82388f&quot;,&quot;1&quot;:&quot;tve-u-173dc824915&quot;,&quot;2&quot;:&quot;tve-u-173dc8252a4&quot;}\" data-state-default=\"expanded\" data-columns-d=\"1\" data-animation=\"fade\" data-animation-speed=\"fast\" data-distribute=\"false\" data-state-default-m=\"collapsed\" data-form-settings=\"__TCB_FORM__{&quot;form_identifier&quot;:&quot;desbordamiento-excel-form-t68loj&quot;}__TCB_FORM__\" data-id=\"m5kfwmab\"><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"cd122\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"cd122\":{\"val\":\"rgb(128, 244, 60)\"}},\"gradients\":[]},\"original\":{\"colors\":{\"cd122\":{\"val\":\"rgb(127, 215, 132)\",\"hsl\":{\"h\":123,\"s\":0.52,\"l\":0.67,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/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-1-m5kfwmab\" 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-m5kfwmab\" 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 xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\" version=\"1.1\" id=\"toc-bullet-0-m5kfwmab\" viewBox=\"0 0 24 24\" data-id=\"icon-record-circle-outlined\"><path d=\"M12,2A10,10 0 0,0 2,12A10,10 0 0,0 12,22A10,10 0 0,0 22,12A10,10 0 0,0 12,2M12,4A8,8 0 0,1 20,12A8,8 0 0,1 12,20A8,8 0 0,1 4,12A8,8 0 0,1 12,4M12,9A3,3 0 0,0 9,12A3,3 0 0,0 12,15A3,3 0 0,0 15,12A3,3 0 0,0 12,9Z\"><\/path><\/symbol><\/svg><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.12)\" data-css=\"tve-u-19439370b65\" data-thickness-d=\"4\" data-style-d=\"tve_sep-2\"><hr class=\"tve_sep tve_sep-2\" style=\"\"><\/div><\/div><div class=\"thrive-colors-palette-config\" style=\"display: none !important\">__CONFIG_colors_palette__{\"active_palette\":0,\"config\":{\"colors\":{\"cd122\":{\"name\":\"Main Accent\",\"parent\":-1}},\"gradients\":[]},\"palettes\":[{\"name\":\"Default\",\"value\":{\"colors\":{\"cd122\":{\"val\":\"rgb(128, 244, 60)\"}},\"gradients\":[]},\"original\":{\"colors\":{\"cd122\":{\"val\":\"rgb(127, 215, 132)\",\"hsl\":{\"h\":123,\"s\":0.52,\"l\":0.67,\"a\":1}}},\"gradients\":[]}}]}__CONFIG_colors_palette__<\/div>\n\t<div class=\"tve-content-box-background\" data-css=\"tve-u-19439370b66\" style=\"\"><\/div>\n\t<div class=\"thrv_wrapper tve-toc-title tve-no-dropzone show-icon tve-prevent-content-edit\" data-css=\"tve-u-19439370b67\" style=\"\">\n\t<div class=\"tve-content-box-background\" style=\"\" data-css=\"tve-u-19439370b68\" data-ct-name=\"Dotted Wave\" data-ct=\"fancydivider-38697\" data-element-name=\"Fancy Divider\"><\/div>\n\t<div class=\"tve-cb\">\n\t\t<div class=\"tve-toc-title-icon\" data-icon-code=\"icon-ellipsis-h-regular\">\n\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-ellipsis-h-regular\" data-name=\"\">\n\t\t\t\t<path d=\"M304 256c0 26.5-21.5 48-48 48s-48-21.5-48-48 21.5-48 48-48 48 21.5 48 48zm120-48c-26.5 0-48 21.5-48 48s21.5 48 48 48 48-21.5 48-48-21.5-48-48-48zm-336 0c-26.5 0-48 21.5-48 48s21.5 48 48 48 48-21.5 48-48-21.5-48-48-48z\"><\/path>\n\t\t\t<\/svg>\n\t\t<\/div>\n\t\t<div class=\"thrv_wrapper thrv_text_element tve_no_icons\" style=\"\">\t\t\t<div class=\"tcb-plain-text\" style=\"\">Tabla de contenido<\/div><\/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-19439370b69\" style=\"z-index: 1 !important;\">\n\t\t\t<div class=\"tve-content-box-background\" data-css=\"tve-u-19439370b6a\" style=\"\" data-clip-id=\"291d438d4bbf9\"><svg width=\"0\" height=\"0\" class=\"tve-decoration-svg\"><defs><clipPath id=\"clip-top-291d438d4bbf9\" class=\"decoration-clip clip-path-top\" clipPathUnits=\"objectBoundingBox\" data-screen=\"\" decoration-type=\"pointer\" pointer-width=\"1\" pointer-height=\"1\"><polygon points=\"0.505 0.01, 0.5 0, 0.495 0.01, 0 0.01, 0 1, 1 1, 1 0.01\"><\/polygon><\/clipPath><\/defs><\/svg><\/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=\"H2\" data-css=\"tve-u-19439370b6b\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624213\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m5kfwmab\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-19439370b6c\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624213\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfQue significa Desbordamiento Excel ?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-19439370b6b\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624214\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m5kfwmab\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-19439370b6c\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624214\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Nuevas funciones que genera desbordamiento Excel<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-19439370b6b\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624215\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m5kfwmab\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-19439370b6c\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624215\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Puntos a tomar en cuenta al utilizar Desbordamiento Excel<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-19439370b6b\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624216\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m5kfwmab\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-19439370b6c\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624216\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sintaxis de las funciones que genera desbordamiento Excel<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624217\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624217\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sintaxis de las Funci\u00f3n FILTRAR<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624218\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624218\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sintaxis de las Funci\u00f3n ORDENAR<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624219\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624219\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sintaxis de las Funci\u00f3n ORDENARPOR<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624220\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624220\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sintaxis de las Funci\u00f3n UNICOS<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624221\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624221\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sintaxis de las Funci\u00f3n SECUENCIA<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624222\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624222\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Sintaxis de las Funci\u00f3n MATRIZALEAT<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level0 tve_no_icons\" data-tag=\"H2\" data-css=\"tve-u-19439370b6b\" data-element-name=\"Heading Level 1\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet0 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624223\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-0-m5kfwmab\" data-element-name=\"Icon Level 1\" data-css=\"tve-u-19439370b6c\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-0-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624223\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">Preguntas Frecuentes del desbordamiento Excel<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624224\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624224\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo solucionar el error de desbordamiento en Excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624225\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624225\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo detener el desbordamiento de celdas en Excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624226\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624226\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfC\u00f3mo hacer para que no se desborde el texto en Excel?<\/a><\/div><div class=\"thrv_wrapper tve-toc-heading tve-toc-heading-level1 tve_no_icons\" data-tag=\"H3\" data-css=\"tve-u-19439370b6d\" data-element-name=\"Heading Level 2\"><div class=\"thrv_wrapper tve-toc-bullet tve-toc-bullet1 tve_no_icons tve-jump-scroll\" data-target=\"#t-1736125624227\" jump-animation=\"smooth\" data-icon-target=\"toc-bullet-1-m5kfwmab\" data-element-name=\"Icon Level 2\" data-css=\"tve-u-19439370b6e\"><svg class=\"tcb-icon\"><use href=\"#toc-bullet-1-m5kfwmab\"><\/use><\/svg><\/div><a href=\"#t-1736125624227\" class=\"tve-toc-anchor tve-jump-scroll\" jump-animation=\"smooth\">\u00bfCu\u00e1ndo se produce el desbordamiento?<\/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.12)\" data-css=\"tve-u-19439370b65\" data-thickness-d=\"4\" data-style-d=\"tve_sep-2\"><hr class=\"tve_sep tve_sep-2\" 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 style=\"text-align: center;\" data-css=\"tve-u-677b210c0ddbe7\" class=\"\" id=\"t-1736125624213\">\u00bfQue significa Desbordamiento Excel ?<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-677b210c0ddc03\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-677b210c0ddc24\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Como primer paso, debemos de conocer que es un desbordamiento en Excel.<\/p><p style=\"\">Desbordamiento significa que una f\u00f3rmula ha dado como resultado varios valores y esos valores se han colocado en las celdas vecinas.<\/p><p style=\"\">Por ejemplo:<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-677b210c0ddc35\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-48250\" alt=\"Desbordamiento Excel\" data-id=\"48250\" width=\"430\" data-init-width=\"440\" height=\"338\" data-init-height=\"346\" title=\"Gif Formulas desbordadas\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Gif-Formulas-desbordadas.gif\" data-width=\"430\" data-height=\"338\" style=\"aspect-ratio: auto 440 \/ 346;\"><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Muy bien, ahora vamos a conocer cuales son las nuevas funciones que genera desbordamiento al aplicarlo en una celda.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" data-css=\"tve-u-677b210c0ddc56\" class=\"\" id=\"t-1736125624214\">Nuevas funciones que genera desbordamiento Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-677b210c0ddc77\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-677b210c0ddc99\"><div class=\"thrv_wrapper thrv_text_element\"><p>A continuaci\u00f3n, la lista de nuevas funciones que genera desbordamiento Excel al utilizarlo en tus formulas, valido para Excel 2021 y en office 365:<\/p><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-css=\"tve-u-194390d1fdd\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddcb9\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0ddcd7\">FILTRAR<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddcb9\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0ddcd7\">ORDENAR<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddcb9\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0ddcd7\">ORDENARPOR<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddcb9\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style \" data-css=\"tve-u-677b210c0ddcf2\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0ddcd7\">UNICOS<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddcb9\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style \" data-css=\"tve-u-677b210c0ddd14\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0ddcd7\">SECUENCIA<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddcb9\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style \" data-css=\"tve-u-677b210c0ddd33\"><svg class=\"tcb-icon\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\"><path d=\"M29.333 10.267c0 0.4-0.133 0.8-0.533 1.2l-14.8 14.8c-0.267 0.267-0.667 0.4-1.067 0.4s-0.933-0.133-1.2-0.533l-2.4-2.267-6.267-6.267c-0.267-0.267-0.4-0.667-0.4-1.2s0.133-0.8 0.533-1.2l2.4-2.4c0.267-0.133 0.667-0.4 1.067-0.4s0.8 0.133 1.2 0.533l5.067 5.067 11.2-11.333c0.267-0.267 0.667-0.533 1.2-0.533 0.4 0 0.8 0.133 1.2 0.533l2.4 2.4c0.267 0.267 0.4 0.667 0.4 1.2z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0ddcd7\">MATRIZALEAT<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_text_element\"><p>Estas funciones, son indispensables para todos los usuarios que utilizan Excel en su contabilidad, para el control de inventarios y an\u00e1lisis de ventas.<\/p><p>A continuaci\u00f3n, algunas puntos a tomar en cuenta al utilizar las formulas desbordadas:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-194390e128b\" id=\"t-1736125624215\">Puntos a tomar en cuenta al utilizar Desbordamiento Excel<\/h2><\/div><div class=\"thrv_wrapper thrv-styled_list tcb-icon-display\" data-icon-code=\"icon-arrow-circle-right-solid\" style=\"\" data-css=\"tve-u-677b210c0ddd71\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddd90\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root\" data-css=\"tve-u-677b210c0dddb6\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-circle-right-solid\" data-name=\"\"><path d=\"M256 8c137 0 248 111 248 248S393 504 256 504 8 393 8 256 119 8 256 8zm-28.9 143.6l75.5 72.4H120c-13.3 0-24 10.7-24 24v16c0 13.3 10.7 24 24 24h182.6l-75.5 72.4c-9.7 9.3-9.9 24.8-.4 34.3l11 10.9c9.4 9.4 24.6 9.4 33.9 0L404.3 273c9.4-9.4 9.4-24.6 0-33.9L271.6 106.3c-9.4-9.4-24.6-9.4-33.9 0l-11 10.9c-9.5 9.6-9.3 25.1.4 34.4z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0dddd1\"><div style=\"text-align: justify;\">Al escribir una formula que contiene una funci\u00f3n que genera desbordamiento Excel, al presionar la tecla enter (entrar), Excel ajustar\u00e1 din\u00e1micamente el tama\u00f1o del rango de salida y colocar\u00e1 los resultados en cada celda de ese rango.<\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddd90\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\" data-css=\"tve-u-677b210c0dddb6\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-circle-right-solid\" data-name=\"\"><path d=\"M256 8c137 0 248 111 248 248S393 504 256 504 8 393 8 256 119 8 256 8zm-28.9 143.6l75.5 72.4H120c-13.3 0-24 10.7-24 24v16c0 13.3 10.7 24 24 24h182.6l-75.5 72.4c-9.7 9.3-9.9 24.8-.4 34.3l11 10.9c9.4 9.4 24.6 9.4 33.9 0L404.3 273c9.4-9.4 9.4-24.6 0-33.9L271.6 106.3c-9.4-9.4-24.6-9.4-33.9 0l-11 10.9c-9.5 9.6-9.3 25.1.4 34.4z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0dddd1\"><div style=\"text-align: justify;\">Las f\u00f3rmulas que contiene una funci\u00f3n que genera desbordamiento Excel no son compatibles con las tablas de Excel, por lo que debe de escribir fuera de una tabla Excel. Las tablas son m\u00e1s adecuadas para mantener filas y columnas de datos independientes.<\/div><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-677b210c0ddd90\" style=\"\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\" data-css=\"tve-u-677b210c0dddb6\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-circle-right-solid\" data-name=\"\"><path d=\"M256 8c137 0 248 111 248 248S393 504 256 504 8 393 8 256 119 8 256 8zm-28.9 143.6l75.5 72.4H120c-13.3 0-24 10.7-24 24v16c0 13.3 10.7 24 24 24h182.6l-75.5 72.4c-9.7 9.3-9.9 24.8-.4 34.3l11 10.9c9.4 9.4 24.6 9.4 33.9 0L404.3 273c9.4-9.4 9.4-24.6 0-33.9L271.6 106.3c-9.4-9.4-24.6-9.4-33.9 0l-11 10.9c-9.5 9.6-9.3 25.1.4 34.4z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0dddd1\">Al seleccionar cualquier celda dentro del \u00e1rea de desbordamiento, Excel colocar\u00e1 un borde resaltado alrededor del rango. El borde desaparecer\u00e1 cuando selecciones una celda fuera del \u00e1rea de desbordamiento.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-677b210c0dddf2\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-48253\" alt=\"Desbordamiento Excel\" data-id=\"48253\" width=\"606\" data-init-width=\"616\" height=\"204\" data-init-height=\"207\" title=\"Area de desbordamiento\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Area-de-desbordamiento.png\" data-width=\"606\" data-height=\"204\" style=\"aspect-ratio: auto 616 \/ 207;\"><\/span><\/div><div class=\"thrv_wrapper thrv-styled_list tcb-icon-display\" data-icon-code=\"icon-arrow-circle-right-solid\" style=\"\" data-css=\"tve-u-677b210c0dde11\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" style=\"\" data-css=\"tve-u-194392d7135\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style tcb-local-vars-root\" data-css=\"tve-u-677b210c0dde33\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-circle-right-solid\" data-name=\"\"><path d=\"M256 8c137 0 248 111 248 248S393 504 256 504 8 393 8 256 119 8 256 8zm-28.9 143.6l75.5 72.4H120c-13.3 0-24 10.7-24 24v16c0 13.3 10.7 24 24 24h182.6l-75.5 72.4c-9.7 9.3-9.9 24.8-.4 34.3l11 10.9c9.4 9.4 24.6 9.4 33.9 0L404.3 273c9.4-9.4 9.4-24.6 0-33.9L271.6 106.3c-9.4-9.4-24.6-9.4-33.9 0l-11 10.9c-9.5 9.6-9.3 25.1.4 34.4z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0dde52\"><div style=\"text-align: justify;\">Solo podras editar la primera celda del \u00e1rea de desbordamiento. Si selecciona otra celda en el \u00e1rea de desbordamiento, la f\u00f3rmula ser\u00e1 visible en la barra de f\u00f3rmulas, pero el texto es \"fantasma\" y no se puede cambiar.&nbsp;<\/div><\/span><\/li><li class=\"thrv-styled-list-item\" style=\"\" data-css=\"tve-u-194392d7135\"><div class=\"tcb-styled-list-icon\"><div class=\"thrv_wrapper thrv_icon tve_no_drag tcb-no-delete tcb-no-clone tcb-no-save tcb-icon-inherit-style\" data-css=\"tve-u-677b210c0dde70\" style=\"\"><svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-arrow-circle-right-solid\" data-name=\"\"><path d=\"M256 8c137 0 248 111 248 248S393 504 256 504 8 393 8 256 119 8 256 8zm-28.9 143.6l75.5 72.4H120c-13.3 0-24 10.7-24 24v16c0 13.3 10.7 24 24 24h182.6l-75.5 72.4c-9.7 9.3-9.9 24.8-.4 34.3l11 10.9c9.4 9.4 24.6 9.4 33.9 0L404.3 273c9.4-9.4 9.4-24.6 0-33.9L271.6 106.3c-9.4-9.4-24.6-9.4-33.9 0l-11 10.9c-9.5 9.6-9.3 25.1.4 34.4z\"><\/path><\/svg><\/div><\/div><span class=\"thrv-advanced-inline-text tve_editable tcb-styled-list-icon-text tcb-no-delete tcb-no-save\" data-css=\"tve-u-677b210c0dde92\">Si necesitas actualizar la f\u00f3rmula, debes de seleccionar la celda superior izquierda del rango de la matriz, cambiarla seg\u00fan sea necesario y, a continuaci\u00f3n, Excel actualizar\u00e1 autom\u00e1ticamente el resto del \u00e1rea desbordada cuando presione la tecla enter.<\/span><\/li><\/ul><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194392dbdf7\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194392dbdf2\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Ahora que ya conoces la lista de funciones de desbordamiento Excel y los puntos a tomar en cuenta al utilizar desbordamiento, podemos dar un salto mas all\u00e1.<\/p><p style=\"\">\u00bfQue tal si conocemos la sintaxis de cada funci\u00f3n que genera desbordamiento Excel?<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 data-css=\"tve-u-1943931d1ff\" style=\"\" class=\"\" id=\"t-1736125624216\">Sintaxis de las funciones que genera desbordamiento Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" class=\"\" id=\"t-1736125624217\">Sintaxis de las Funci\u00f3n FILTRAR<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194393bc8cc\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194393bc8c7\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Antes de comenzar a utilizar la&nbsp;<strong>funci\u00f3n filtrar<\/strong> en nuestros proyectos, primero debemos de conocer la sintaxis:<\/p><blockquote class=\"\"><strong>=FILTRAR(array; include; [If_empty])<\/strong><\/blockquote><p>A continuaci\u00f3n los detalles de cada componente de la sintaxis:<\/p><p><em><strong>Array<\/strong><\/em>&nbsp;= es el rango o matriz que se va a filtrar.<\/p><p><em><strong>Include<\/strong><\/em>&nbsp;= Una matriz de valores booleanos donde true representa una fila o columna que va a conservar.<\/p><p><em><strong>If_empty&nbsp;<\/strong><\/em>= Se devuelve si no se conserva ning\u00fan elemento.<\/p><p>Si quieres ver el video explicativo de como utilizar la funci\u00f3n Filtrar en tus proyectos &gt;&gt; <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/la-funcion-filtrar.html\" target=\"_blank\" class=\"\" style=\"outline: none;\"><em><strong>Clic aqu\u00ed para ver el video<\/strong><\/em><\/a> &lt;&lt;.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" class=\"\" id=\"t-1736125624218\">Sintaxis de las Funci\u00f3n ORDENAR<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19439412592\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194393fb3c5\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para comenzar a utilizar la&nbsp;<strong>funci\u00f3n ORDENAR<\/strong> en nuestros proyectos, primero debemos de conocer la sintaxis:<\/p><blockquote class=\"\" style=\"\"><span style=\"font-style: normal;\"><strong>=ORDENAR(matriz;[ordenar_\u00edndice];[criterio_ordenaci\u00f3n];[por_col])<\/strong><\/span><br><\/blockquote><p style=\"\">A continuaci\u00f3n los detalles de cada componente de la sintaxis:<\/p><ul><li class=\"\" style=\"\">Matriz: Es el rango o matriz para ordenar.<\/li><li class=\"\" style=\"\">Ordenar_\u00edndice: Es un numero que indica la fila o columna para ordenar por.<\/li><li class=\"\" style=\"\">Criterio_ordenaci\u00f3n: Es un numero que indica el orden deseado, 1 para orden ascendente, -1 para orden descendente.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" id=\"t-1736125624219\" class=\"\">Sintaxis de las Funci\u00f3n ORDENARPOR<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19439416e86\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194393fb3c5\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para comenzar a utilizar la&nbsp;<strong>funci\u00f3n ORDENARPOR<\/strong> en nuestros proyectos, primero debemos de conocer la sintaxis:<\/p><blockquote class=\"\" style=\"\"><em><strong>=ORDENARPOR(matriz;por_matriz1;[orden1];...)<\/strong><\/em><\/blockquote><p style=\"\">A continuaci\u00f3n los detalles de cada componente de la sintaxis:<\/p><ul><li class=\"\" style=\"\">Matriz: Es el rango o la matriz que se va a ordenar.<\/li><li class=\"\" style=\"\">Por_matriz1: Es el rango o la matriz en los que se basa el orden.<\/li><li class=\"\" style=\"\">Orden1: Es el numero que indica el orden deseado, 1 para orden ascendente, -1 para orden descendente.<\/li><li class=\"\" style=\"\">...: El punto suspensivo indica que puedes agregar matriz2, orden2 y mucho mas.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" class=\"\" id=\"t-1736125624220\">Sintaxis de las Funci\u00f3n UNICOS<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194393fb3ca\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194393fb3c5\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para comenzar a utilizar la&nbsp;<strong>funci\u00f3n UNICOS<\/strong> en nuestros proyectos, primero debemos de conocer la sintaxis:<\/p><blockquote class=\"\" style=\"\"><em><strong>=UNICOS(matriz,[by_col];[exactly_once])<\/strong><\/em><br><\/blockquote><p style=\"\">A continuaci\u00f3n los detalles de cada componente de la sintaxis:<\/p><ul><li class=\"\" style=\"\">Matriz: Es el rango o matriz desde el que se van a devolver filas o columnas \u00fanicas.<\/li><li class=\"\" style=\"\">By_col: Es un valor l\u00f3gico, compara filas entre si y devuelve las filas \u00fanicas = FALSE u omitidas, compara columnas entre si y devuelve las columnas \u00fanicas =TRUE.<\/li><li class=\"\" style=\"\">Exactly_once: Es un valor l\u00f3gico, devuelve filas o columnas que se producen exactamente una vez desde la matriz = TRUE, devuelve todas las filas o columnas distintas de la matriz = FALSE u omitidas.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" class=\"\" id=\"t-1736125624221\">Sintaxis de las Funci\u00f3n SECUENCIA<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194393fb3ca\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194393fb3c5\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para comenzar a utilizar la&nbsp;<strong>funci\u00f3n SECUENCIA<\/strong> en nuestros proyectos, primero debemos de conocer la sintaxis:<\/p><blockquote class=\"\" style=\"\"><em><strong>=SECUENCIA(filas;[columnas];[inicio];[paso])<\/strong><\/em><\/blockquote><p style=\"\">A continuaci\u00f3n los detalles de cada componente de la sintaxis:<\/p><ul><li class=\"\" style=\"\">Fila: Es el numero de filas que se va a devolver.<\/li><li class=\"\" style=\"\">Columnas: Es el numero de columnas que se va a devolver.<\/li><li class=\"\" style=\"\">Inicio: Es el primer numero de la secuencia.<\/li><li class=\"\" style=\"\">Paso: Es la cantidad en que se incrementa cada valor subsiguiente de la secuencia.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" class=\"\" id=\"t-1736125624222\">Sintaxis de las Funci\u00f3n MATRIZALEAT<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-194393fb3ca\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-194393fb3c5\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para comenzar a utilizar la&nbsp;<strong>funci\u00f3n MATRIZALEAT<\/strong> en nuestros proyectos, primero debemos de conocer la sintaxis:<\/p><blockquote class=\"\" style=\"\"><em><strong>=MATRIZALEAT([filas];[columnas];[min];[max],[entero])<\/strong><\/em><\/blockquote><p style=\"\">A continuaci\u00f3n los detalles de cada componente de la sintaxis:<\/p><ul><li class=\"\" style=\"\">Filas: Es el numero de filas de la matriz devuelta.<\/li><li class=\"\" style=\"\">Columnas: Es el numero de columnas de la matriz devuelta.<\/li><li class=\"\" style=\"\">Min: Es el numero m\u00ednimo que desea que se devuelva.<\/li><li class=\"\" style=\"\">Max: Es el numero m\u00e1ximo que desea que se devuelva.<\/li><li class=\"\" style=\"\">Entero: Devuelve un entero o un valor decimal. VERDADERO para un entero, FALSO para un numero decimal.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 data-css=\"tve-u-1943931d1ff\" style=\"\" class=\"\" id=\"t-1736125624223\">Preguntas Frecuentes del desbordamiento Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" data-css=\"tve-u-19439350432\" id=\"t-1736125624224\" class=\"\">\u00bfC\u00f3mo solucionar el error de desbordamiento en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19439760d68\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19439760d63\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Para solucionar errores de desbordamiento, lo primero que debes de verificar es:<\/p><ul><li class=\"\" style=\"\">No utilizar funciones de desbordamiento en tus formulas Excel dentro de una tabla Excel.<\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" data-css=\"tve-u-19439351e54\" id=\"t-1736125624225\" class=\"\">\u00bfC\u00f3mo detener el desbordamiento de celdas en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19439760d68\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19439760d63\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">El desbordamiento de celdas se detiene cuando evitas utilizar funciones de desbordamiento en tus formulas.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-1943935326e\" style=\"\" id=\"t-1736125624226\" class=\"\">\u00bfC\u00f3mo hacer para que no se desborde el texto en Excel?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19439760d68\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19439760d63\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Para hacer que no se desborde el texto en Excel no debes de utilizar las funciones FILTRAR, ORDENAR, ORDENARPOR, UNICOS, SECUENCIA en tus formulas de Excel.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 data-css=\"tve-u-1943935326e\" style=\"\" id=\"t-1736125624227\" class=\"\">\u00bfCu\u00e1ndo se produce el desbordamiento?<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19439760d68\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19439760d63\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">El desbordamiento Excel se produce al utilizar la funci\u00f3n FILTRAR, ORDENAR, ORDENARPOR, UNICOS, SECUENCIA en tus formulas de Excel.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-677b210c0ddea0\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-677b210c0ddec2\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Hasta aqu\u00ed te he compartido las generalidades del desbordamiento Excel, en los siguientes art\u00edculos te compartir\u00e9 ejemplo de cada una de las funciones para aplicarlo a tu contabilidad.<\/p><p>Que tal te pareci\u00f3 el articulo de hoy \"Las 6 Funciones que generan desbordamiento Excel? Te gusto?<\/p><p>Si te gusto, te invito a compartirlo con tus amigos por correo electr\u00f3nico, WhatsApp o bien por&nbsp;<a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" rel=\"noopener\" target=\"_blank\" class=\"\" style=\"outline: none;\">Facebook<\/a>, a continuaci\u00f3n te dejo un bot\u00f3n para que puedas compartirlo:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-19439134a87\"><div class=\"thrv_wrapper thrv_social_custom thrv_social\" data-counts=\"\" data-min_shares=\"0\" data-device-config=\"{&quot;desktop&quot;:{&quot;isFullWidth&quot;:&quot;0&quot;},&quot;tablet&quot;:{},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-19439134a86\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_itb\">\n\t\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_fb_share tve_share_item\" data-s=\"fb_share\" data-href=\"{tcb_post_url}\" data-label=\"Compartir\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 264 512\" data-id=\"icon-fb\" data-name=\"\">\n            <path d=\"M76.7 512V283H0v-91h76.7v-71.7C76.7 42.4 124.3 0 193.8 0c33.3 0 61.9 2.5 70.2 3.6V85h-48.2c-37.8 0-45.1 18-45.1 44.3V192H256l-11.7 91h-73.6v229\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Compartir<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_t_share tve_share_item\" data-s=\"t_share\" data-href=\"{tcb_post_url}\" data-label=\"Tweet\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 512 512\" data-id=\"icon-t\" data-name=\"\">\n            <path d=\"M459.37 151.716c.325 4.548.325 9.097.325 13.645 0 138.72-105.583 298.558-298.558 298.558-59.452 0-114.68-17.219-161.137-47.106 8.447.974 16.568 1.299 25.34 1.299 49.055 0 94.213-16.568 130.274-44.832-46.132-.975-84.792-31.188-98.112-72.772 6.498.974 12.995 1.624 19.818 1.624 9.421 0 18.843-1.3 27.614-3.573-48.081-9.747-84.143-51.98-84.143-102.985v-1.299c13.969 7.797 30.214 12.67 47.431 13.319-28.264-18.843-46.781-51.005-46.781-87.391 0-19.492 5.197-37.36 14.294-52.954 51.655 63.675 129.3 105.258 216.365 109.807-1.624-7.797-2.599-15.918-2.599-24.04 0-57.828 46.782-104.934 104.934-104.934 30.213 0 57.502 12.67 76.67 33.137 23.715-4.548 46.456-13.32 66.599-25.34-7.798 24.366-24.366 44.833-46.132 57.827 21.117-2.273 41.584-8.122 60.426-16.243-14.292 20.791-32.161 39.308-52.628 54.253z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Tweet<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\t<div class=\"thrv_wrapper tve_s_item tve_s_pin_share tve_share_item\" data-s=\"pin_share\" data-href=\"{tcb_post_url}\" data-label=\"Pin\">\n\t\t\t<a href=\"javascript:void(0)\" class=\"tve_s_link\">\n\t\t\t\t<span class=\"thrv_wrapper tve_s_icon\">\n\t\t\t\t\t<svg class=\"tcb-icon\" viewBox=\"0 0 384 512\" data-id=\"icon-pin\" data-name=\"\">\n            <path d=\"M204 6.5C101.4 6.5 0 74.9 0 185.6 0 256 39.6 296 63.6 296c9.9 0 15.6-27.6 15.6-35.4 0-9.3-23.7-29.1-23.7-67.8 0-80.4 61.2-137.4 140.4-137.4 68.1 0 118.5 38.7 118.5 109.8 0 53.1-21.3 152.7-90.3 152.7-24.9 0-46.2-18-46.2-43.8 0-37.8 26.4-74.4 26.4-113.4 0-66.2-93.9-54.2-93.9 25.8 0 16.8 2.1 35.4 9.6 50.7-13.8 59.4-42 147.9-42 209.1 0 18.9 2.7 37.5 4.5 56.4 3.4 3.8 1.7 3.4 6.9 1.5 50.4-69 48.6-82.5 71.4-172.8 12.3 23.4 44.1 36 69.3 36 106.2 0 153.9-103.5 153.9-196.8C384 71.3 298.2 6.5 204 6.5z\"><\/path>\n        <\/svg>\n\t\t\t\t<\/span>\n\t\t\t\t<span class=\"tve_s_text\">Pin<\/span>\n\t\t\t\t<span class=\"tve_s_count\">0<\/span>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t\n\t\n<\/div>\n<\/div><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-19439364aa0\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-19439364a9f\"><div class=\"thrv_wrapper thrv_text_element tcb-highlight-added\">\t<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19439364aa1\">&nbsp;<\/span><a href=\"#comentario\" class=\"tve-jump-scroll\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\" data-css=\"tve-u-19439364aa2\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-css=\"tve-u-19439364aa3\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\" data-css=\"tve-u-19439364aa4\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-19439364aa5\"><\/span><\/p><p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p><p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) [data-css=\"tve-u-677b210c0ddae8\"] { font-size: 42px !important; color: rgb(0, 4, 4) !important; --tcb-applied-color: rgb(0,4,4) !important; --tve-applied-color: rgb(0,4,4) !important; text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-677b210c0ddb95\"] { --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-677b210c0ddb95\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddb95\"] 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-677b210c0ddb95\"] p { padding: 0px 0px 13px !important; margin: 0px !important; }[data-css=\"tve-u-677b210c0ddb63\"] { margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-677b210c0ddbe7\"] { font-size: 35px !important; color: rgb(0, 5, 6) !important; --tcb-applied-color: rgb(0,5,6) !important; --tve-applied-color: rgb(0,5,6) !important; text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-677b210c0ddc24\"] { --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-677b210c0ddc24\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc24\"] 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-677b210c0ddc24\"] p { padding: 0px 0px 10px !important; margin: 0px !important; }[data-css=\"tve-u-677b210c0ddc03\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-top: 0px !important; padding-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-677b210c0ddc56\"] { font-size: 38px !important; color: rgb(0, 6, 7) !important; --tcb-applied-color: rgb(0,6,7) !important; --tve-applied-color: rgb(0,6,7) !important; text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-677b210c0ddc99\"] { --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-677b210c0ddc99\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddc99\"] 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-677b210c0ddc99\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-677b210c0ddc77\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-677b210c0dddb6\"] { --tcb-local-color-icon: rgb(59,59,59); --tcb-local-color-var: rgb(59,59,59); --tve-icon-size: 18px; }:not(#tve) [data-css=\"tve-u-677b210c0ddd71\"] li { --tcb-applied-color: rgb(8,0,0); color: var(--tve-color,rgb(8,0,0)) !important; --tve-applied-color: var$(--tve-color,rgb(8,0,0)) !important; font-size: var(--tve-font-size,20px) !important; }[data-css=\"tve-u-677b210c0ddd71\"] { --tve-color: rgb(8,0,0); --tve-applied---tve-color: rgb(8,0,0); --tve-font-size: 20px; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-677b210c0dde11\"] li { --tcb-applied-color: rgb(8,0,0); color: var(--tve-color,rgb(8,0,0)) !important; --tve-applied-color: var$(--tve-color,rgb(8,0,0)) !important; font-size: var(--tve-font-size,20px) !important; }[data-css=\"tve-u-677b210c0dde11\"] { --tve-color: rgb(8,0,0); --tve-applied---tve-color: rgb(8,0,0); --tve-font-size: 20px; margin-bottom: 0px !important; margin-top: 10px !important; }[data-css=\"tve-u-677b210c0dde33\"] { --tcb-local-color-icon: rgb(59,59,59); --tcb-local-color-var: rgb(59,59,59); --tve-icon-size: 18px; }[data-css=\"tve-u-677b210c0dde70\"] { --tcb-local-color-icon: rgb(59,59,59); --tcb-local-color-var: rgb(59,59,59); --tve-icon-size: 18px; }:not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-677b210c0ddec2\"] { --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-677b210c0ddec2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-677b210c0ddec2\"] 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-677b210c0ddec2\"] p { padding: 0px 0px 13px !important; margin: 0px !important; }[data-css=\"tve-u-677b210c0ddea0\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-top: 0px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-677b210c0ddbc4\"] { width: 529px; --tve-alignment: center; float: none; border: 4px dashed rgba(9, 0, 0, 0.85); --tve-applied-border: 4px dashed rgba(9,0,0,0.85); --tve-border-width: 4px; --tve-border-radius: 30px; border-radius: 30px; overflow: hidden; margin: 20px auto !important; }[data-css=\"tve-u-677b210c0ddc35\"] { width: 440px; --tve-alignment: center; float: none; --tve-border-width: 5px; border: 5px dashed rgb(28, 225, 8); --tve-applied-border: 5px dashed rgb(28,225,8); --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; margin: 10px auto !important; }[data-css=\"tve-u-677b210c0dddf2\"] { width: 616px; --tve-alignment: center; float: none; border: 5px dashed rgb(62, 225, 18); --tve-applied-border: 5px dashed rgb(62,225,18); --tve-border-width: 5px; --tve-border-radius: 60px; border-radius: 60px; overflow: hidden; margin: 0px auto !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 50px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(33.3333% - 13.3333px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+4) { margin-top: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+4)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(3n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(3n) { margin-right: 0px !important; }[data-css=\"tve-u-194390d1fdd\"] { margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-194390e128b\"] { text-transform: none !important; }[data-css=\"tve-u-19439134a86\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-19439134a87\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194392dbdf2\"] { --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-194392dbdf2\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194392dbdf2\"] 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-194392dbdf2\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194392dbdf7\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-194392d7135\"] { padding-bottom: 18px !important; }:not(#tve) [data-css=\"tve-u-1943931d1ff\"] { text-transform: none !important; }:not(#tve) [data-css=\"tve-u-19439350432\"] { text-transform: none !important; }:not(#tve) [data-css=\"tve-u-19439351e54\"] { text-transform: none !important; }:not(#tve) [data-css=\"tve-u-1943935326e\"] { text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-19439364a9f\"] { --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-19439364a9f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439364a9f\"] 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-19439364a9f\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19439364aa0\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-19439364aa1\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19439364aa2\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-19439364aa3\"] { --tve-highlight-background: url(\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20314%20114%22%20preserveAspectRatio%3D'none'%3E%0A%09%09%09%09%09%3Cpath%20d%3D%22M149.412%202.398C98.053%204.579%2074.996%207.562%2053.903%2014.754%2028.892%2023.283%208.503%2040.617%202.929%2058.09c-4.148%2013.004-.464%2026.402%2010.207%2037.118%205.664%205.687%2015.228%2012.328%2021.753%2015.104%202.939%201.25%208.598%202.708%2010.559%202.72%201.16.008%201.111-.129-.909-2.543-2.554-3.05-4.753-7.567-4.761-9.775-.008-2.502%202.482-6.937%204.862-8.661%205.613-4.066%2020.333-6.115%2050.607-7.046%2012.81-.394%2019.622.068%2047.623%203.231%2057%206.439%2066.925%207.222%2091.845%207.248%2016.516.016%2020.951-.139%2026.167-.919%2020.12-3.007%2032.633-8.401%2041.489-17.883%206.859-7.344%2010.154-16.516%2010.254-28.537.032-3.902-.231-7.704-.651-9.42-5.257-21.464-31.961-33.668-80.137-36.622-11.85-.727-62.651-.546-82.425.293%22%2F%3E%0A%09%09%09%09%3C%2Fsvg%3E\"); --tcb-text-highlight-color: #2ABB61 !important; }[data-css=\"tve-u-19439364aa4\"] { --tcb-text-highlight-color: rgb(30,184,76) !important; }[data-css=\"tve-u-19439364aa5\"] { --tcb-text-highlight-color: transparent !important; }[data-css=\"tve-u-19439370b64\"] { --tve-toc-indent: 31px; float: none; --tcb-local-color-e7784: var(--tcb-local-color-cd122); --tcb-local-color-6a2a6: rgb(231,233,231); max-width: 1080px; padding: 8px !important; margin-left: auto !important; margin-right: auto !important; --tcb-local-color-cd122: rgb(128,244,60) !important; }[data-css=\"tve-u-19439370b66\"] { box-shadow: none; overflow: hidden; --tve-applied-box-shadow: none; border-radius: 6px !important; border-top: none !important; background-color: var(--tcb-local-color-cd122) !important; --tve-applied-background-color: var$(--tcb-local-color-cd122) !important; }[data-css=\"tve-u-19439370b69\"] { overflow: auto; padding: 20px !important; margin: 0px !important; z-index: 1 !important; }[data-css=\"tve-u-19439370b67\"] { text-align: center; --tve-text-transform: uppercase; --tve-font-size: 16px; --tve-letter-spacing: 4px; overflow: auto; --tve-color: rgb(255,255,255); --tve-applied---tve-color: rgb(255,255,255); --tve-line-height: 1.1em; padding: 18px !important; margin: 0px !important; z-index: 1 !important; }[data-css=\"tve-u-19439370b67\"] > .tve-content-box-background { border: none !important; --tve-applied-border: none !important; }:not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] > .tve-content-box-background { background-color: var(--tcb-local-color-cd122) !important; --tve-applied-background-color: var$(--tcb-local-color-cd122) !important; }:not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] p, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] li, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] blockquote, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] address, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] .tcb-plain-text, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] label, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] h1, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] h2, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] h3, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] h4, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] h5, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] h6 { color: var(--tve-color,rgb(255,255,255)); --tve-applied-color: var$(--tve-color,rgb(255,255,255)); --tcb-applied-color: rgb(255,255,255); }:not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] p, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] li, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] blockquote, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] address, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] .tcb-plain-text, :not(#tve) .tve-toc-title[data-css=\"tve-u-19439370b67\"] label { font-size: var(--tve-font-size,16px); line-height: var(--tve-line-height,1.1em); }[data-css=\"tve-u-19439370b67\"] p, [data-css=\"tve-u-19439370b67\"] li, [data-css=\"tve-u-19439370b67\"] blockquote, [data-css=\"tve-u-19439370b67\"] address, [data-css=\"tve-u-19439370b67\"] .tcb-plain-text, [data-css=\"tve-u-19439370b67\"] label { letter-spacing: var(--tve-letter-spacing,4px); }:not(#tve) [data-css=\"tve-u-19439370b67\"] p, :not(#tve) [data-css=\"tve-u-19439370b67\"] li, :not(#tve) [data-css=\"tve-u-19439370b67\"] blockquote, :not(#tve) [data-css=\"tve-u-19439370b67\"] address, :not(#tve) [data-css=\"tve-u-19439370b67\"] .tcb-plain-text, :not(#tve) [data-css=\"tve-u-19439370b67\"] label, :not(#tve) [data-css=\"tve-u-19439370b67\"] h1, :not(#tve) [data-css=\"tve-u-19439370b67\"] h2, :not(#tve) [data-css=\"tve-u-19439370b67\"] h3, :not(#tve) [data-css=\"tve-u-19439370b67\"] h4, :not(#tve) [data-css=\"tve-u-19439370b67\"] h5, :not(#tve) [data-css=\"tve-u-19439370b67\"] h6 { text-transform: var(--tve-text-transform,uppercase); }[data-css=\"tve-u-19439370b65\"] .tve_sep { background-image: url(\"data:image\/svg+xml;charset=utf8,%3Csvg version='1.1' xmlns='http:\/\/www.w3.org\/2000\/svg' xmlns:xlink='http:\/\/www.w3.org\/1999\/xlink' x='0px' y='0px' viewBox='0 0 9 3' style='enable-background:new 0 0 9 3;' xml:space='preserve'%3E%3Ccircle fill='rgba(0,0,0,0.12)' cx='4.5' cy='1.5' r='1.5'\/%3E%3C\/svg%3E\"); --tve-applied-background-image: url(\"data:image\/svg+xml;charset=utf8,%3Csvg version='1.1' xmlns='http:\/\/www.w3.org\/2000\/svg' xmlns:xlink='http:\/\/www.w3.org\/1999\/xlink' x='0px' y='0px' viewBox='0 0 9 3' style='enable-background:new 0 0 9 3;' xml:space='preserve'%3E%3Ccircle fill='rgba(0,0,0,0.12)' cx='4.5' cy='1.5' r='1.5'\/%3E%3C\/svg%3E\"); background-size: 4px 4px; background-position: center top; width: 4px !important; }:not(#tve) [data-css=\"tve-u-19439370b6a\"] { background-color: rgb(255, 255, 255) !important; --tve-applied-background-color: rgb(255,255,255) !important; }[data-css=\"tve-u-19439370b6a\"] { clip-path: url(\"#clip-top-291d438d4bbf9\"); -webkit-clip-path: url(\"#clip-top-291d438d4bbf9\");  overflow: hidden; box-shadow: none; --tve-applied-box-shadow: none; border-radius: 10px !important; }[data-css=\"tve-u-19439370b6c\"] { font-size: 16px; width: 16px; height: 16px; --tve-icon-size: 16px; margin-top: 8px !important; }:not(#tve) [data-css=\"tve-u-19439370b6c\"] > :first-child { color: var(--tcb-local-color-cd122); --tve-applied-color: var$(--tcb-local-color-cd122); }[data-css=\"tve-u-19439370b6e\"] { font-size: 8px; width: 8px; height: 8px; --tve-icon-size: 8px; }:not(#tve) [data-css=\"tve-u-19439370b70\"] > :first-child { color: rgba(0, 0, 0, 0.2); --tve-applied-color: rgba(0,0,0,0.2); }[data-css=\"tve-u-19439370b70\"] { font-size: 8px; width: 8px; height: 8px; --tve-icon-size: 8px; }:not(#tve) [data-css=\"tve-u-19439370b6e\"] > :first-child { color: rgba(0, 0, 0, 0.2); --tve-applied-color: rgba(0,0,0,0.2); }[data-css=\"tve-u-19439370b6b\"] { font-size: var(--tve-font-size,20px); --tve-font-size: 20px; color: var(--tve-color,rgb(0,0,0)); --tve-color: rgb(0,0,0); --tcb-applied-color: rgb(0,0,0); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; border-radius: 0px; overflow: hidden; line-height: var(--tve-line-height,1.6em); --tve-line-height: 1.6em; padding: 1px !important; margin: 4px 0px !important; background-image: none !important; --tve-applied-background-image: none !important; }[data-css=\"tve-u-19439370b6b\"].tve-state-expanded { color: var(--tve-color,var(--tcb-local-color-e7784)); --tve-color: var(--tcb-local-color-e7784); --tcb-applied-color: var$(--tcb-local-color-e7784); }:not(#tve) [data-css=\"tve-u-19439370b6b\"]:hover { color: var(--tve-color,rgb(0,0,0)) !important; --tve-color: rgb(0,0,0) !important; --tcb-applied-color: rgb(0,0,0) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; }[data-css=\"tve-u-19439370b6d\"] { font-size: var(--tve-font-size,18px); --tve-font-size: 18px; color: var(--tve-color,rgb(95,95,95)); --tve-color: rgb(95,95,95); --tcb-applied-color: rgb(95,95,95); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; line-height: var(--tve-line-height,1.6em); --tve-line-height: 1.6em; padding-top: 5px !important; padding-bottom: 5px !important; margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-19439370b6d\"]:hover { color: var(--tve-color,rgb(0,0,0)) !important; --tve-color: rgb(0,0,0) !important; --tcb-applied-color: rgb(0,0,0) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; }[data-css=\"tve-u-19439370b6d\"].tve-state-expanded { color: var(--tve-color,var(--tcb-local-color-e7784)); --tve-color: var(--tcb-local-color-e7784); --tcb-applied-color: var$(--tcb-local-color-e7784); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); }[data-css=\"tve-u-19439370b6f\"] { font-size: var(--tve-font-size,18px); --tve-font-size: 18px; color: var(--tve-color,rgb(95,95,95)); --tve-color: rgb(95,95,95); --tcb-applied-color: rgb(95,95,95); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); font-family: var(--tve-font-family,inherit); --tve-font-family: inherit; line-height: var(--tve-line-height,1.6em); --tve-line-height: 1.6em; padding-top: 5px !important; padding-bottom: 5px !important; margin-top: 0px !important; }:not(#tve) [data-css=\"tve-u-19439370b6f\"]:hover { color: var(--tve-color,rgb(0,0,0)) !important; --tve-color: rgb(0,0,0) !important; --tcb-applied-color: rgb(0,0,0) !important; font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)) !important; --tve-font-weight: var(--g-regular-weight,normal) !important; }[data-css=\"tve-u-19439370b6f\"].tve-state-expanded { color: var(--tve-color,var(--tcb-local-color-e7784)); --tve-color: var(--tcb-local-color-e7784); --tcb-applied-color: var$(--tcb-local-color-e7784); font-weight: var(--tve-font-weight,var(--g-regular-weight,normal)); --tve-font-weight: var(--g-regular-weight,normal); }[data-css=\"tve-u-173dc82388f\"] { padding: 0px !important; }[data-css=\"tve-u-173dc824915\"] { padding: 0px !important; }[data-css=\"tve-u-173dc8252a4\"] { padding: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194393bc8c7\"] { --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-194393bc8c7\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393bc8c7\"] 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-194393bc8c7\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194393bc8cc\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 10px !important; padding-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-194393fb3c5\"] { --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-194393fb3c5\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-194393fb3c5\"] 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-194393fb3c5\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-194393fb3ca\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 10px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-19439412592\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 10px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-19439416e86\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 10px !important; padding-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] label { font-size: var(--tve-font-size, 20px); }[data-css=\"tve-u-19439760d63\"] { --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-19439760d63\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-19439760d63\"] 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-19439760d63\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-19439760d68\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 10px !important; }}@media (max-width: 1023px){[data-css=\"tve-u-19439370b64\"] { margin-top: 25px !important; margin-bottom: 25px !important; padding-left: 0px !important; padding-bottom: 20px !important; }[data-css=\"tve-u-19439370b69\"] { margin-left: 20px !important; margin-right: 20px !important; margin-bottom: 0px !important; }}@media (max-width: 767px){[data-css=\"tve-u-19439370b64\"] { --tve-toc-indent: 25px; margin-top: 20px !important; margin-bottom: 20px !important; padding-bottom: 20px !important; }[data-css=\"tve-u-19439370b6b\"] { --tve-font-size: 16px; font-size: var(--tve-font-size,16px); margin-right: 0px !important; padding-top: 10px !important; margin-top: 0px !important; }[data-css=\"tve-u-19439370b6d\"] { --tve-font-size: 16px; font-size: var(--tve-font-size,16px); padding-top: 10px !important; margin-top: 0px !important; }[data-css=\"tve-u-19439370b6f\"] { --tve-font-size: 16px; font-size: var(--tve-font-size,16px); padding-top: 10px !important; margin-top: 0px !important; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"0","_tve_footer":"0"},"categories":[1],"tags":[7671,7531,7672],"class_list":["post-60896","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-y-contabilidad","tag-desbordamiento-excel","tag-formulas-desbordadas","tag-funciones-desbordadas"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/60896","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=60896"}],"version-history":[{"count":3,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/60896\/revisions"}],"predecessor-version":[{"id":66755,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/60896\/revisions\/66755"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/60898"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=60896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=60896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=60896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}