{"id":16916,"date":"2014-07-20T09:01:59","date_gmt":"2014-07-20T15:01:59","guid":{"rendered":"http:\/\/aplicaexcelcontable.com\/blog\/?p=16916"},"modified":"2024-12-24T21:50:16","modified_gmt":"2024-12-25T03:50:16","slug":"referencias-en-excel","status":"publish","type":"post","link":"https:\/\/aplicaexcelcontable.com\/blog\/referencias-en-excel.html","title":{"rendered":"Referencias en Excel"},"content":{"rendered":"<h1 style=\"text-align: center;\">Dominando las Referencias en Excel<\/h1>\n<p style=\"\">Logre utilizar Excel a\u00f1o y medio antes de enterarme de las referencias relativas en Excel (Las referencias de celdas en Excel).&nbsp;<\/p>\n<p style=\"\">Era una sensaci\u00f3n de felicidad al saber que en realidad se puede escribir una formula Excel y poder utilizar el poder del auto-llenado para hacer que Excel haga el trabajo autom\u00e1tico.<\/p>\n<h2 style=\"text-align: center;\">Tipos de Referencias en Excel<\/h2>\n<p style=\"\">A continuaci\u00f3n voy a compartirte los tipos de Referencias de celda en Excel:<\/p>\n<ul>\n<li><span>Referencias Relativas este es la predeterminada.<\/span><\/li>\n<li><span>Referencias Absolutas.<\/span><\/li>\n<li><span>Referencias Mixtas<\/span><\/li>\n<\/ul>\n<h2>\u00bfQue son las Referencias en Excel?<\/h2>\n<p style=\"\">Las referencias en Excel \u00abidentifica una celda o un rango de celdas en una hoja de c\u00e1lculo de Microsoft Excel y le dice d\u00f3nde buscar los valores o los datos que desea utilizar en una formula Excel.\u00bb<\/p>\n<h3 style=\"\">\u00bfQue es una referencia Relativa en Excel? &#8211; Referencias en Excel<\/h3>\n<p style=\"\">Una Referencia Relativa en Excel es la forma predeterminada que se utiliza en Excel para indicar el rango de una celda.<\/p>\n<p style=\"\">Es decir, una referencia relativa en Excel es totalmente dinamina, por que el rango de las cedas indicadas dentro de una formula var\u00edan si la formula se rellena en otras celdas.<\/p>\n<p style=\"\">Veamos un ejemplo: En la celda A2 tenemos el valor 20 en la celda C2 tenemos 100 como precio y en la D2 tenemos el total mediante formula =A2*C2, el resultado es 2000.<\/p>\n<p style=\"\">Ahora, si tu arrastras la formula de la D2 hacia la D3 y D4, podr\u00e1s ver que las formulas var\u00edan, en la celda D3 veras una formula asi: =A3*C3, en la D4 veras una formula as\u00ed: =A4*C4.<\/p>\n<p style=\"\">Puedes notar que los n\u00fameros var\u00edan totalmente al mover la formula y a esto se le llama referencia relativa, por que las referencias a las celdas dentro de la formula varia seg\u00fan la celda donde este ubicado la formula.<\/p>\n<h3>\u00bfQue son las referencias Absolutas Excel? &#8211; Referencias en Excel<\/h3>\n<p style=\"\">Las referencias absolutas Excel son aquellas referencias de rangos de celdas que se mantienen invariable dentro de una formula.<\/p>\n<p style=\"\">Incluso si cambiamos la posici\u00f3n de la celda que contiene la formula, este no variara.<\/p>\n<p style=\"\">Para hacer que una referencia sea absoluta en Excel debes de conocer el signo a usar, en este caso es el signo d\u00f3lar, peso, como le quieres llamar &gt;&gt; $ &lt;&lt;, debe de ser agregado antes de la letra de la columna o antes del numero de fila.<\/p>\n<p style=\"\">Veamos un ejemplo: Si dentro de la celda D5 tenemos la siguiente formula =(A5*C5)* $A$2 y rellenamos esta formula hacia la D6 y D7, podr\u00e1s observar que la referencia a la celda $A$2 no cambia.<\/p>\n<p style=\"\">Sabes por que no cambia, por que es una referencia absoluta, si tu vez que tiene el signo $ ya sabes es una referencia absoluta.<\/p>\n<h3>\u00bfQue son las referencias Mixtas en Excel? &#8211; Referencias en Excel<\/h3>\n<p style=\"\">Las referencias mixtas en Excel es una combinaci\u00f3n de las referencias relativas y las referencias absolutas.<\/p>\n<p style=\"\">En la formula anterior, sin intenci\u00f3n de presentarte una referencia mixta, te presenta la siguiente formula =(A5*C5)* $A$2, esta formula contiene referencia relativa y referencia absoluta.<\/p>\n<p style=\"\">Pero dentro de un rango de celda puede haber referencia relativa y referencia absoluta.<\/p>\n<p style=\"\">Veamos un ejemplo: En la siguiente formula escribimos =(A$5*$C5).<\/p>\n<p style=\"\">Con esta formula le estamos diciendo a Excel que tenemos una referencia mixta.<\/p>\n<p style=\"\">Para la primera referencia A$5 le estamos diciendo a Excel que la letra de la columna A puede cambiar si se mueve a la derecha, pero que el numero de fila 5 no puede cambiar si mueve abajo, arriba o a la derecha.<\/p>\n<p style=\"\">En la segunda referencia $C5, le estamos diciendo a Excel, que aunque se mueva la formula la letra de la columna C no debe cambiar, en cambio el numero de fila si podr\u00e1 cambiar seg\u00fan la ubicaci\u00f3n de la formula.<\/p>\n<h2 style=\"\">\u00bfCual es la Diferencia entre Referencias Relativas y Absolutas? &#8211; Referencias en Excel<\/h2>\n<p style=\"\">Cuando indicas que una referencia es relativa, estas indicando a Excel que ajuste las referencia en las f\u00f3rmulas a base a donde se mueve o copia la f\u00f3rmula.<\/p>\n<p style=\"\">Por ejemplo: si tiene una f\u00f3rmula en la celda B1 como = A1 * 2 y ahora si copias o pegas esta formula en otra celda, digamos en la C1, la nueva f\u00f3rmula se leer\u00eda como = B1 * 2.<\/p>\n<p><span><img decoding=\"async\" alt=\"Referencias en Excel\" width=\"148\" data-init-width=\"156\" height=\"144\" data-init-height=\"152\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Referencia-Relativa-en-Formulas-Excel.gif\" data-width=\"148\" data-height=\"144\" style=\"aspect-ratio: auto 156 \/ 152;\"><\/span><\/p>\n<p style=\"\">Cuando indicas que una referencia es absoluta, le est\u00e1 diciendo Excel que no ajuste la referencia en las f\u00f3rmulas al mover o copiarlos.<\/p>\n<p><span><img decoding=\"async\" alt=\"Referencias en Excel\" width=\"148\" data-init-width=\"156\" height=\"144\" data-init-height=\"152\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Referencias-Absolutas-en-Formulas-Excel.gif\" data-width=\"148\" data-height=\"144\" style=\"aspect-ratio: auto 156 \/ 152;\"><\/span><\/p>\n<h2>Como cambiar entre Referencias Relativas y Absolutas &#8211; Referencias en Excel<\/h2>\n<p style=\"\">Durante la edici\u00f3n de las f\u00f3rmulas <strong>se puede utilizar la tecla de funci\u00f3n F4 para cambiar la referencia<\/strong> de una celda en la que se centra el cursor.<\/p>\n<p style=\"\">Pulsando F4, Excel cambia las referencias entre relativa (A2), absoluta ($ A $ 2), la columna relativa y fila absoluta (A $ 2) y absoluta columna y fila relativa ($ A2).<\/p>\n<p><span><img decoding=\"async\" alt=\"Referencias en Excel\" width=\"148\" data-init-width=\"88\" height=\"54\" data-init-height=\"32\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Cambiar-Referencia-Relativa-a-Absoluta.gif\" data-width=\"148\" data-height=\"54\" style=\"aspect-ratio: auto 88 \/ 32;\"><\/span><\/p>\n<p style=\"\">Entender las referencias relativas y absolutas juega un papel clave en la escritura de f\u00f3rmulas de hojas de c\u00e1lculo de forma eficiente.<\/p>\n<p style=\"\">Hasta aqui con el tema de las Referencias en Excel, que tal te parecio? Te gusto?<\/p>\n<p style=\"\">Si te gusto, te invito a compartirlo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" style=\"outline: none;\" rel=\"noopener\">facebook<\/a>, por WhatsApp, correo electr\u00f3nico y mucho mas, a continuaci\u00f3n te dejo el bot\u00f3n compartir:<\/p>\n<p style=\"\">Cualquier duda o pregunta, puedes escribirme directamente en la<span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">&nbsp;<\/span><a href=\"#comentario\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(237, 243, 13) !important;\">secci\u00f3n de comentarios<\/span><\/a>, en la <a href=\"https:\/\/aplicaexcelcontable.com\/blog\/contacto\" target=\"_blank\" style=\"outline: none;\"><span style=\"--tcb-text-highlight-color: rgb(231, 100, 224) !important;\" data-text-highlight=\"bubble\">pagina del chat<\/span><\/a>, directamente en <span style=\"--tcb-text-highlight-color: rgb(30, 184, 76) !important;\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\">Te saluda,<span style=\"--tcb-text-highlight-color: transparent !important;\"><\/span><\/p>\n<p style=\"\"><strong>Roger Perez \u2013 Aplica Excel Contable<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dominando las Referencias en Excel Logre utilizar Excel a\u00f1o y medio antes de enterarme de las referencias relativas en Excel (Las referencias de celdas en Excel).&nbsp; Era una sensaci\u00f3n de felicidad al saber que en realidad se puede escribir una formula Excel y poder utilizar el poder del auto-llenado para hacer que Excel haga el [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":16918,"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;\" class=\"\" data-css=\"tve-u-193fb1d2758\">Dominando las Referencias en Excel<\/h1><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193faa6d9c1\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193faa6d9b8\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Logre utilizar Excel a\u00f1o y medio antes de enterarme de las referencias relativas en Excel (Las referencias de celdas en Excel).&nbsp;<\/p><p style=\"\">Era una sensaci\u00f3n de felicidad al saber que en realidad se puede escribir una formula Excel y poder utilizar el poder del auto-llenado para hacer que Excel haga el trabajo autom\u00e1tico.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" style=\"text-align: center;\" data-css=\"tve-u-193fbd6cda5\">Tipos de Referencias en Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193faa6d9c1\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193faa6d9b8\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">A continuaci\u00f3n voy a compartirte los tipos de Referencias de celda en Excel:<\/p><\/div><div class=\"thrv_wrapper thrv-styled_list\" data-icon-code=\"icon-check\" data-css=\"tve-u-193fbd9f59c\" style=\"\"><ul class=\"tcb-styled-list\"><li class=\"thrv-styled-list-item\"><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-193fbd9bc65\" style=\"\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\" style=\"\"><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-193fbd90165\">Referencias Relativas este es la predeterminada.<\/span><\/li><li class=\"thrv-styled-list-item\"><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-193fbd9bc65\" style=\"\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\" style=\"\"><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-193fbd90165\">Referencias Absolutas.<\/span><\/li><li class=\"thrv-styled-list-item\"><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-193fbd9bc65\" style=\"\"><svg class=\"tcb-icon tcb-local-vars-root\" viewBox=\"0 0 32 32\" data-id=\"icon-check\" data-name=\"\" style=\"\"><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-193fbd90165\">Referencias Mixtas<\/span><\/li><\/ul><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\">\u00bfQue son las Referencias en Excel?<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fab26fe7\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fab26fdf\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Las referencias en Excel \"identifica una celda o un rango de celdas en una hoja de c\u00e1lculo de Microsoft Excel y le dice d\u00f3nde buscar los valores o los datos que desea utilizar en una formula Excel.\"<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 style=\"\" class=\"\">\u00bfQue es una referencia Relativa en Excel? - Referencias en Excel<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fbaa929d\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fbaa9298\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Una Referencia Relativa en Excel es la forma predeterminada que se utiliza en Excel para indicar el rango de una celda.<\/p><p style=\"\">Es decir, una referencia relativa en Excel es totalmente dinamina, por que el rango de las cedas indicadas dentro de una formula var\u00edan si la formula se rellena en otras celdas.<\/p><p style=\"\">Veamos un ejemplo: En la celda A2 tenemos el valor 20 en la celda C2 tenemos 100 como precio y en la D2 tenemos el total mediante formula =A2*C2, el resultado es 2000.<\/p><p style=\"\">Ahora, si tu arrastras la formula de la D2 hacia la D3 y D4, podr\u00e1s ver que las formulas var\u00edan, en la celda D3 veras una formula asi: =A3*C3, en la D4 veras una formula as\u00ed: =A4*C4.<\/p><p style=\"\">Puedes notar que los n\u00fameros var\u00edan totalmente al mover la formula y a esto se le llama referencia relativa, por que las referencias a las celdas dentro de la formula varia seg\u00fan la celda donde este ubicado la formula.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 class=\"\">\u00bfQue son las referencias Absolutas Excel? - Referencias en Excel<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fbbdaef5\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fbbdaef0\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Las referencias absolutas Excel son aquellas referencias de rangos de celdas que se mantienen invariable dentro de una formula.<\/p><p style=\"\">Incluso si cambiamos la posici\u00f3n de la celda que contiene la formula, este no variara.<\/p><p style=\"\">Para hacer que una referencia sea absoluta en Excel debes de conocer el signo a usar, en este caso es el signo d\u00f3lar, peso, como le quieres llamar &gt;&gt; $ &lt;&lt;, debe de ser agregado antes de la letra de la columna o antes del numero de fila.<\/p><p style=\"\">Veamos un ejemplo: Si dentro de la celda D5 tenemos la siguiente formula =(A5*C5)* $A$2 y rellenamos esta formula hacia la D6 y D7, podr\u00e1s observar que la referencia a la celda $A$2 no cambia.<\/p><p style=\"\">Sabes por que no cambia, por que es una referencia absoluta, si tu vez que tiene el signo $ ya sabes es una referencia absoluta.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h3 class=\"\">\u00bfQue son las referencias Mixtas en Excel? - Referencias en Excel<\/h3><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fbcd4ca4\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fbcd4c9e\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Las referencias mixtas en Excel es una combinaci\u00f3n de las referencias relativas y las referencias absolutas.<\/p><p style=\"\">En la formula anterior, sin intenci\u00f3n de presentarte una referencia mixta, te presenta la siguiente formula =(A5*C5)* $A$2, esta formula contiene referencia relativa y referencia absoluta.<\/p><p style=\"\">Pero dentro de un rango de celda puede haber referencia relativa y referencia absoluta.<\/p><p style=\"\">Veamos un ejemplo: En la siguiente formula escribimos =(A$5*$C5).<\/p><p style=\"\">Con esta formula le estamos diciendo a Excel que tenemos una referencia mixta.<\/p><p style=\"\">Para la primera referencia A$5 le estamos diciendo a Excel que la letra de la columna A puede cambiar si se mueve a la derecha, pero que el numero de fila 5 no puede cambiar si mueve abajo, arriba o a la derecha.<\/p><p style=\"\">En la segunda referencia $C5, le estamos diciendo a Excel, que aunque se mueva la formula la letra de la columna C no debe cambiar, en cambio el numero de fila si podr\u00e1 cambiar seg\u00fan la ubicaci\u00f3n de la formula.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\" data-css=\"tve-u-193fabe6a05\" style=\"\">\u00bfCual es la Diferencia entre Referencias Relativas y Absolutas? - Referencias en Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fabef1fd\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fabef1f7\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Cuando indicas que una referencia es relativa, estas indicando a Excel que ajuste las referencia en las f\u00f3rmulas a base a donde se mueve o copia la f\u00f3rmula.<\/p><p style=\"\">Por ejemplo: si tiene una f\u00f3rmula en la celda B1 como = A1 * 2 y ahora si copias o pegas esta formula en otra celda, digamos en la C1, la nueva f\u00f3rmula se leer\u00eda como = B1 * 2.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-193fb0b3b2e\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image\" alt=\"Referencias en Excel\" width=\"148\" data-init-width=\"156\" height=\"144\" data-init-height=\"152\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Referencia-Relativa-en-Formulas-Excel.gif\" data-width=\"148\" data-height=\"144\" style=\"aspect-ratio: auto 156 \/ 152;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fb0c1197\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fb0c118f\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Cuando indicas que una referencia es absoluta, le est\u00e1 diciendo Excel que no ajuste la referencia en las f\u00f3rmulas al mover o copiarlos.<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-193fb0b3b2e\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image\" alt=\"Referencias en Excel\" width=\"148\" data-init-width=\"156\" height=\"144\" data-init-height=\"152\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Referencias-Absolutas-en-Formulas-Excel.gif\" data-width=\"148\" data-height=\"144\" style=\"aspect-ratio: auto 156 \/ 152;\"><\/span><\/div><div class=\"thrv_wrapper thrv_text_element\"><h2 class=\"\">Como cambiar entre Referencias Relativas y Absolutas - Referencias en Excel<\/h2><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fb0e0677\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fb0e0672\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Durante la edici\u00f3n de las f\u00f3rmulas <strong>se puede utilizar la tecla de funci\u00f3n F4 para cambiar la referencia<\/strong> de una celda en la que se centra el cursor.<\/p><p style=\"\">Pulsando F4, Excel cambia las referencias entre relativa (A2), absoluta ($ A $ 2), la columna relativa y fila absoluta (A $ 2) y absoluta columna y fila relativa ($ A2).<\/p><\/div><\/div>\n<\/div><div class=\"thrv_wrapper tve_image_caption\" data-css=\"tve-u-193fb0b3b2e\" style=\"\"><span class=\"tve_image_frame\"><img decoding=\"async\" class=\"tve_image\" alt=\"Referencias en Excel\" width=\"148\" data-init-width=\"88\" height=\"54\" data-init-height=\"32\" loading=\"lazy\" src=\"https:\/\/aplicaexcelcontable.com\/blog\/wp-content\/uploads\/2014\/07\/Cambiar-Referencia-Relativa-a-Absoluta.gif\" data-width=\"148\" data-height=\"54\" style=\"aspect-ratio: auto 88 \/ 32;\"><\/span><\/div><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fb1131a5\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fb11319f\"><div class=\"thrv_wrapper thrv_text_element\">\t<p style=\"\">Entender las referencias relativas y absolutas juega un papel clave en la escritura de f\u00f3rmulas de hojas de c\u00e1lculo de forma eficiente.<\/p><p style=\"\">Hasta aqui con el tema de las Referencias en Excel, que tal te parecio? Te gusto?<\/p><p style=\"\">Si te gusto, te invito a compartirlo con tus amigos de <a href=\"https:\/\/www.facebook.com\/AplicaExceContable\/\" target=\"_blank\" class=\"\" style=\"outline: none;\">facebook<\/a>, por WhatsApp, correo electr\u00f3nico y mucho mas, a continuaci\u00f3n te dejo el bot\u00f3n compartir:<\/p><\/div><\/div>\n<\/div><div class=\"tcb-clear\" data-css=\"tve-u-193fb13f72b\"><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-193fb13f72a\" 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 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=\"{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 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=\"{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 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><div class=\"thrv_wrapper thrv_contentbox_shortcode thrv-content-box tve-elem-default-pad\" data-css=\"tve-u-193fb147730\" style=\"\">\n\t<div class=\"tve-content-box-background\"><\/div>\n\t<div class=\"tve-cb\" style=\"\" data-css=\"tve-u-193fb14772f\"><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-193fb147731\">&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-193fb147732\">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-193fb147733\" 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-193fb147734\">whatsapp<\/span> o bien al correo electr\u00f3nico rogerperez@aplicaexcelcontable.com.<span style=\"--tcb-text-highlight-color: transparent !important;\" data-css=\"tve-u-193fb147735\"><\/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){.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; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193faa6d9b8\"] { --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-193faa6d9b8\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193faa6d9b8\"] 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-193faa6d9b8\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193faa6d9c1\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fab26fdf\"] { --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-193fab26fdf\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fab26fdf\"] 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-193fab26fdf\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fab26fe7\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-193fabe6a05\"] { text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fabef1f7\"] { --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-193fabef1f7\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fabef1f7\"] 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-193fabef1f7\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fabef1fd\"] { margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-193fb0b3b2e\"] { width: 156px; --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: 0px auto 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fb0c118f\"] { --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-193fb0c118f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0c118f\"] 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-193fb0c118f\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fb0c1197\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fb0e0672\"] { --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-193fb0e0672\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb0e0672\"] 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-193fb0e0672\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fb0e0677\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fb11319f\"] { --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-193fb11319f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb11319f\"] 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-193fb11319f\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fb1131a5\"] { margin-top: 0px !important; margin-bottom: 10px !important; padding-bottom: 0px !important; }[data-css=\"tve-u-193fb13f72a\"] { float: right; z-index: 3; position: relative; --tve-alignment: right; margin-top: 0px !important; margin-bottom: 10px !important; }[data-css=\"tve-u-193fb13f72b\"]::after { clear: both; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fb14772f\"] { --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-193fb14772f\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fb14772f\"] 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-193fb14772f\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fb147730\"] { margin-top: 20px !important; margin-bottom: 20px !important; padding: 0px !important; }[data-css=\"tve-u-193fb147731\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-193fb147732\"] { --tcb-text-highlight-color: rgb(237,243,13) !important; }[data-css=\"tve-u-193fb147733\"] { --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-193fb147734\"] { --tcb-text-highlight-color: rgb(30,184,76) !important; }[data-css=\"tve-u-193fb147735\"] { --tcb-text-highlight-color: transparent !important; }:not(#tve) [data-css=\"tve-u-193fb1d2758\"] { text-transform: none !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fbaa9298\"] { --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-193fbaa9298\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbaa9298\"] 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-193fbaa9298\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fbaa929d\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fbbdaef0\"] { --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-193fbbdaef0\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbbdaef0\"] 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-193fbbdaef0\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fbbdaef5\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] label { font-size: var(--tve-font-size,20px); }[data-css=\"tve-u-193fbcd4c9e\"] { --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-193fbcd4c9e\"] p, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] li, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] blockquote, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] address, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] .tcb-plain-text, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] label, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] h1, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] h2, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] h3, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] h4, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] h5, :not(#tve) .thrv-content-box [data-css=\"tve-u-193fbcd4c9e\"] 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-193fbcd4c9e\"] p { padding: 0px 0px 11px !important; margin: 0px !important; }[data-css=\"tve-u-193fbcd4ca4\"] { margin-top: 0px !important; margin-bottom: 10px !important; }:not(#tve) [data-css=\"tve-u-193fbd6cda5\"] { text-transform: none !important; }[data-css=\"tve-u-193fbd9bc65\"] { --tcb-local-color-icon: rgb(8,1,1); --tcb-local-color-var: rgb(8,1,1); --tve-icon-size: 20px; }:not(#tve) [data-css=\"tve-u-193fbd9bc65\"] > :first-child { color: rgb(8, 1, 1); --tve-applied-color: rgb(8,1,1); }[data-css=\"tve-u-193fbd9f59c\"] { margin-top: 0px !important; margin-bottom: 10px !important; }}@media (max-width: 1023px){.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(50% - 15px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+3) { margin-top: 30px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+3)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(2n)) { margin-right: 30px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(2n) { margin-right: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper { width: calc(50% - 10px); }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n+3) { margin-top: 30px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+3)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:not(:nth-child(2n)) { margin-right: 20px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(2n) { margin-right: 0px !important; }}@media (max-width: 767px){.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper { width: calc(100% + 0px); }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n+2) { margin-top: 30px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n+2)) { margin-top: 0px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:not(:nth-child(n)) { margin-right: 15px !important; }.tcb-post-list[data-css=\"tve-u-18703fb75db\"] .post-wrapper.thrv_wrapper:nth-child(n) { margin-right: 0px !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: 20px !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: 20px !important; }.tcb-post-list[data-css=\"tve-u-186df1bf84d\"] .post-wrapper.thrv_wrapper:nth-child(n) { 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":"","_tve_footer":""},"categories":[72],"tags":[66,296,91,90],"class_list":["post-16916","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-formulas-excel","tag-excel","tag-formulas-excel","tag-referencia-absoluta","tag-referencia-relativa","post-wrapper","thrv_wrapper"],"_links":{"self":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/16916","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=16916"}],"version-history":[{"count":0,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/posts\/16916\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media\/16918"}],"wp:attachment":[{"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/media?parent=16916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/categories?post=16916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aplicaexcelcontable.com\/blog\/wp-json\/wp\/v2\/tags?post=16916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}