{"id":13890,"date":"2023-08-29T15:02:45","date_gmt":"2023-08-29T15:02:45","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=13890"},"modified":"2023-08-29T15:07:55","modified_gmt":"2023-08-29T15:07:55","slug":"autollenado-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/","title":{"rendered":"AUTOLLENADO EN EXCEL"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #0a6e42;\"><strong><u>DOMINA EL AUTOLLENADO EN EXCEL: COMPLETA SERIES DE DATOS EN UN PARPADEO<\/u><\/strong><\/span><\/p><div id=\"excel-383420610\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<h6>INTRODUCCI\u00d3N: DESCUBRE EL PODER DEL AUTOLLENADO EN EXCEL<\/h6>\n<p>Cuando se trata de agilizar tus tareas en Excel, la funci\u00f3n de autollenado es una herramienta esencial que puede ahorrarte una gran cantidad de tiempo y esfuerzo. Ya seas un principiante en Excel o alguien que busca mejorar su eficiencia, aprender c\u00f3mo usar el autollenado te permitir\u00e1 completar r\u00e1pidamente series de n\u00fameros, fechas y texto en una columna. En esta gu\u00eda, te llevaremos paso a paso a trav\u00e9s del proceso de autollenado y te mostraremos c\u00f3mo puedes sacar el m\u00e1ximo provecho de esta funci\u00f3n imprescindible.<\/p>\n<h6>CAP\u00cdTULO 1: LOS FUNDAMENTOS DEL AUTOLLENADO<\/h6>\n<pre><strong>\u00bfQu\u00e9 es el Autollenado y por qu\u00e9 deber\u00eda importarte?<\/strong><\/pre>\n<p>El autollenado es una caracter\u00edstica inteligente de Excel que te permite completar autom\u00e1ticamente una serie de datos en una columna, bas\u00e1ndose en un patr\u00f3n que hayas establecido previamente. Esto es especialmente \u00fatil cuando necesitas generar una secuencia de n\u00fameros, fechas o incluso texto repetitivo, evitando la tarea tediosa de ingresar cada valor manualmente.<\/p>\n<h6>CAP\u00cdTULO 2: AUTOLLENADO DE SERIES NUM\u00c9RICAS<\/h6>\n<pre><strong>Generando Series Num\u00e9ricas con Autollenado<\/strong><\/pre>\n<p>Uno de los usos m\u00e1s comunes del autollenado es la generaci\u00f3n de series num\u00e9ricas. Para comenzar, simplemente ingresa el primer n\u00famero de la serie y luego arrastra el peque\u00f1o cuadro de autollenado en la esquina inferior derecha de la celda. Excel identificar\u00e1 el patr\u00f3n y completar\u00e1 autom\u00e1ticamente los n\u00fameros restantes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13893\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/series-numericas.png\" alt=\"\" width=\"431\" height=\"298\" \/><\/p>\n<pre><strong>Personalizaci\u00f3n de Series Num\u00e9ricas<\/strong><\/pre>\n<p>Pero el autollenado no se trata solo de simples series ascendentes. Puedes personalizar la secuencia num\u00e9rica al ingresar los primeros dos n\u00fameros y luego arrastrar el cuadro de autollenado. Excel detectar\u00e1 la diferencia entre los valores y completar\u00e1 la serie de acuerdo con el patr\u00f3n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13894\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/personalizaciond-e-numeros.png\" alt=\"\" width=\"420\" height=\"304\" \/><\/p>\n<h6>CAP\u00cdTULO 3: AUTOLLENADO DE FECHAS Y TEXTO<\/h6>\n<pre><strong>Agilizando Fechas con Autollenado<\/strong><\/pre>\n<p>Crear una serie de fechas puede ser una tarea abrumadora si se hace manualmente. Con el autollenado, puedes ingresar la primera fecha y luego arrastrar para completar la serie. Adem\u00e1s, Excel es inteligente en cuanto a la detecci\u00f3n de patrones, por lo que, si quieres incrementar las fechas por un d\u00eda, semana o mes, el autollenado se ajustar\u00e1 en consecuencia.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13895\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/FECHA.png\" alt=\"\" width=\"428\" height=\"284\" \/><\/p>\n<pre><strong>Texto en Series Repetitivas<\/strong><\/pre>\n<p>No se trata solo de n\u00fameros y fechas; el autollenado tambi\u00e9n es \u00fatil para series de texto. Por ejemplo, si tienes una lista de nombres o productos, solo necesitas ingresar el primer elemento y arrastrar para completar la serie.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13896\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/autorrellenar-texto.png\" alt=\"\" width=\"750\" height=\"288\" \/><\/p>\n<h6>CAP\u00cdTULO 4: AUTOLLENADO PERSONALIZADO<\/h6>\n<pre><strong>Creando Patrones \u00danicos<\/strong><\/pre>\n<p>Excel te permite crear patrones \u00fanicos para el autollenado. Si deseas repetir una palabra o frase espec\u00edfica en una serie, solo tienes que ingresar el primer valor y arrastrar para completar. Esto es ideal para generar direcciones, encabezados o cualquier otro texto personalizado.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12466\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/10\/autocompletar-texto.png\" alt=\"\" width=\"323\" height=\"274\" \/><\/p>\n<pre><\/pre>\n<h6>CAP\u00cdTULO 5: CONSEJOS Y TRUCOS PARA EL AUTOLLENADO EFICIENTE<\/h6>\n<pre><strong>Utilizando Autollenado en Series Alternas<\/strong><\/pre>\n<p>A veces, necesitar\u00e1s series alternas, como n\u00fameros pares o impares. Con el autollenado, esto es f\u00e1cil. Simplemente ingresa los dos primeros valores y arrastra para completar la serie.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13894\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/personalizaciond-e-numeros.png\" alt=\"\" width=\"420\" height=\"304\" \/><\/p>\n<pre><strong>Autollenado en M\u00faltiples Celdas<\/strong><\/pre>\n<p>Si deseas completar una serie en m\u00faltiples celdas, selecciona las celdas que deseas llenar y luego arrastra el cuadro de autollenado. Excel rellenar\u00e1 todas las celdas seleccionadas siguiendo el patr\u00f3n establecido.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-13897\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/rellenar-varias-celdas.png\" alt=\"\" width=\"393\" height=\"263\" \/><\/p>\n<h6>CONCLUSI\u00d3N: MAESTR\u00cdA EN AUTOLLENADO PARA LA EFICIENCIA EXCELENTE<\/h6>\n<p>Dominar la funci\u00f3n de autollenado en Excel es una habilidad esencial para cualquier persona que trabaje con datos, desde principiantes hasta profesionales experimentados. Te permite ahorrar tiempo valioso y reduce el riesgo de errores tediosos al completar series de n\u00fameros, fechas y texto. Con los conocimientos que has adquirido en esta gu\u00eda, est\u00e1s listo para utilizar el autollenado de manera efectiva y optimizar tu flujo de trabajo en Excel. <strong><span style=\"color: #0a6e42;\">\u00a1Empieza a practicar y experimentar con esta herramienta poderosa y ver\u00e1s c\u00f3mo aumenta tu productividad en un abrir y cerrar de ojos!<\/span><\/strong><\/p>\n<hr \/>\n<p><span style=\"color: #0a6e42;\"><strong>\u00bb<\/strong><\/span> Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a> <\/span>e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p><span style=\"color: #0a6e42;\"><strong>\u00bb<\/strong><\/span> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p><span style=\"color: #0a6e42;\"><strong>\u00bb<\/strong><\/span> Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; DOMINA EL AUTOLLENADO EN &#8230; <a title=\"AUTOLLENADO EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\" aria-label=\"Leer m\u00e1s sobre AUTOLLENADO EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":13891,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,346,486],"tags":[509,510],"class_list":["post-13890","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-basico","category-operaciones-basicas","tag-autocompletar","tag-autorellenar","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>AUTOLLENADO EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"Aprende c\u00f3mo usar el autollenado en Excel. Te permitir\u00e1 completar r\u00e1pidamente series de n\u00fameros, fechas y texto en una columna.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AUTOLLENADO EN EXCEL - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"Aprende c\u00f3mo usar el autollenado en Excel. Te permitir\u00e1 completar r\u00e1pidamente series de n\u00fameros, fechas y texto en una columna.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-29T15:02:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-29T15:07:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"AUTOLLENADO EN EXCEL\",\"datePublished\":\"2023-08-29T15:02:45+00:00\",\"dateModified\":\"2023-08-29T15:07:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\"},\"wordCount\":673,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png\",\"keywords\":[\"autocompletar\",\"autorellenar\"],\"articleSection\":[\"Excel\",\"Excel B\u00e1sico\",\"Operaciones B\u00e1sicas\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\",\"name\":\"AUTOLLENADO EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png\",\"datePublished\":\"2023-08-29T15:02:45+00:00\",\"dateModified\":\"2023-08-29T15:07:55+00:00\",\"description\":\"Aprende c\u00f3mo usar el autollenado en Excel. Te permitir\u00e1 completar r\u00e1pidamente series de n\u00fameros, fechas y texto en una columna.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"AUTOLLENADO EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"AUTOLLENADO EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AUTOLLENADO EN EXCEL - EXCELFULL.COM","description":"Aprende c\u00f3mo usar el autollenado en Excel. Te permitir\u00e1 completar r\u00e1pidamente series de n\u00fameros, fechas y texto en una columna.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"AUTOLLENADO EN EXCEL - EXCELFULL.COM","og_description":"Aprende c\u00f3mo usar el autollenado en Excel. Te permitir\u00e1 completar r\u00e1pidamente series de n\u00fameros, fechas y texto en una columna.","og_url":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-08-29T15:02:45+00:00","article_modified_time":"2023-08-29T15:07:55+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"AUTOLLENADO EN EXCEL","datePublished":"2023-08-29T15:02:45+00:00","dateModified":"2023-08-29T15:07:55+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/"},"wordCount":673,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png","keywords":["autocompletar","autorellenar"],"articleSection":["Excel","Excel B\u00e1sico","Operaciones B\u00e1sicas"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/","url":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/","name":"AUTOLLENADO EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png","datePublished":"2023-08-29T15:02:45+00:00","dateModified":"2023-08-29T15:07:55+00:00","description":"Aprende c\u00f3mo usar el autollenado en Excel. Te permitir\u00e1 completar r\u00e1pidamente series de n\u00fameros, fechas y texto en una columna.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/autollenado-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/08\/AUTOLLENADO-EN-EXCEL.png","width":1280,"height":720,"caption":"AUTOLLENADO EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/autollenado-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"AUTOLLENADO EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=13890"}],"version-history":[{"count":3,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13890\/revisions"}],"predecessor-version":[{"id":13899,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13890\/revisions\/13899"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/13891"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=13890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=13890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=13890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}