{"id":47683,"date":"2022-07-18T15:55:12","date_gmt":"2022-07-18T21:55:12","guid":{"rendered":"https:\/\/aplicaexcelcontable.com\/blog\/?p=47683"},"modified":"2025-01-05T18:29:25","modified_gmt":"2025-01-06T00:29:25","slug":"formulas-desbordadas","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/formulas-desbordadas.html","title":{"rendered":"Formulas Desbordadas"},"content":{"rendered":"<h1 style=\"text-align: center;\">Que son las formulas Desbordadas ?<\/h1>\n<p style=\"\">Estas listo para aprender a utilizar las formulas desbordadas paso a paso ?<\/p>\n<p><span><img decoding=\"async\" alt=\"formulas Desbordadas\" data-id=\"48248\" width=\"529\" data-init-width=\"529\" height=\"169\" data-init-height=\"169\" title=\"Formulas Desbordadas en excel\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Formulas-Desbordadas-en-excel.png\" data-width=\"529\" data-height=\"169\"><\/span><\/p>\n<p style=\"\">Al llegar excel 2021 y las actualizaciones en office 365, ahora tenemos nuevas funciones para crear formulas desbordadas.<\/p>\n<p style=\"\">Hola soy <strong>Roger Perez<\/strong>, y en este video, quiero compartir contigo la nueva lista de funciones para crear formulas desbordadas.<\/p>\n<p style=\"\">Estas listo ?<\/p>\n<p style=\"\">Comencemos:<\/p>\n<h2 style=\"text-align: center;\">Que significa Formulas Desbordadas ?<\/h2>\n<p style=\"\">Como primer paso, debemso de conocer que es un desbordamiento en excel.<\/p>\n<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>\n<p style=\"\">Por ejemplo:<\/p>\n<p><span><img decoding=\"async\" alt=\"formulas Desbordadas\" 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\"><\/span><\/p>\n<p style=\"\">Muy bien, ahora vamos a conocer cuales son las nuevas funciones que genera desbordamiento al aplicarlo en una celda.<\/p>\n<h2 style=\"text-align: center;\">Nuevas funciones que genera desbordamientos<\/h2>\n<p>A continuacion, la lista de nuevas funciones de desbordamiento en excel 2021 y en office 365:<\/p>\n<ul>\n<li><span>FILTRAR<\/span><\/li>\n<li><span>ORDENAR<\/span><\/li>\n<li><span>ORDENARPOR<\/span><\/li>\n<li><span>UNICOS<\/span><\/li>\n<li><span>SECUENCIA<\/span><\/li>\n<li><span>MATRIZALEAT<\/span><\/li>\n<\/ul>\n<p>Estas funciones, son indispensables para todos los usuarios que utilizan excel en su contabilidad, para el control de inventarios y analisis de ventas.<\/p>\n<p>A continuacion, algunas puntos a tomar en cuenta al utilizar las formulas desbordadas:<\/p>\n<h3 style=\"text-align: center;\">Puntos a tomar en cuenta al utilizar formulas desbordadas<\/h3>\n<ul>\n<li style=\"\"><span>Al escribir una formula desbordad y 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.<\/span><\/li>\n<li style=\"\"><span>Las f\u00f3rmulas desbordadas 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.<\/span><\/li>\n<li style=\"\"><span>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>\n<\/ul>\n<p><span><img decoding=\"async\" alt=\"formulas Desbordadas\" 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\"><\/span><\/p>\n<ul>\n<li style=\"\"><span>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 \u00abfantasma\u00bb y no se puede cambiar.&nbsp;<\/span><\/li>\n<li style=\"\"><span>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>\n<\/ul>\n<p style=\"\">Hasta aqui te hemos compartido las generalidades de las formulas desbordadas, en los siguientes articulos te compartire ejemplo de cada una de las funciones para aplicarlo a tu contabilidad.<\/p>\n<p style=\"\">Que tal te parecio el articulo de hoy ? te gusto ?<\/p>\n<p style=\"\">Si te gusto, te invito a que lo compartas con tus amigos de facebook, pulsando clic en el boton <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">compartir<\/a>:<\/p>\n<p style=\"\">Cualquier duda o pregunta, tan solo escribenos en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">pagina del chat<\/a> o bien a rogerperez@aplicaexcelcontable.com.<\/p>\n<p style=\"\">Saludos,<\/p>\n<p style=\"\"><strong>Roger Perez &#8211; Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Que son las formulas Desbordadas ? Estas listo para aprender a utilizar las formulas desbordadas paso a paso ? Al llegar excel 2021 y las actualizaciones en office 365, ahora tenemos nuevas funciones para crear formulas desbordadas. Hola soy Roger Perez, y en este video, quiero compartir contigo la nueva lista de funciones para crear [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":48248,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"<div class=\"thrv_wrapper thrv_text_element\"><h1 style=\"text-align: center;\" data-css=\"tve-u-182119ab6eb\" class=\"\">Que son las formulas Desbordadas ?<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-182119b1ab3\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-182119b1aad\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Estas listo para aprender a utilizar las formulas desbordadas paso a paso ?<\/p><\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-1821332e021\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-48248\" alt=\"formulas Desbordadas\" data-id=\"48248\" width=\"529\" data-init-width=\"529\" height=\"169\" data-init-height=\"169\" title=\"Formulas Desbordadas en excel\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2022\/07\/Formulas-Desbordadas-en-excel.png\" data-width=\"529\" data-height=\"169\" style=\"aspect-ratio: auto 529 \/ 169;\"><\/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 formulas desbordadas.<\/p><\/div><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Hola soy <strong>Roger Perez<\/strong>, y en este video, quiero compartir contigo la nueva lista de funciones para crear formulas desbordadas.<\/p><p style=\"\">Estas listo ?<\/p><p style=\"\">Comencemos:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 style=\"text-align: center;\" data-css=\"tve-u-182124290f4\" class=\"\">Que significa Formulas Desbordadas ?<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-18212436735\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-1821243672e\"><div class=\"thrv_wrapper thrv_text_element\"><p style=\"\">Como primer paso, debemso 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-182133dadc3\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-48250\" alt=\"formulas Desbordadas\" 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-182124942cd\" class=\"\">Nuevas funciones que genera desbordamientos<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-182124aabe5\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-182124aabe0\"><div class=\"thrv_wrapper thrv_text_element\"><p>A continuacion, la lista de nuevas funciones de desbordamiento en excel 2021 y en office 365:<\/p><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-1821283bc7b\"><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-18212571eca\">FILTRAR<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-1821283bc7b\"><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-18212571eca\">ORDENAR<\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-1821283bc7b\"><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-18212571eca\">ORDENARPOR<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-1821283bc7b\"><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-1821257f1cb\"><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-18212571eca\">UNICOS<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-1821283bc7b\"><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-18212582262\"><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-18212571eca\">SECUENCIA<br><\/span><\/li><li class=\"thrv-styled-list-item\" data-css=\"tve-u-1821283bc7b\"><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-182125895be\"><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-18212571eca\">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 analisis de ventas.<\/p><p>A continuacion, algunas puntos a tomar en cuenta al utilizar las formulas desbordadas:<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"text-align: center;\" data-css=\"tve-u-18212894747\" class=\"\">Puntos a tomar en cuenta al utilizar formulas desbordadas<\/h3><\/div><div class=\"thrv_wrapper thrv-styled_list tcb-icon-display\" data-icon-code=\"icon-arrow-circle-right-solid\" style=\"\" data-css=\"tve-u-182128a7d1f\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" data-css=\"tve-u-182134cffc9\" 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-1821289dc16\" 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-1821289dedf\"><div style=\"text-align: justify;\">Al escribir una formula desbordad y 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-182134cffc9\" 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-1821289dc16\" 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-1821289dedf\"><div style=\"text-align: justify;\">Las f\u00f3rmulas desbordadas 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-182134cffc9\" 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-1821289dc16\" 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-1821289dedf\">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-182134cc36a\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image wp-image-48253\" alt=\"formulas Desbordadas\" 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-1821295abb1\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\" 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-1821295abb4\" 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-1821295abb6\"><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=\"\"><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-1821295abbb\" 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-1821295abbd\">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-182129a777e\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-182129a7778\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Hasta aqui te hemos compartido las generalidades de las formulas desbordadas, en los siguientes articulos te compartire ejemplo de cada una de las funciones para aplicarlo a tu contabilidad.<\/p><p style=\"\">Que tal te parecio el articulo de hoy ? te gusto ?<\/p><p style=\"\">Si te gusto, te invito a que lo compartas con tus amigos de facebook, pulsando clic en el boton <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">compartir<\/a>:<\/p><\/div><\/div>\n<\/div><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;button_type&quot;:&quot;tve_social_ib&quot;},&quot;tablet&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;},&quot;mobile&quot;:{&quot;button_type&quot;:&quot;tve_social_ib&quot;,&quot;showCount&quot;:&quot;0&quot;}}\" data-css=\"tve-u-182129d2df6\" style=\"\">\n<div class=\"tve_social_items tve_social_custom tve-prevent-content-edit tve_style_6 tve_social_ib\">\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=\"https:\/\/aplicaexcelcontable.com\/blog\/formulas-desbordadas.html\" 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 tve-froala\">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=\"https:\/\/aplicaexcelcontable.com\/blog\/formulas-desbordadas.html\" 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 tve-froala\">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=\"https:\/\/aplicaexcelcontable.com\/blog\/formulas-desbordadas.html\" 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 tve-froala\">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 class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-182129dbfaa\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-182129dbfa3\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Cualquier duda o pregunta, tan solo escribenos en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" class=\"\" style=\"outline: none;\">pagina del chat<\/a> o bien a rogerperez@aplicaexcelcontable.com.<\/p><p style=\"\">Saludos,<\/p><p style=\"\"><strong>Roger Perez - Aplica Excel Contable<\/strong><\/p><\/div><\/div>\n<\/div>","tve_custom_css":"@media (min-width: 300px){:not(#tve) [data-css=\"tve-u-182119ab6eb\"] { font-size: 38px !important; color: rgb(0, 4, 4) !important; --tcb-applied-color: rgb(0,4,4) !important; --tve-applied-color: rgb(0,4,4) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-182119b1aad\"] { --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-182119b1aad\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-182119b1aad\"] 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-182119b1aad\"] p { padding: 0px 0px 13px !important; margin: 0px !important; }[data-css=\"tve-u-182119b1ab3\"] { margin-top: 0px !important; margin-bottom: 0px !important; }:not(#tve) [data-css=\"tve-u-182124290f4\"] { 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; }:not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-1821243672e\"] { --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-1821243672e\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-1821243672e\"] 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-1821243672e\"] p { padding: 0px 0px 10px !important; margin: 0px !important; }[data-css=\"tve-u-18212436735\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-top: 0px !important; padding-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-182124942cd\"] { font-size: 29px !important; color: rgb(0, 6, 7) !important; --tcb-applied-color: rgb(0,6,7) !important; --tve-applied-color: rgb(0,6,7) !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-182124aabe0\"] { --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-182124aabe0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-182124aabe0\"] 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-182124aabe0\"] p { padding: 0px !important; margin: 0px !important; }[data-css=\"tve-u-182124aabe5\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-top: 0px !important; padding-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-18212894747\"] { color: rgb(0, 4, 4) !important; --tcb-applied-color: rgb(0,4,4) !important; --tve-applied-color: rgb(0,4,4) !important; }[data-css=\"tve-u-1821289dc16\"] { --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-182128a7d1f\"] 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-182128a7d1f\"] { --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-1821295abb1\"] 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-1821295abb1\"] { --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-1821295abb4\"] { --tcb-local-color-icon: rgb(59,59,59); --tcb-local-color-var: rgb(59,59,59); --tve-icon-size: 18px; }[data-css=\"tve-u-1821295abbb\"] { --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-182129a7778\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-182129a7778\"] { --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-182129a7778\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129a7778\"] 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-182129a7778\"] p { padding: 0px 0px 13px !important; margin: 0px !important; }[data-css=\"tve-u-182129a777e\"] { margin-top: 0px !important; margin-bottom: 0px !important; padding-top: 0px !important; padding-bottom: 10px !important; }[data-css=\"tve-u-182129d2df6\"] { float: none; z-index: 3; position: relative; --tve-alignment: center; margin: 0px auto 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-182129dbfa3\"] { --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-182129dbfa3\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-182129dbfa3\"] 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-182129dbfa3\"] p { padding: 0px 0px 13px !important; margin: 0px !important; }[data-css=\"tve-u-182129dbfaa\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-1821332e021\"] { width: 529px; --tve-alignment: center; float: none; margin: 0px auto !important; }[data-css=\"tve-u-182133dadc3\"] { 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: 0px auto 10px !important; }[data-css=\"tve-u-182134cc36a\"] { 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; }}","tve_user_custom_css":"","tve_globals":{"e":"1","font_cls":[]},"tcb2_ready":1,"tcb_editor_enabled":1,"tve_landing_page":"","_tve_header":"0","_tve_footer":"0"},"categories":[72],"tags":[7532,7531,7533],"class_list":["post-47683","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas-excel","tag-desbordadas-excel","tag-formulas-desbordadas","tag-formulas-desbordadas-excel","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/47683","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=47683"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/47683\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/48248"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=47683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=47683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=47683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}