{"id":5417,"date":"2019-01-15T09:00:43","date_gmt":"2019-01-15T14:00:43","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=5417"},"modified":"2025-04-10T13:44:19","modified_gmt":"2025-04-10T18:44:19","slug":"relleno-rapido-fast-filling-en-excel","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/","title":{"rendered":"Relleno r\u00e1pido (flash fill) en Excel"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\" id=\"h-aprende-a-usar-relleno-rapido-flash-fill-en-excel-y-ahorra-tiempo\">Aprende a Usar Relleno R\u00e1pido (Flash Fill) en Excel y Ahorra Tiempo<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">\u00bfCansado de llenar manualmente los datos en Excel? Descubre c\u00f3mo el relleno r\u00e1pido (flash fill) en Excel puede revolucionar tu flujo de trabajo. Esta potente herramienta te permite llenar datos autom\u00e1ticamente identificando patrones en tus entradas, ahorr\u00e1ndote valiosos minutos y evitando errores. Sigue leyendo para aprender c\u00f3mo utilizar esta funci\u00f3n y optimizar tu trabajo con hojas de c\u00e1lculo.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"Usos del Relleno Autom\u00e1tico, Lleno R\u00e1pido o flash fill en Excel - Dostin Hurtado\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/8YU8vnskiNQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\" style=\"padding-top:var(--wp--preset--spacing--20);padding-bottom:var(--wp--preset--spacing--20)\">\n<h2 class=\"wp-block-heading has-text-align-center\" id=\"h-descargar-material-de-apoyo\">Descargar Material de Apoyo<\/h2>\n\n\n\n<p class=\"has-text-align-left wp-block-paragraph\">\u00bfListo para poner en pr\u00e1ctica el tutorial? Descarga el \u00abmaterial de apoyo\u00bb y trabaja con el mismo archivo que usamos en el video.<\/p>\n\n\n\n<div class=\"wp-block-ultimate-post-button-group ultp-block-99b8b4\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-b0171b ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/material_de_apoyo\/tutoriales_excel\/relleno_rapido.zip\" target=\"_self\" rel=\"noopener\" download><div class=\"ultp-btnIcon-wrap\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 48 41.6\"><g><path d=\"M30.777 0a17.252 17.252 0 0 0-15.969 10.734 12.026 12.026 0 1 0-5.2 23.479 2.084 2.084 0 0 0 .413.042 2.051 2.051 0 0 0 .409-4.06 7.924 7.924 0 0 1 1.6-15.686 7.84 7.84 0 0 1 3.231.691l2.2.986.617-2.333a13.132 13.132 0 0 1 25.821 3.372 12.993 12.993 0 0 1-4.169 9.6 2.052 2.052 0 0 0 2.8 3A17.229 17.229 0 0 0 30.779.002\"><\/path><path d=\"M34.188 29.466h-5.18V15.578a1.164 1.164 0 0 0-1.164-1.164h-3.94a1.164 1.164 0 0 0-1.164 1.164v13.888h-5.18a1.164 1.164 0 0 0-.888 1.917l8.314 9.8a1.164 1.164 0 0 0 1.775 0l8.315-9.8a1.164 1.164 0 0 0-.888-1.917\"><\/path><\/g><\/svg><\/div><div class=\"ultp-button-text\">DESCARGAR<\/div><\/a>\n<\/div><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-que-es-el-relleno-rapido-flash-fill-en-excel\">\u00bfQu\u00e9 es el Relleno R\u00e1pido (Flash Fill) en Excel?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">El relleno r\u00e1pido, disponible en Excel desde la versi\u00f3n 2013, es una funcionalidad inteligente que reconoce patrones en los datos que introduces. En lugar de usar f\u00f3rmulas complejas, simplemente comienzas a escribir el dato deseado en una columna adyacente, y Excel autom\u00e1ticamente completa el resto bas\u00e1ndose en el patr\u00f3n que detecta. \u00a1Es as\u00ed de sencillo!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-como-extraer-nombres-y-apellidos-con-flash-fill\">C\u00f3mo Extraer Nombres y Apellidos con Flash Fill<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Una de las aplicaciones m\u00e1s \u00fatiles del relleno r\u00e1pido es la extracci\u00f3n de nombres y apellidos de una columna de nombres completos.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-relleno-rapido-flash-fill-en-excel-extraer-el-nombre\">Relleno r\u00e1pido (flash fill) en Excel: Extraer el Nombre:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"f0f1f1\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"986\" height=\"617\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-png.avif\" alt=\" Captura de pantalla de Excel mostrando el uso de &quot;Relleno r\u00e1pido&quot; (Flash Fill) para extraer nombres de una columna de &quot;Nombre y Apellido&quot;.\" class=\"wp-image-25279 has-transparency\" style=\"--dominant-color: #f0f1f1; width:433px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-png.avif 986w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-300x188.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-768x481.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-600x375.avif 600w\" sizes=\"(max-width: 986px) 100vw, 986px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En la columna junto a tus nombres completos, escribe el primer nombre de la primera entrada.<\/li>\n\n\n\n<li>Presiona Enter.<\/li>\n\n\n\n<li>Comienza a escribir el primer nombre de la segunda entrada. \u00a1Excel deber\u00eda reconocer el patr\u00f3n y autocompletar el resto de la columna!<\/li>\n\n\n\n<li>Si no se autocompleta, ve a la pesta\u00f1a \u00abDatos\u00bb y haz clic en \u00abRelleno r\u00e1pido\u00bb o usa el atajo de teclado Ctrl + E.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-relleno-rapido-flash-fill-en-excel-extraer-el-apellido\">Relleno r\u00e1pido (flash fill) en Excel: Extraer el Apellido:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"f5f6f6\" data-has-transparency=\"true\" decoding=\"async\" width=\"260\" height=\"607\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-1-png.avif\" alt=\"Captura de pantalla de Excel mostrando el uso de &quot;Relleno r\u00e1pido&quot; (Flash Fill) para extraer apellidos de una columna de &quot;Nombre y Apellido&quot;.\" class=\"wp-image-25280 has-transparency\" style=\"--dominant-color: #f5f6f6; width:158px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-1-png.avif 260w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-1-129x300.avif 129w\" sizes=\"(max-width: 260px) 100vw, 260px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>De manera similar, en otra columna adyacente, escribe el apellido de la primera entrada.<\/li>\n\n\n\n<li>Presiona Enter.<\/li>\n\n\n\n<li>Comienza a escribir el apellido de la segunda entrada. Excel deber\u00eda reconocer el patr\u00f3n y completar los dem\u00e1s apellidos.<\/li>\n\n\n\n<li>Si es necesario, utiliza la opci\u00f3n \u00abRelleno r\u00e1pido\u00bb en la pesta\u00f1a \u00abDatos\u00bb o el atajo Ctrl + E.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-combinar-y-reorganizar-nombres-facilmente\">Combinar y Reorganizar Nombres F\u00e1cilmente<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">El relleno r\u00e1pido no solo extrae informaci\u00f3n, sino que tambi\u00e9n te permite combinar y reorganizar datos de manera intuitiva.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-relleno-rapido-flash-fill-en-excel-combinar-apellido-e-inicial-del-nombre\">Relleno r\u00e1pido (flash fill) en Excel: Combinar Apellido e Inicial del Nombre:<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"f4f5f5\" data-has-transparency=\"true\" decoding=\"async\" width=\"271\" height=\"607\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-2-png.avif\" alt=\"Captura de pantalla de Excel mostrando el uso de &quot;Relleno r\u00e1pido&quot; (Flash Fill) para combinar el apellido con la inicial del nombre de una columna de &quot;Nombre y Apellido&quot;.\" class=\"wp-image-25281 has-transparency\" style=\"--dominant-color: #f4f5f5; width:138px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-2-png.avif 271w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-2-134x300.avif 134w\" sizes=\"(max-width: 271px) 100vw, 271px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En una nueva columna, escribe el apellido seguido de la inicial del primer nombre (ej., \u00abApellido, N\u00bb).<\/li>\n\n\n\n<li>Presiona Enter y comienza a escribir el siguiente. Excel identificar\u00e1 el patr\u00f3n y lo aplicar\u00e1 al resto de las filas.<\/li>\n\n\n\n<li>Reorganizar el Orden de los Nombres:<\/li>\n\n\n\n<li>Si tienes nombres en un formato (ej., Nombre, Inicial del Segundo Nombre, Apellido) y deseas otro (ej., Apellido, Nombre, Inicial del Segundo Nombre), simplemente escribe el primer resultado deseado en una columna nueva.<\/li>\n\n\n\n<li>Al comenzar la segunda fila, Excel deber\u00eda ofrecer la autocompletaci\u00f3n basada en el nuevo orden.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-trabajando-con-fechas-y-numeros\">Trabajando con Fechas y N\u00fameros<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"f2f2f2\" data-has-transparency=\"true\" style=\"--dominant-color: #f2f2f2;\" loading=\"lazy\" decoding=\"async\" width=\"206\" height=\"327\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-3-png.avif\" alt=\"Men\u00fa desplegable de &quot;Rellenar&quot; en Excel, con la opci\u00f3n &quot;Relleno r\u00e1pido&quot; resaltada.\" class=\"wp-image-25282 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-3-png.avif 206w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-3-189x300.avif 189w\" sizes=\"(max-width: 206px) 100vw, 206px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">El relleno r\u00e1pido tambi\u00e9n es eficaz para manipular fechas y n\u00fameros, aunque con algunas consideraciones.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Separar D\u00eda, Mes y A\u00f1o:\n<ol class=\"wp-block-list\">\n<li>Si tienes una columna con fechas completas, puedes separarlas en columnas individuales para el d\u00eda, el mes y el a\u00f1o utilizando el mismo principio de escribir el resultado deseado en la primera fila y dejar que Excel reconozca el patr\u00f3n.<\/li>\n<\/ol>\n<\/li>\n\n\n\n<li>Formatear N\u00fameros:\n<ol class=\"wp-block-list\">\n<li>Para formatear n\u00fameros, como n\u00fameros de tel\u00e9fono, introduce el formato deseado en la primera celda adyacente (ej., (XXX) XXX-XXXX).<\/li>\n\n\n\n<li>Excel intentar\u00e1 replicar ese formato en las celdas restantes. Es importante revisar los resultados, especialmente con n\u00fameros, ya que Excel podr\u00eda no siempre reconocer el patr\u00f3n autom\u00e1ticamente y podr\u00eda requerir el uso expl\u00edcito de la opci\u00f3n \u00abRelleno r\u00e1pido\u00bb.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-formatear-numeros-de-telefono-con-relleno-rapido\">Formatear N\u00fameros de Tel\u00e9fono con Relleno R\u00e1pido<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"e6e8e8\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"284\" height=\"474\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-4-png.avif\" alt=\"Captura de pantalla de Excel mostrando una columna de n\u00fameros de tel\u00e9fono con indicativo, donde se ha empezado a aplicar un formato personalizado utilizando &quot;Relleno r\u00e1pido&quot; (Flash Fill).\" class=\"wp-image-25283 has-transparency\" style=\"--dominant-color: #e6e8e8; width:211px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-4-png.avif 284w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-4-180x300.avif 180w\" sizes=\"(max-width: 284px) 100vw, 284px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Formatear n\u00fameros de tel\u00e9fono puede ser tedioso si se hace manualmente. Con flash fill, puedes hacerlo r\u00e1pidamente:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>En la columna junto a tus n\u00fameros de tel\u00e9fono sin formato, escribe el n\u00famero en el formato deseado (ej., (123) 456-7890).<\/li>\n\n\n\n<li>Presiona Enter y comienza a escribir el siguiente n\u00famero. Excel deber\u00eda aplicar el mismo formato al resto de la columna.<\/li>\n\n\n\n<li>Si no sucede autom\u00e1ticamente, utiliza la funci\u00f3n \u00abRelleno r\u00e1pido\u00bb (Ctrl + E).<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-la-importancia-de-verificar-los-resultados\">La Importancia de Verificar los Resultados<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"d4d7d5\" data-has-transparency=\"true\" style=\"--dominant-color: #d4d7d5;\" loading=\"lazy\" decoding=\"async\" width=\"585\" height=\"79\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-5.png\" alt=\"Captura de pantalla de Excel mostrando una columna con n\u00fameros de tel\u00e9fono originales y otra columna donde se ha aplicado &quot;Relleno r\u00e1pido&quot; (Flash Fill), destacando la necesidad de verificar los resultados.\" class=\"wp-image-25284 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-5.png 585w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/image-5-300x41.avif 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Aunque el relleno r\u00e1pido es una herramienta poderosa, es crucial verificar siempre los resultados. Excel se basa en el patr\u00f3n que le proporcionas, y si el patr\u00f3n inicial no es claro o consistente en tus datos, podr\u00eda haber errores en el autocompletado. Dedica unos segundos a revisar la columna generada para asegurarte de que todo sea correcto.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u00a1Activa tu Windows y Office al Mejor Precio con Keysfan!<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a1Atenci\u00f3n! Si est\u00e1s buscando licencias originales de Windows y Office a precios s\u00faper bajos, <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\">Ke<\/a><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">y<\/a><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\">sfan<\/a><\/strong> es la mejor opci\u00f3n. No solo ofrecen productos 100% genuinos y entregas r\u00e1pidas, sino que adem\u00e1s puedes ahorrar a\u00fan m\u00e1s utilizando el c\u00f3digo de descuento <strong>DH66<\/strong> al momento de tu compra. No te pierdas esta oportunidad de equipar tu PC de forma segura y econ\u00f3mica.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusi\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">El relleno r\u00e1pido (flash fill) es una herramienta incre\u00edblemente \u00fatil en Excel que puede ahorrarte una cantidad significativa de tiempo y esfuerzo al llenar y manipular datos. Desde extraer nombres hasta formatear n\u00fameros, esta funci\u00f3n inteligente simplifica muchas tareas comunes en hojas de c\u00e1lculo. \u00a1Pru\u00e9balo y descubre c\u00f3mo puede mejorar tu productividad en Excel!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si Excel te suena a chino, este <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel<\/a><\/strong> te va a encantar \ud83d\ude05\ud83d\udcbb. Te explican todo s\u00faper claro, desde cero y paso a paso. Aprender\u00e1s f\u00f3rmulas, gr\u00e1ficos, automatizaci\u00f3n y hasta trucos para trabajar m\u00e1s r\u00e1pido. \u00a1Haz que Excel trabaje para ti! \u2728\ud83d\udcc8<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preguntas-frecuenes-faq\">Preguntas Frecuenes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-a9a3aa30 uagb-faq-icon-row uagb-faq-layout-accordion uagb-faq-expand-first-true uagb-faq-inactive-other-true uagb-faq__wrap uagb-buttons-layout-wrap uagb-faq-equal-height     \" data-faqtoggle=\"true\" role=\"tablist\"><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-cb911097 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 versiones de Excel tienen la funci\u00f3n de Relleno r\u00e1pido (Flash Fill)?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>La funci\u00f3n de Relleno r\u00e1pido (Flash Fill) est\u00e1 disponible en Excel desde la versi\u00f3n 2013 en adelante.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-b90442ef \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfEl Relleno r\u00e1pido funciona solo con nombres?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>No, el Relleno r\u00e1pido puede funcionar con varios tipos de datos, incluyendo nombres, fechas, n\u00fameros y otros formatos de texto, siempre y cuando Excel pueda identificar un patr\u00f3n.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-3a9cf1c4 \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfQu\u00e9 pasa si el Relleno r\u00e1pido no completa autom\u00e1ticamente los datos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Si Excel no reconoce el patr\u00f3n autom\u00e1ticamente, puedes seleccionar la columna donde deseas aplicar el relleno r\u00e1pido, ir a la pesta\u00f1a \u00abDatos\u00bb y hacer clic en la opci\u00f3n \u00abRelleno r\u00e1pido\u00bb o usar el atajo de teclado Ctrl + E.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-c3e42adc \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfEs necesario usar f\u00f3rmulas para que funcione el Relleno r\u00e1pido?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>No, una de las grandes ventajas del Relleno r\u00e1pido es que no requiere el uso de f\u00f3rmulas o funciones. Simplemente se basa en el patr\u00f3n que le proporcionas al escribir los primeros resultados.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-f2e2368a \" role=\"tab\" tabindex=\"0\"><div class=\"uagb-faq-questions-button uagb-faq-questions\">\t\t\t<span class=\"uagb-icon uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M432 256c0 17.69-14.33 32.01-32 32.01H256v144c0 17.69-14.33 31.99-32 31.99s-32-14.3-32-31.99v-144H48c-17.67 0-32-14.32-32-32.01s14.33-31.99 32-31.99H192v-144c0-17.69 14.33-32.01 32-32.01s32 14.32 32 32.01v144h144C417.7 224 432 238.3 432 256z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span class=\"uagb-icon-active uagb-faq-icon-wrap\">\n\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 448 512\"><path d=\"M400 288h-352c-17.69 0-32-14.32-32-32.01s14.31-31.99 32-31.99h352c17.69 0 32 14.3 32 31.99S417.7 288 400 288z\"><\/path><\/svg>\n\t\t\t\t\t\t\t<\/span>\n\t\t\t<span class=\"uagb-question\"><strong>\u00bfDebo revisar los resultados del Relleno r\u00e1pido?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, es muy importante revisar siempre los resultados generados por el Relleno r\u00e1pido para asegurarse de que el patr\u00f3n se haya aplicado correctamente a todos los datos, ya que se basa en el patr\u00f3n inicial que le proporcionas.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Descubre c\u00f3mo el relleno r\u00e1pido (flash fill) en Excel puede optimizar tu flujo de trabajo y ahorrarte tiempo.<\/p>\n","protected":false},"author":4,"featured_media":5427,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"video","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[52],"tags":[562,225,539,486],"class_list":["post-5417","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-curso","tag-excel","tag-gratuito","tag-tutorial","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Relleno r\u00e1pido (flash fill) en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Divide, une o dale formato a textos, palabras y fechas en segundos con la herramienta relleno rapido (flash fill) de excel, tutorial basico.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Relleno r\u00e1pido (flash fill) en Excel - Dostin Hurtado\" \/>\n<meta property=\"og:description\" content=\"Divide, une o dale formato a textos, palabras y fechas en segundos con la herramienta relleno rapido (flash fill) de excel, tutorial basico.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-15T14:00:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-10T18:44:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"418\" \/>\n\t<meta property=\"og:image:height\" content=\"316\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Dostin Hurtado\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dostin Hurtado\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Relleno r\u00e1pido (flash fill) en Excel\",\"datePublished\":\"2019-01-15T14:00:43+00:00\",\"dateModified\":\"2025-04-10T18:44:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/\"},\"wordCount\":1000,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/relleno_rapido_peque-1.jpg\",\"keywords\":[\"Curso\",\"Excel\",\"Gratuito\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/\",\"name\":\"Relleno r\u00e1pido (flash fill) en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/relleno_rapido_peque-1.jpg\",\"datePublished\":\"2019-01-15T14:00:43+00:00\",\"dateModified\":\"2025-04-10T18:44:19+00:00\",\"description\":\"Divide, une o dale formato a textos, palabras y fechas en segundos con la herramienta relleno rapido (flash fill) de excel, tutorial basico.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/relleno_rapido_peque-1.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/relleno_rapido_peque-1.jpg\",\"width\":418,\"height\":316,\"caption\":\"Relleno r\u00e1pido o fast filling en excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/relleno-rapido-fast-filling-en-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Relleno r\u00e1pido (flash fill) en Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\",\"name\":\"Dostin Hurtado\",\"description\":\"\u00a1El Conocimiento Es para Todos! - Cursos Gratis\",\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\",\"name\":\"Dostin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\",\"width\":65,\"height\":14,\"caption\":\"Dostin\"},\"logo\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/10\\\/Logo_Retina_Barras.svg\"},\"sameAs\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Relleno r\u00e1pido (flash fill) en Excel - Dostin Hurtado","description":"Divide, une o dale formato a textos, palabras y fechas en segundos con la herramienta relleno rapido (flash fill) de excel, tutorial basico.","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:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Relleno r\u00e1pido (flash fill) en Excel - Dostin Hurtado","og_description":"Divide, une o dale formato a textos, palabras y fechas en segundos con la herramienta relleno rapido (flash fill) de excel, tutorial basico.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/","og_site_name":"Dostin Hurtado","article_published_time":"2019-01-15T14:00:43+00:00","article_modified_time":"2025-04-10T18:44:19+00:00","og_image":[{"width":418,"height":316,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Relleno r\u00e1pido (flash fill) en Excel","datePublished":"2019-01-15T14:00:43+00:00","dateModified":"2025-04-10T18:44:19+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/"},"wordCount":1000,"commentCount":4,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg","keywords":["Curso","Excel","Gratuito","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/","name":"Relleno r\u00e1pido (flash fill) en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg","datePublished":"2019-01-15T14:00:43+00:00","dateModified":"2025-04-10T18:44:19+00:00","description":"Divide, une o dale formato a textos, palabras y fechas en segundos con la herramienta relleno rapido (flash fill) de excel, tutorial basico.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg","width":418,"height":316,"caption":"Relleno r\u00e1pido o fast filling en excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/relleno-rapido-fast-filling-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Relleno r\u00e1pido (flash fill) en Excel"}]},{"@type":"WebSite","@id":"https:\/\/dostinhurtado.com\/site\/#website","url":"https:\/\/dostinhurtado.com\/site\/","name":"Dostin Hurtado","description":"\u00a1El Conocimiento Es para Todos! - Cursos Gratis","publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dostinhurtado.com\/site\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9","name":"Dostin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg","width":65,"height":14,"caption":"Dostin"},"logo":{"@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/10\/Logo_Retina_Barras.svg"},"sameAs":["https:\/\/dostinhurtado.com\/site"]},{"@type":"Person","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1783951342","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1-300x227.jpg",300,227,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1-400x316.jpg",400,316,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1.jpg",418,316,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2019\/01\/relleno_rapido_peque-1-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":4,"uagb_excerpt":"Descubre c\u00f3mo el relleno r\u00e1pido (flash fill) en Excel puede optimizar tu flujo de trabajo y ahorrarte tiempo.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/5417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/comments?post=5417"}],"version-history":[{"count":5,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/5417\/revisions"}],"predecessor-version":[{"id":25319,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/5417\/revisions\/25319"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/5427"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=5417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=5417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=5417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}