{"id":19787,"date":"2023-03-09T14:54:28","date_gmt":"2023-03-09T19:54:28","guid":{"rendered":"https:\/\/dostinhurtado.com\/site\/?p=19787"},"modified":"2025-04-09T11:58:53","modified_gmt":"2025-04-09T16:58:53","slug":"listas-desplegables-cuadros-combinados-y-combobox","status":"publish","type":"post","link":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/","title":{"rendered":"Listas desplegables en Excel"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" id=\"h-como-insertar-y-usar-listas-desplegables-cuadros-combinados-y-combobox-en-excel\">C\u00f3mo Insertar y Usar Listas Desplegables, Cuadros Combinados y ComboBox en Excel<\/h2>\n\n\n\n<p>\u00bfTe has preguntado c\u00f3mo optimizar tus hojas de c\u00e1lculo en Excel usando listas desplegables? En este tutorial, te ense\u00f1ar\u00e9 paso a paso c\u00f3mo crear&nbsp;<strong>listas desplegables, cuadros combinados y ComboBox<\/strong>&nbsp;en Excel, con ejemplos pr\u00e1cticos que te ayudar\u00e1n a simplificar tu trabajo diario. Aprender\u00e1s a usar estas herramientas para mejorar la eficiencia de tus proyectos, ya sea en el \u00e1mbito laboral o acad\u00e9mico. \u00a1Vamos a ello!<\/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=\"Como Insertar y Usar Listas Desplegables, Cuadros Combinados y ComboBox F\u00e1cil + Ejemplos de uso\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/-5JNJdHwkFw?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\">\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-bed099\"><div class=\"ultp-button-wrapper ultp-button-frontend ultp-anim-none\">\n<a class=\"wp-block-ultimate-post-button ultp-block-0eb6a7 ultp-button-layout1\" href=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/Ejemplo_Terminado.xlsx\" 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-por-que-utilizar-listas-desplegables-en-excel-beneficios-clave\">\u00bfPor Qu\u00e9 Utilizar Listas Desplegables en Excel? Beneficios Clave<\/h2>\n\n\n\n<p>Las <strong>listas desplegables en Excel<\/strong> son herramientas poderosas que ofrecen m\u00faltiples ventajas para la gesti\u00f3n de datos:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 <strong>Interfaz Intuitiva:<\/strong> Mejora la experiencia del usuario al ofrecer opciones claras y sencillas de seleccionar.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 <strong>Mayor Precisi\u00f3n de Datos:<\/strong> Evita errores de escritura al permitir seleccionar opciones predefinidas.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 <strong>Ahorro de Tiempo:<\/strong> Agiliza la entrada de datos al no tener que escribir la misma informaci\u00f3n repetidamente.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2705 <strong>Organizaci\u00f3n y Claridad:<\/strong> Facilita la lectura y el an\u00e1lisis de la informaci\u00f3n al estandarizar las entradas.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">C\u00f3mo Crear Listas Desplegables en Excel<\/h2>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"f1f1f2\" data-has-transparency=\"true\" fetchpriority=\"high\" decoding=\"async\" width=\"592\" height=\"409\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-7-png.avif\" alt=\"\" class=\"wp-image-24441 has-transparency\" style=\"--dominant-color: #f1f1f2; width:407px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-7-png.avif 592w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-7-300x207.avif 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/figure>\n\n\n\n<p>Las listas desplegables permiten seleccionar datos predefinidos dentro de una celda. Sigue estos pasos para crear una:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Selecciona la celda<\/strong> donde deseas la lista desplegable.}<\/li>\n\n\n\n<li><strong>Ve a la pesta\u00f1a \u00abDatos\u00bb<\/strong> y haz clic en \u00abValidaci\u00f3n de datos\u00bb.<\/li>\n\n\n\n<li>En la pesta\u00f1a \u00abConfiguraci\u00f3n\u00bb, en \u00abPermitir\u00bb, selecciona \u00abLista\u00bb.<\/li>\n\n\n\n<li>En el campo \u00abOrigen\u00bb, selecciona el rango de datos que deseas mostrar en la lista.<\/li>\n\n\n\n<li>Haz clic en \u00abAceptar\u00bb y listo. Ahora podr\u00e1s elegir los valores desde la lista desplegable.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Caracter\u00edsticas de las Listas Desplegables en Excel<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"d3dce9\" data-has-transparency=\"true\" style=\"--dominant-color: #d3dce9;\" decoding=\"async\" width=\"647\" height=\"109\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-8-png.avif\" alt=\"\" class=\"wp-image-24442 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-8-png.avif 647w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-8-300x51.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-8-600x101.avif 600w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Los valores seleccionados aparecen de forma literal en la celda.<\/li>\n\n\n\n<li>No se pueden eliminar presionando la tecla \u00abSuprimir\u00bb.<\/li>\n\n\n\n<li>Se puede combinar con funciones como <strong>BUSCARV<\/strong> para recuperar informaci\u00f3n relacionada.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Cuadro Combinado (Formulario) en Excel<\/h2>\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;\" decoding=\"async\" width=\"620\" height=\"54\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-9-png.avif\" alt=\"\" class=\"wp-image-24443 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-9-png.avif 620w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-9-300x26.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-9-600x52.avif 600w\" sizes=\"(max-width: 620px) 100vw, 620px\" \/><\/figure>\n\n\n\n<p>El <strong>cuadro combinado<\/strong> es un control que permite seleccionar un valor de una lista; sin embargo, en lugar de devolver directamente el valor elegido, devuelve su posici\u00f3n dentro de la lista. Para insertarlo:<\/p>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Habilita la pesta\u00f1a \u00abProgramador\u00bb<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Haz clic derecho en la cinta de opciones.<\/li>\n\n\n\n<li>Selecciona \u00abPersonalizar cinta de opciones\u00bb y activa \u00abProgramador\u00bb.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Ve a \u00abProgramador\u00bb &gt; \u00abInsertar\u00bb &gt; \u00abCuadro combinado\u00bb (Control de formulario).<\/strong><\/li>\n\n\n\n<li><strong>Dibuja el cuadro combinado<\/strong> en la hoja de Excel.<\/li>\n\n\n\n<li><strong>Haz clic derecho sobre \u00e9l<\/strong> y selecciona \u00abFormato de control\u00bb. <\/li>\n\n\n\n<li><strong>En \u00abRango de entrada\u00bb<\/strong>, selecciona los datos de la lista.<\/li>\n\n\n\n<li><strong>En \u00abVincular con la celda\u00bb<\/strong>, elige una celda donde se mostrar\u00e1 la posici\u00f3n del dato seleccionado.<\/li>\n\n\n\n<li>Haz clic en \u00abAceptar\u00bb.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"f5f5f5\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"627\" height=\"537\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-10-png.avif\" alt=\"\" class=\"wp-image-24444 has-transparency\" style=\"--dominant-color: #f5f5f5; width:417px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-10-png.avif 627w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-10-300x257.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-10-600x514.avif 600w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">C\u00f3mo Extraer Datos con la Funci\u00f3n INDICE<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img data-dominant-color=\"eceae9\" data-has-transparency=\"true\" style=\"--dominant-color: #eceae9;\" loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"54\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-11-png.avif\" alt=\"\" class=\"wp-image-24445 has-transparency\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-11-png.avif 654w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-11-300x25.avif 300w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-11-600x50.avif 600w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/figure>\n\n\n\n<p>Dado que el cuadro combinado devuelve la posici\u00f3n del elemento, puedes usar la funci\u00f3n <strong>INDICE<\/strong> para obtener el valor real:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=INDICE(A2:A10, C2)<\/code><\/pre>\n\n\n\n<p>Donde:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A2<\/strong><strong>:A10<\/strong> es el rango de datos.<\/li>\n\n\n\n<li><strong>C2<\/strong> es la celda vinculada con el cuadro combinado.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Listas Desplegables en Excel con ComboBox (Control ActiveX)<\/h2>\n\n\n\n<p>El ComboBox de ActiveX es una versi\u00f3n m\u00e1s avanzada del cuadro combinado y permite mayor personalizaci\u00f3n mediante macros.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">C\u00f3mo Insertar un ComboBox<\/h3>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img data-dominant-color=\"dedbdb\" data-has-transparency=\"true\" loading=\"lazy\" decoding=\"async\" width=\"187\" height=\"612\" src=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-12-png.avif\" alt=\"\" class=\"wp-image-24446 has-transparency\" style=\"--dominant-color: #dedbdb; width:147px;height:auto\" srcset=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-12-png.avif 187w, https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/image-12-92x300.avif 92w\" sizes=\"(max-width: 187px) 100vw, 187px\" \/><\/figure>\n\n\n\n<ol start=\"1\" class=\"wp-block-list\">\n<li><strong>Ve a \u00abProgramador\u00bb &gt; \u00abInsertar\u00bb &gt; \u00abComboBox (Control ActiveX)\u00bb.<\/strong><\/li>\n\n\n\n<li><strong>Dibuja el control<\/strong> en la hoja de Excel.<\/li>\n\n\n\n<li><strong>Activa el \u00abModo Dise\u00f1o\u00bb<\/strong> y haz clic en \u00abPropiedades\u00bb.<\/li>\n\n\n\n<li><strong>Busca \u00abListFillRange\u00bb<\/strong> y escribe el nombre del rango de datos (por ejemplo, \u00abclientes\u00bb).<\/li>\n\n\n\n<li><strong>Desactiva el \u00abModo Dise\u00f1o\u00bb<\/strong> y prueba la lista desplegable.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Uso de Macros para Llenar un ComboBox<\/h3>\n\n\n\n<p>Para llenar el ComboBox din\u00e1micamente con VBA:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Private Sub Worksheet_Activate()\n    ComboBox1.Clear\n    ComboBox1.AddItem \"Ejemplo 1\"\n    ComboBox1.AddItem \"Ejemplo 2\"\n    ComboBox1.AddItem \"Ejemplo 3\"\nEnd Sub<\/code><\/pre>\n\n\n\n<p>Este c\u00f3digo agrega elementos autom\u00e1ticamente cuando se activa la hoja de trabajo.<\/p>\n\n\n\n<p>Ahorra dinero f\u00e1cilmente en tus licencias de software con Keysfan! Si necesitas activar Windows, Office u otros programas esenciales, este es el lugar indicado. Adem\u00e1s, aqu\u00ed encontrar\u00e1s licencias 100 % originales a precios s\u00faper accesibles.<br>Para ahorrar a\u00fan m\u00e1s, usa el c\u00f3digo de descuento <strong>DH66<\/strong> y obt\u00e9n un precio incre\u00edble. \u00a1No dejes pasar esta oportunidad! Adquiere tus licencias hoy mismo y disfruta de la mejor calidad al menor costo.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cu\u00e1l es la Mejor Opci\u00f3n<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Lista desplegable<\/strong>: Ideal para selecci\u00f3n r\u00e1pida y sencilla sin necesidad de macros.<\/li>\n\n\n\n<li><strong>Cuadro combinado<\/strong>: \u00fatil para selecci\u00f3n visual con referencia num\u00e9rica.<\/li>\n\n\n\n<li><strong>ComboBox (ActiveX)<\/strong>: Recomendado para proyectos avanzados con automatizaci\u00f3n VBA.<\/li>\n<\/ul>\n\n\n\n<p>\u23f3 \u00bfSientes que pierdes horas en Excel haciendo tareas repetitivas? Este <strong><a href=\"https:\/\/dostinhurtado.com\/site\/Categoria\/cursos\/excel-curso-basico-intermedio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Curso de Excel<\/a><\/strong> te ense\u00f1ar\u00e1 a optimizar tu flujo de trabajo con f\u00f3rmulas, tablas din\u00e1micas \ud83d\udcca y automatizaci\u00f3n. \ud83d\ude80. \u00a1Inscr\u00edbete ahora y domina Excel!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p>Las listas desplegables, cuadros combinados y ComboBox son herramientas poderosas en Excel para gestionar datos de manera eficiente. Dependiendo de tus necesidades, puedes optar por la opci\u00f3n m\u00e1s sencilla o una soluci\u00f3n avanzada con VBA.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Preguntas Frecuentes (FAQ)<\/h2>\n\n\n<div class=\"wp-block-uagb-faq uagb-faq__outer-wrap uagb-block-a647f836 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-e65d6025 \" 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>1. \u00bfPuedo usar listas desplegables en varias hojas de Excel?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, puedes usar nombres de rango para hacer referencia a listas en diferentes hojas.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-f5b47334 \" 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>2. \u00bfEs posible vincular una lista desplegable a una tabla din\u00e1mica?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, pero es recomendable usar nombres de rango din\u00e1micos para actualizar los valores autom\u00e1ticamente.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-ecedfc7f \" 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>3. \u00bfCu\u00e1l es la diferencia entre un cuadro combinado y un ComboBox?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>El cuadro combinado (formulario) devuelve la posici\u00f3n del elemento seleccionado, mientras que el ComboBox (ActiveX) ofrece m\u00e1s opciones de personalizaci\u00f3n mediante VBA.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-e68dcc2d \" 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>4. \u00bfPuedo usar ComboBox sin macros?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>S\u00ed, pero para funciones avanzadas como llenado autom\u00e1tico, necesitar\u00e1s VBA.<\/p><\/div><\/div><div class=\"wp-block-uagb-faq-child uagb-faq-child__outer-wrap uagb-faq-item uagb-block-7cebaf77 \" 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>5.\u00bfC\u00f3mo puedo hacer que una lista desplegable se actualice autom\u00e1ticamente al agregar nuevos datos?<\/strong><\/span><\/div><div class=\"uagb-faq-content\"><p>Puedes usar una tabla de Excel en lugar de un rango fijo. Al convertir el rango en tabla (Ctrl + T), la lista desplegable se actualizar\u00e1 autom\u00e1ticamente cuando agregues o elimines elementos.<\/p><\/div><\/div><\/div>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Las listas despegables son muy importantes en nuestro trabajo en Excel, aprender a realizarlas los har\u00e1n pasar de un manejo b\u00e1sico a experto en Excel. En este tutorial les ense\u00f1ar\u00e9 a realizar listas desplegables tradicionales en Excel, tambi\u00e9n aprender\u00e1n a realizar Cuadros Combinados y ComboBox, con todas sus curiosidades y en cuando usar uno u otro.<\/p>\n","protected":false},"author":4,"featured_media":19788,"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":[2253,2247,562,2551,225,232,277,539,1960,2251,2101,570,486,2531,2157],"class_list":["post-19787","post","type-post","status-publish","format-video","has-post-thumbnail","hentry","category-tutoriales-excel","tag-comprar-excel","tag-comprar-word","tag-curso","tag-datos-en-excel","tag-excel","tag-facil","tag-gratis","tag-gratuito","tag-keysfan","tag-licencia-de-office","tag-office-legal","tag-recomendado","tag-tutorial","tag-tutorial-de-excel","tag-windows-legal","post_format-post-format-video"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Listas desplegables en Excel - Dostin Hurtado<\/title>\n<meta name=\"description\" content=\"Aprende a crear listas desplegables en Excel, cuadros combinados y ComboBox con ejemplos pr\u00e1cticos. Optimiza tus hojas de c\u00e1lculo f\u00e1cilmente.\" \/>\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-cuadros-combinados-y-combobox\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Listas desplegables en Excel\" \/>\n<meta property=\"og:description\" content=\"Aprende a crear listas desplegables en Excel, cuadros combinados y ComboBox con ejemplos pr\u00e1cticos. Optimiza tus hojas de c\u00e1lculo f\u00e1cilmente.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/\" \/>\n<meta property=\"og:site_name\" content=\"Dostin Hurtado\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-09T19:54:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-09T16:58:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"501\" \/>\n\t<meta property=\"og:image:height\" content=\"376\" \/>\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=\"5 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-cuadros-combinados-y-combobox\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/\"},\"author\":{\"name\":\"Dostin Hurtado\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2\"},\"headline\":\"Listas desplegables en Excel\",\"datePublished\":\"2023-03-09T19:54:28+00:00\",\"dateModified\":\"2025-04-09T16:58:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/\"},\"wordCount\":826,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg\",\"keywords\":[\"comprar excel\",\"comprar word\",\"Curso\",\"datos en excel\",\"Excel\",\"Facil\",\"Gratis\",\"Gratuito\",\"Keysfan\",\"licencia de office\",\"office legal\",\"recomendado\",\"Tutorial\",\"tutorial de excel\",\"Windows legal\"],\"articleSection\":[\"Tutoriales de Excel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/\",\"url\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/\",\"name\":\"Listas desplegables en Excel - Dostin Hurtado\",\"isPartOf\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg\",\"datePublished\":\"2023-03-09T19:54:28+00:00\",\"dateModified\":\"2025-04-09T16:58:53+00:00\",\"description\":\"Aprende a crear listas desplegables en Excel, cuadros combinados y ComboBox con ejemplos pr\u00e1cticos. Optimiza tus hojas de c\u00e1lculo f\u00e1cilmente.\",\"breadcrumb\":{\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg\",\"width\":501,\"height\":376,\"caption\":\"Listas despegables en excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/dostinhurtado.com\/site\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Listas desplegables 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\/19f7f0caccebab406700992c37c9583d\"},\"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\/19f7f0caccebab406700992c37c9583d\",\"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\/8ce550788514b771f2fd0ab59d1694f2\",\"name\":\"Dostin Hurtado\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"url\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"contentUrl\":\"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290\",\"caption\":\"Dostin Hurtado\"},\"url\":\"https:\/\/dostinhurtado.com\/site\/author\/moderador\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Listas desplegables en Excel - Dostin Hurtado","description":"Aprende a crear listas desplegables en Excel, cuadros combinados y ComboBox con ejemplos pr\u00e1cticos. Optimiza tus hojas de c\u00e1lculo f\u00e1cilmente.","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-cuadros-combinados-y-combobox\/","og_locale":"es_ES","og_type":"article","og_title":"Listas desplegables en Excel","og_description":"Aprende a crear listas desplegables en Excel, cuadros combinados y ComboBox con ejemplos pr\u00e1cticos. Optimiza tus hojas de c\u00e1lculo f\u00e1cilmente.","og_url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/","og_site_name":"Dostin Hurtado","article_published_time":"2023-03-09T19:54:28+00:00","article_modified_time":"2025-04-09T16:58:53+00:00","og_image":[{"width":501,"height":376,"url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg","type":"image\/jpeg"}],"author":"Dostin Hurtado","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Dostin Hurtado","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#article","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/"},"author":{"name":"Dostin Hurtado","@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/8ce550788514b771f2fd0ab59d1694f2"},"headline":"Listas desplegables en Excel","datePublished":"2023-03-09T19:54:28+00:00","dateModified":"2025-04-09T16:58:53+00:00","mainEntityOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/"},"wordCount":826,"commentCount":0,"publisher":{"@id":"https:\/\/dostinhurtado.com\/site\/#\/schema\/person\/19f7f0caccebab406700992c37c9583d"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg","keywords":["comprar excel","comprar word","Curso","datos en excel","Excel","Facil","Gratis","Gratuito","Keysfan","licencia de office","office legal","recomendado","Tutorial","tutorial de excel","Windows legal"],"articleSection":["Tutoriales de Excel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/","url":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/","name":"Listas desplegables en Excel - Dostin Hurtado","isPartOf":{"@id":"https:\/\/dostinhurtado.com\/site\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage"},"image":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage"},"thumbnailUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg","datePublished":"2023-03-09T19:54:28+00:00","dateModified":"2025-04-09T16:58:53+00:00","description":"Aprende a crear listas desplegables en Excel, cuadros combinados y ComboBox con ejemplos pr\u00e1cticos. Optimiza tus hojas de c\u00e1lculo f\u00e1cilmente.","breadcrumb":{"@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#primaryimage","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg","width":501,"height":376,"caption":"Listas despegables en excel"},{"@type":"BreadcrumbList","@id":"https:\/\/dostinhurtado.com\/site\/tutoriales-gratis-online\/tutoriales-excel\/listas-desplegables-cuadros-combinados-y-combobox\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/dostinhurtado.com\/site\/"},{"@type":"ListItem","position":2,"name":"Listas desplegables 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\/19f7f0caccebab406700992c37c9583d"},"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\/19f7f0caccebab406700992c37c9583d","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\/8ce550788514b771f2fd0ab59d1694f2","name":"Dostin Hurtado","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","url":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","contentUrl":"https:\/\/dostinhurtado.com\/site\/wp-content\/litespeed\/avatar\/17c663d7c2709e6d30387f4bea83889d.jpg?ver=1775625290","caption":"Dostin Hurtado"},"url":"https:\/\/dostinhurtado.com\/site\/author\/moderador\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06-150x150.jpg",150,150,true],"medium":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06-300x225.jpg",300,225,true],"medium_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"1536x1536":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"2048x2048":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"ultp_layout_landscape_large":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"ultp_layout_landscape":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"ultp_layout_portrait":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"ultp_layout_square":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"woocommerce_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06-400x376.jpg",400,376,true],"woocommerce_single":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06.jpg",501,376,false],"woocommerce_gallery_thumbnail":["https:\/\/dostinhurtado.com\/site\/wp-content\/uploads\/2023\/03\/miniatura-06-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":"Las listas despegables son muy importantes en nuestro trabajo en Excel, aprender a realizarlas los har\u00e1n pasar de un manejo b\u00e1sico a experto en Excel. En este tutorial les ense\u00f1ar\u00e9 a realizar listas desplegables tradicionales en Excel, tambi\u00e9n aprender\u00e1n a realizar Cuadros Combinados y ComboBox, con todas sus curiosidades y en cuando usar uno u&hellip;","_links":{"self":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/19787","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=19787"}],"version-history":[{"count":4,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/19787\/revisions"}],"predecessor-version":[{"id":25267,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/posts\/19787\/revisions\/25267"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media\/19788"}],"wp:attachment":[{"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/media?parent=19787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/categories?post=19787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dostinhurtado.com\/site\/wp-json\/wp\/v2\/tags?post=19787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}