{"id":21576,"date":"2024-06-15T12:30:00","date_gmt":"2024-06-15T17:30:00","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=21576"},"modified":"2025-04-10T09:49:33","modified_gmt":"2025-04-10T14:49:33","slug":"listas-desplegables-en-excel-al-maximo","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/","title":{"rendered":"Listas desplegables dependientes"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-listas-desplegables-dependientes-en-excel-sin-macros-2-metodos-faciles-y-rapidos\"><strong>Listas Desplegables Dependientes en Excel SIN MACROS (2 M\u00e9todos F\u00e1ciles y R\u00e1pidos)<\/strong><\/h2>\n\n\n\n<p>Las listas desplegables dependientes en Excel son una herramienta poderosa que permite organizar y filtrar datos de manera eficiente. En este art\u00edculo, aprender\u00e1s dos m\u00e9todos para crear estas listas sin necesidad de usar macros, lo que garantiza compatibilidad con cualquier versi\u00f3n de Excel. Adem\u00e1s, te explicaremos c\u00f3mo optimizar tu trabajo con la funci\u00f3n INDIRECTO y la funci\u00f3n FILTRAR.<\/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=\"Listas Desplegables Dependientes en Excel SIN MACROS 2024 (2 M\u00e9todos F\u00e1ciles y R\u00e1pidos)\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/mOq5pxzLsqc?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<h2 class=\"wp-block-heading\" id=\"h-que-son-las-listas-desplegables-dependientes-en-excel\">\u00bfQu\u00e9 son las listas desplegables dependientes en Excel?<\/h2>\n\n\n\n<p>Las listas desplegables dependientes permiten seleccionar una opci\u00f3n en una celda y que, autom\u00e1ticamente, otra lista muestre solo los elementos relacionados con la selecci\u00f3n anterior. Este tipo de funcionalidad es ideal para cat\u00e1logos de productos, formularios de selecci\u00f3n y otras aplicaciones donde se requiera organizar datos de manera jer\u00e1rquica.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9todo 1: Crear listas desplegables dependientes con la funci\u00f3n INDIRECTO<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"e1e3e5\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"395\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-8-1024x395.avif\" alt=\" Hoja de c\u00e1lculo de Excel mostrando la funci\u00f3n INDIRECTO utilizada para crear listas desplegables dependientes, donde la selecci\u00f3n en la columna &quot;Categor\u00eda&quot; determina las opciones en la columna &quot;Subcategor\u00eda&quot;.\" class=\"wp-image-25081 has-transparency\" style=\"--dominant-color: #e1e3e5; width:879px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-8-1024x395.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-8-300x116.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-8-768x296.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-8-600x231.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-8-png.avif 1462w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>El primer m\u00e9todo es sencillo y compatible con todas las versiones de Excel. Se basa en la funci\u00f3n INDIRECTO para vincular los datos de una lista con otra, de modo que la segunda lista cambie dependiendo de la selecci\u00f3n realizada en la primera.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pasos para crear listas desplegables dependientes con INDIRECTO<\/h3>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Crear la lista principal<\/strong>: Selecciona los datos base y ve a <code>Datos > Validaci\u00f3n de Datos<\/code>. En el campo \u00abPermitir\u00bb, selecciona \u00abLista\u00bb y define el origen.<\/li>\n\n\n\n<li><strong>Definir nombres para los rangos de datos<\/strong>: Asigna nombres a los conjuntos de datos que formar\u00e1n las listas secundarias. Esto se hace en <code>F\u00f3rmulas > Administrador de nombres<\/code>.<\/li>\n\n\n\n<li><strong>Aplicar la funci\u00f3n INDIRECTO<\/strong>: En la segunda lista desplegable, usa la f\u00f3rmula <code>=INDIRECTO(A1)<\/code>, donde <code>A1<\/code> es la celda de la primera lista.<\/li>\n\n\n\n<li><strong>Probar la funcionalidad<\/strong>: Cambia los valores de la lista principal y verifica que la lista secundaria se actualiza correctamente.<\/li>\n<\/ol>\n\n\n\n<p>Este m\u00e9todo es efectivo, pero tiene la limitaci\u00f3n de que solo funciona con nombres de rangos, por lo que puede no ser el m\u00e1s din\u00e1mico.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9todo 2: Crear listas desplegables dependientes con la funci\u00f3n FILTRAR<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><img data-dominant-color=\"dde3ea\" data-has-transparency=\"true\" decoding=\"async\" width=\"1024\" height=\"290\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-9-1024x290.avif\" alt=\"Hoja de c\u00e1lculo de Excel mostrando la funci\u00f3n FILTRAR utilizada para crear listas desplegables dependientes, donde la selecci\u00f3n en la columna &quot;Categor\u00eda&quot; determina las opciones en la columna &quot;Producto&quot;.\" class=\"wp-image-25082 has-transparency\" style=\"--dominant-color: #dde3ea; width:891px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-9-1024x290.avif 1024w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-9-300x85.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-9-768x217.avif 768w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-9-1536x435.avif 1536w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-9-600x170.avif 600w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/image-9-png.avif 1799w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Ejemplo de la funci\u00f3n FILTRAR en Excel para generar listas desplegables que se actualizan seg\u00fan la selecci\u00f3n de la categor\u00eda.<\/figcaption><\/figure>\n\n\n\n<p>Si tienes Excel 2021 o Microsoft 365, puedes usar la funci\u00f3n FILTRAR para crear listas desplegables dependientes de manera m\u00e1s eficiente y din\u00e1mica.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Pasos para crear listas desplegables dependientes con FILTRAR<\/h3>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Crear una tabla con los datos<\/strong>: Convierte tu rango de datos en una tabla (<code>Ctrl + T<\/code>) y as\u00edgnale un nombre.<\/li>\n\n\n\n<li><strong>Configurar la lista principal<\/strong>: Usa la validaci\u00f3n de datos para crear una lista basada en la columna principal de la tabla.<\/li>\n\n\n\n<li><strong>Aplicar la funci\u00f3n FILTRAR<\/strong>: En una celda adyacente, usa la f\u00f3rmula <code>=FILTRAR(Tabla[Producto], Tabla[Categor\u00eda]=A1)<\/code>, donde <code>A1<\/code> es la celda de la lista principal.<\/li>\n\n\n\n<li><strong>Crear la lista desplegable dependiente<\/strong>: En la celda de la segunda lista, usa la validaci\u00f3n de datos con el rango din\u00e1mico generado por FILTRAR.<\/li>\n\n\n\n<li><strong>Ocultar la celda auxiliar<\/strong>: Para mejorar la apariencia, puedes ocultar la celda donde se aplica la funci\u00f3n FILTRAR.<\/li>\n<\/ol>\n\n\n\n<p>Este m\u00e9todo es m\u00e1s flexible y permite trabajar con datos din\u00e1micos, pero solo es compatible con versiones recientes de Excel.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Diferencias entre ambos m\u00e9todos<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><th>Caracter\u00edstica<\/th><th>INDIRECTO<\/th><th>FILTRAR<\/th><\/tr><tr><td>Compatibilidad<\/td><td>Todas las versiones<\/td><td>Excel 2021 y 365<\/td><\/tr><tr><td>Flexibilidad<\/td><td>Limitada<\/td><td>Alta<\/td><\/tr><tr><td>Facilidad de uso<\/td><td>F\u00e1cil<\/td><td>Requiere versi\u00f3n reciente<\/td><\/tr><tr><td>Rango din\u00e1mico<\/td><td>No<\/td><td>S\u00ed<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfC\u00f3mo actualizar Excel para usar FILTRAR?<\/h2>\n\n\n\n<p>Si deseas aprovechar el segundo m\u00e9todo y no tienes Excel 2021 o Microsoft 365, puedes actualizar tu versi\u00f3n. Una opci\u00f3n econ\u00f3mica es adquirir una licencia de Office 2021 a trav\u00e9s de <strong><a href=\"https:\/\/www.keysfan.com\/spring-sale-dh.html?ksf=jddh\" target=\"_blank\" rel=\"noreferrer noopener\">Keysfan<\/a><\/strong> con el cup\u00f3n <code>DH66<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Las listas desplegables dependientes en Excel son una excelente herramienta para organizar datos y mejorar la eficiencia en hojas de c\u00e1lculo. Con estos dos m\u00e9todos, puedes elegir la opci\u00f3n que mejor se adapte a tu versi\u00f3n de Excel y a tus necesidades. Si tienes dudas o quieres aprender m\u00e1s sobre listas de varios niveles, d\u00e9janos un comentario y estaremos encantados de explicarlo en un pr\u00f3ximo tutorial.<\/p>\n\n\n\n<p>\u00a1Domina Excel como un experto! \ud83d\ude80 Si quieres mejorar tus habilidades y sacarle el m\u00e1ximo provecho a esta poderosa herramienta, un <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos-gratis\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel<\/a><\/strong> es la mejor opci\u00f3n. \ud83d\udcca Aprender\u00e1s desde funciones b\u00e1sicas hasta herramientas avanzadas que te ayudar\u00e1n a optimizar tu trabajo y ahorrar tiempo. \u00a1No pierdas esta oportunidad! \ud83d\udd25<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Preguntas Frecuentes (FAQ)<\/h3>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-e986b933 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-f205b012 \" 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>\u00bfPuedo usar listas desplegables dependientes en versiones antiguas de Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes utilizar el m\u00e9todo con la funci\u00f3n INDIRECTO, que es compatible con todas las versiones de Excel.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-4e766cb6 \" 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 hacer si la lista desplegable dependiente no se actualiza autom\u00e1ticamente?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Aseg\u00farate de que los nombres de los rangos est\u00e9n bien definidos y que la referencia en la validaci\u00f3n de datos sea correcta. Si usas FILTRAR, verifica que est\u00e1s en una versi\u00f3n compatible de Excel.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-97c0a8ea \" 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>\u00bfPuedo crear m\u00e1s de dos niveles de listas dependientes?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes anidar m\u00e1s listas aplicando el mismo principio en cada nivel, usando INDIRECTO o FILTRAR seg\u00fan tu versi\u00f3n de Excel.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-3c457710 \" 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 ventajas tiene usar la funci\u00f3n FILTRAR en lugar de INDIRECTO?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>FILTRAR permite trabajar con datos din\u00e1micos sin necesidad de definir nombres de rango, lo que facilita la administraci\u00f3n de grandes vol\u00famenes de informaci\u00f3n.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-26aef368 \" 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>\u00bfC\u00f3mo oculto la celda auxiliar donde se aplica FILTRAR?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes seleccionar la celda, hacer clic derecho y elegir \u00abOcultar\u00bb. Tambi\u00e9n puedes cambiar el color de la fuente a blanco para que no sea visible en la hoja de c\u00e1lculo.<\/p><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Crea listas desplegables dependientes en Excel sin macros con dos m\u00e9todos f\u00e1ciles y r\u00e1pidos. Optimiza tu trabajo con estas t\u00e9cnicas.<\/p>\n","protected":false},"author":4,"featured_media":21577,"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":[2729,232,277,561,1989,365,486],"class_list":["post-21576","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-excel-tutorial","tag-facil","tag-gratis","tag-hojas-de-calculo","tag-microsoft-365","tag-office","tag-tutorial","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Listas desplegables dependientes - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a crear listas desplegables dependientes en Excel con m\u00e9todos eficientes. Descubre c\u00f3mo usar la funci\u00f3n FILTRAR e INDIRECTO.\" \/>\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\/listas-desplegables-en-excel-al-maximo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Listas desplegables dependientes en Excel f\u00e1ciles\" \/>\n<meta property=\"og:description\" content=\"Aprende a usar listas desplegables dependientes en Excel para organizar y filtrar tus datos con facilidad y compatibilidad.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-15T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-10T14:49:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"375\" \/>\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:title\" content=\"Listas desplegables dependientes en Excel f\u00e1ciles\" \/>\n<meta name=\"twitter:description\" content=\"Aprende a usar listas desplegables dependientes en Excel sin macros y optimiza tu flujo de trabajo con funciones \u00fatiles.\" \/>\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=\"4 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\\\/listas-desplegables-en-excel-al-maximo\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/95509baa94d6c69583eddaece41011cc\"},\"headline\":\"Listas desplegables dependientes\",\"datePublished\":\"2024-06-15T17:30:00+00:00\",\"dateModified\":\"2025-04-10T14:49:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/\"},\"wordCount\":739,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#\\\/schema\\\/person\\\/6bc1fbb1a73635ac2e186182146d04e9\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/Listas-Desplegables-Dependientes-miniatura-02.jpg\",\"keywords\":[\"Excel tutorial\",\"Facil\",\"Gratis\",\"Hojas de c\u00e1lculo\",\"Microsoft 365\",\"office\",\"Tutorial\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/\",\"name\":\"Listas desplegables dependientes - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/Listas-Desplegables-Dependientes-miniatura-02.jpg\",\"datePublished\":\"2024-06-15T17:30:00+00:00\",\"dateModified\":\"2025-04-10T14:49:33+00:00\",\"description\":\"Aprende a crear listas desplegables dependientes en Excel con m\u00e9todos eficientes. Descubre c\u00f3mo usar la funci\u00f3n FILTRAR e INDIRECTO.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/#primaryimage\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/Listas-Desplegables-Dependientes-miniatura-02.jpg\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/uploads\\\/2024\\\/06\\\/Listas-Desplegables-Dependientes-miniatura-02.jpg\",\"width\":500,\"height\":375,\"caption\":\"Listas Desplegables Dependientes\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/tutoriales-gratis-online\\\/tutoriales-excel\\\/listas-desplegables-en-excel-al-maximo\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Listas desplegables dependientes\"}]},{\"@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=1780927217\",\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"contentUrl\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/wp-content\\\/litespeed\\\/avatar\\\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\\\/\\\/dostinhurtado.com\\\/site\\\/author\\\/moderador\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Listas desplegables dependientes - Dostin Hurtado","description":"Aprende a crear listas desplegables dependientes en Excel con m\u00e9todos eficientes. Descubre c\u00f3mo usar la funci\u00f3n FILTRAR e INDIRECTO.","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\/listas-desplegables-en-excel-al-maximo\/","og_locale":"es_ES","og_type":"article","og_title":"Listas desplegables dependientes en Excel f\u00e1ciles","og_description":"Aprende a usar listas desplegables dependientes en Excel para organizar y filtrar tus datos con facilidad y compatibilidad.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/","og_site_name":"Dostin Hurtado","article_published_time":"2024-06-15T17:30:00+00:00","article_modified_time":"2025-04-10T14:49:33+00:00","og_image":[{"width":500,"height":375,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_title":"Listas desplegables dependientes en Excel f\u00e1ciles","twitter_description":"Aprende a usar listas desplegables dependientes en Excel sin macros y optimiza tu flujo de trabajo con funciones \u00fatiles.","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/95509baa94d6c69583eddaece41011cc"},"headline":"Listas desplegables dependientes","datePublished":"2024-06-15T17:30:00+00:00","dateModified":"2025-04-10T14:49:33+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/"},"wordCount":739,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/6bc1fbb1a73635ac2e186182146d04e9"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg","keywords":["Excel tutorial","Facil","Gratis","Hojas de c\u00e1lculo","Microsoft 365","office","Tutorial"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/","name":"Listas desplegables dependientes - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg","datePublished":"2024-06-15T17:30:00+00:00","dateModified":"2025-04-10T14:49:33+00:00","description":"Aprende a crear listas desplegables dependientes en Excel con m\u00e9todos eficientes. Descubre c\u00f3mo usar la funci\u00f3n FILTRAR e INDIRECTO.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg","width":500,"height":375,"caption":"Listas Desplegables Dependientes"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-en-excel-al-maximo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Listas desplegables dependientes"}]},{"@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=1780927217","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1780927217","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02-300x225.jpg",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02-400x375.jpg",400,375,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02.jpg",500,375,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2024\/06\/Listas-Desplegables-Dependientes-miniatura-02-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Dostin Hurtado","author_link":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"},"uagb_comment_info":0,"uagb_excerpt":"Crea listas desplegables dependientes en Excel sin macros con dos m\u00e9todos f\u00e1ciles y r\u00e1pidos. Optimiza tu trabajo con estas t\u00e9cnicas.","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/21576","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=21576"}],"version-history":[{"count":5,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/21576\/revisions"}],"predecessor-version":[{"id":25086,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/21576\/revisions\/25086"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/21577"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=21576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=21576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=21576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}