{"id":13684,"date":"2023-06-12T12:19:04","date_gmt":"2023-06-12T12:19:04","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=13684"},"modified":"2023-06-12T12:19:04","modified_gmt":"2023-06-12T12:19:04","slug":"listas-desplegables-en-excel","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/","title":{"rendered":"LISTAS DESPLEGABLES EN EXCEL"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #0a6e42;\"><u>CREA UNA EXPERIENCIA INTUITIVA EN TUS HOJAS DE C\u00c1LCULO Y EVITA ERRORES: APRENDE A UTILIZAR LISTAS DESPLEGABLES CON VALIDACI\u00d3N DE DATOS EN EXCEL<\/u><\/span><\/strong><\/p><div id=\"excel-288748348\" class=\"excel-contenido_3 excel-entity-placement\"><section id=\"temario-blog\" class=\"py-8 bg-white\">\r\n    <div class=\"max-w-4xl mx-auto px-4\">\r\n        <div class=\"relative overflow-hidden bg-slate-900 rounded-[2rem] p-8 md:p-12 shadow-xl\">\r\n            \r\n            <div class=\"absolute top-0 right-0 -translate-y-1\/2 translate-x-1\/2 w-64 h-64 bg-[#136E42] opacity-20 blur-[80px] rounded-full\"><\/div>\r\n            <div class=\"absolute bottom-0 left-0 translate-y-1\/2 -translate-x-1\/2 w-48 h-48 bg-emerald-500 opacity-10 blur-[60px] rounded-full\"><\/div>\r\n\r\n            <div class=\"relative z-10 flex flex-col gap-8\">\r\n                \r\n                <div class=\"text-center\">\r\n                    <div class=\"inline-flex items-center gap-2 bg-white\/10 border border-white\/20 px-3 py-1.5 rounded-full mb-4\">\r\n                        <i class=\"fa-solid fa-file-pdf text-emerald-400 text-xs\"><\/i>\r\n                        <span class=\"text-white text-[9px] font-black uppercase tracking-[0.2em]\">Recurso Gratuito 2026<\/span>\r\n                    <\/div>\r\n                    <h2 class=\"text-2xl md:text-3xl font-extrabold text-white leading-tight mb-3\">\r\n                        \u00bfTe gustar\u00eda dominar <span class=\"text-emerald-400\">Excel como un Pro?<\/span>\r\n                    <\/h2>\r\n                    <p class=\"text-slate-300 text-base font-medium max-w-xl mx-auto\">\r\n                        Suscr\u00edbete para recibir tips exclusivos y descarga el temario completo de nuestro curso profesional en PDF.\r\n                    <\/p>\r\n                <\/div>\r\n\r\n                <div class=\"w-full max-w-md mx-auto bg-white\/5 backdrop-blur-sm border border-white\/10 p-6 rounded-2xl\">\r\n                    \r\n                    <div id=\"form-content-blog\">\r\n                        <form id=\"excel-form-blog\" class=\"space-y-4\">\r\n                            <div>\r\n                                <label for=\"email-blog\" class=\"block text-white\/70 text-[10px] font-bold uppercase tracking-widest mb-2 ml-1\">Tu mejor correo electr\u00f3nico<\/label>\r\n                                <input type=\"email\" id=\"email-blog\" name=\"email\" placeholder=\"ejemplo@correo.com\" required \r\n                                    class=\"w-full bg-white\/10 border border-white\/20 rounded-xl px-4 py-3.5 text-white placeholder:text-slate-500 focus:outline-none focus:ring-2 focus:ring-emerald-500\/50 transition-all text-sm\">\r\n                            <\/div>\r\n                            \r\n                            <button type=\"submit\" id=\"submit-btn-blog\"\r\n                                class=\"w-full bg-[#136E42] hover:bg-emerald-600 text-white py-4 rounded-xl text-xs font-black uppercase tracking-widest transition-all shadow-lg active:scale-95 flex items-center justify-center gap-3\">\r\n                                <span>Descargar Temario y Suscribirme<\/span>\r\n                                <i class=\"fa-solid fa-paper-plane text-[10px]\"><\/i>\r\n                            <\/button>\r\n                        <\/form>\r\n                        <p class=\"text-slate-500 text-[9px] text-center mt-4 font-bold uppercase tracking-widest\">\r\n                            <i class=\"fa-solid fa-shield-halved mr-1\"><\/i> Sin spam. Solo contenido de valor.\r\n                        <\/p>\r\n                    <\/div>\r\n\r\n                    <div id=\"success-message-blog\" class=\"hidden text-center py-4\">\r\n                        <div class=\"w-12 h-12 bg-emerald-500\/20 text-emerald-400 rounded-full flex items-center justify-center mx-auto mb-3 border border-emerald-500\/30\">\r\n                            <i class=\"fa-solid fa-check text-xl\"><\/i>\r\n                        <\/div>\r\n                        <h3 class=\"text-white text-lg font-bold mb-1\">\u00a1Registro completado!<\/h3>\r\n                        <p class=\"text-slate-400 text-xs leading-relaxed\">\r\n                            Revisa tu bandeja de entrada; el temario ya va en camino.\r\n                        <\/p>\r\n                    <\/div>\r\n                <\/div>\r\n\r\n            <\/div>\r\n        <\/div>\r\n    <\/div>\r\n<\/section>\r\n\r\n<script>\r\ndocument.getElementById('excel-form-blog').addEventListener('submit', function(e) {\r\n    e.preventDefault();\r\n    const btn = document.getElementById('submit-btn-blog');\r\n    const email = document.getElementById('email-blog').value;\r\n    const btnText = btn.querySelector('span');\r\n    \r\n    btn.disabled = true;\r\n    btn.classList.add('opacity-50', 'cursor-not-allowed');\r\n    btnText.innerText = 'PROCESANDO...';\r\n\r\n    fetch('https:\/\/n8n.george.com.py\/webhook\/registro-excel-full', {\r\n        method: 'POST',\r\n        headers: { 'Content-Type': 'application\/json' },\r\n        body: JSON.stringify({ \r\n            email: email,\r\n            origen: 'descarga_temario_blog'\r\n        })\r\n    })\r\n    .then(response => {\r\n        if(response.ok) {\r\n            \/\/ Empujamos el evento a GTM para medir conversiones desde el blog\r\n            window.dataLayer = window.dataLayer || [];\r\n            window.dataLayer.push({\r\n                event: 'form_blog_success',\r\n                form_name: 'captacion_blog',\r\n                email: email,\r\n                origen: 'descarga_temario_blog'\r\n            });\r\n\r\n            document.getElementById('form-content-blog').classList.add('hidden');\r\n            document.getElementById('success-message-blog').classList.remove('hidden');\r\n        } else {\r\n            throw new Error();\r\n        }\r\n    })\r\n    .catch(error => {\r\n        alert('Hubo un inconveniente. Intenta de nuevo.');\r\n        btn.disabled = false;\r\n        btn.classList.remove('opacity-50', 'cursor-not-allowed');\r\n        btnText.innerText = 'Descargar Temario y Suscribirme';\r\n    });\r\n});\r\n<\/script><\/div>\n<h6>\u00bfQU\u00c9 ES UNA LISTA DESPLEGABLE?<\/h6>\n<p>Una lista desplegable es una herramienta que nos permite seleccionar un valor espec\u00edfico de una lista predefinida. Se muestra como una peque\u00f1a flecha en una celda, y al hacer clic en ella, se despliegan las opciones disponibles para elegir. Al seleccionar una opci\u00f3n de la lista, el valor correspondiente se inserta autom\u00e1ticamente en la celda.<\/p>\n<p>Es \u00fatil en situaciones en las que queremos limitar las opciones disponibles para una celda o columna en particular. Al utilizar una lista desplegable, evitamos errores de escritura y aseguramos la consistencia de los datos ingresados.<\/p>\n<p>Por ejemplo, si estamos creando una hoja de c\u00e1lculo para registrar el estado civil de las personas, podemos utilizar una lista desplegable con opciones como \u00abSoltero\/a\u00bb, \u00abCasado\/a\u00bb, \u00abDivorciado\/a\u00bb y \u00abViudo\/a\u00bb.<\/p>\n<h6>USOS DE UNA LISTA DESPLEGABLE EN EXCEL<\/h6>\n<p>Las listas desplegables en Excel son ampliamente utilizadas en diversas situaciones. Aqu\u00ed tenemos ejemplos de algunas de ellas:<\/p>\n<p style=\"padding-left: 40px;\"><strong><span style=\"color: #0a6e42;\">Control de inventario:<\/span><\/strong> Podemos utilizar una lista desplegable para seleccionar el estado de un producto, como \u00abEn stock\u00bb, \u00abAgotado\u00bb o \u00abEn pedido\u00bb.<\/p>\n<p style=\"padding-left: 40px;\"><span style=\"color: #0a6e42;\"><strong>Calificaciones de estudiantes:<\/strong><\/span> Podemos crear una lista desplegable para ingresar las calificaciones de los estudiantes, limitando las opciones a \u00abAprobado\u00bb, \u00abReprobado\u00bb o \u00abEn espera\u00bb.<\/p>\n<p style=\"padding-left: 40px;\"><strong><span style=\"color: #0a6e42;\">Prioridades de tareas:<\/span> <\/strong>Podemos utilizar una lista desplegable para asignar prioridades a las tareas, como \u00abAlta\u00bb, \u00abMedia\u00bb o \u00abBaja\u00bb.<\/p>\n<h6>CREAR UNA LISTA DESPLEGABLE EN EXCEL<\/h6>\n<p>La creaci\u00f3n de una lista desplegable en Excel se realiza utilizando la funci\u00f3n de <strong><a href=\"https:\/\/excelfull.com\/excel\/validacion-de-datos-en-excel\/\" target=\"_blank\" rel=\"noopener\">Validaci\u00f3n de Datos<\/a><\/strong>. Esta funci\u00f3n nos permite especificar el rango de celdas que contiene las opciones de la lista y configurar otras opciones, como mensajes de entrada para guiar al usuario. Una vez configurada la validaci\u00f3n de datos, la lista desplegable se muestra en la celda seleccionada, facilitando la selecci\u00f3n de opciones predefinidas.<\/p>\n<p>Hacerlo, es m\u00e1s sencillo de lo que parece:<\/p>\n<p><strong><span style=\"color: #0a6e42;\">Paso 1:<\/span> Preparar la lista de opciones<\/strong><\/p>\n<p>Antes de crear la lista desplegable, necesitas tener una lista de opciones en mente. Por ejemplo, si quieres hacer una lista desplegable para los d\u00edas de la semana, tendr\u00e1s que escribir los nombres de los d\u00edas en alguna parte de la hoja de c\u00e1lculo.<\/p>\n<p><strong><span style=\"color: #0a6e42;\">Paso 2:<\/span> Seleccionar la celda donde quieres la lista desplegable<\/strong><\/p>\n<p>Elige la celda donde deseas que aparezca la lista desplegable. Por ejemplo, si quieres que est\u00e9 en la celda A1, haz clic en esa celda.<\/p>\n<p><strong><span style=\"color: #0a6e42;\">Paso 3:<\/span> Acceder a la funci\u00f3n de validaci\u00f3n de datos<\/strong><\/p>\n<p>Ahora, ve a la pesta\u00f1a \u00abDatos\u00bb en la parte superior de la pantalla y haz clic en la opci\u00f3n \u00abValidaci\u00f3n de datos\u00bb. Se abrir\u00e1 una ventana emergente con algunas opciones.<\/p>\n<p><strong><span style=\"color: #0a6e42;\">Paso 4:<\/span> Configurar la validaci\u00f3n de datos<\/strong><\/p>\n<p>Dentro de la ventana emergente, selecciona la pesta\u00f1a \u00abConfiguraci\u00f3n\u00bb. Luego, en el men\u00fa desplegable \u00abPermitir\u00bb, elige la opci\u00f3n \u00abLista\u00bb. A continuaci\u00f3n, en el campo \u00abOrigen\u00bb, debes indicar el rango de celdas donde tienes las opciones de tu lista. Por ejemplo, si tus opciones est\u00e1n en las celdas B1 a B5, debes escribir \u00ab$B$1:$B$5\u00bb en el campo \u00abOrigen\u00bb.<\/p>\n<p><strong><span style=\"color: #0a6e42;\">Paso 5:<\/span> Aplicar y probar la lista desplegable<\/strong><\/p>\n<p>Haz clic en \u00abAceptar\u00bb en la ventana emergente de validaci\u00f3n de datos. \u00a1Listo! La lista desplegable aparecer\u00e1 en la celda que seleccionaste en el paso 2. Para probarla, solo tienes que hacer clic en la celda y ver\u00e1s que se despliegan las opciones que definiste en el paso 1. Al seleccionar una opci\u00f3n, esta se colocar\u00e1 autom\u00e1ticamente en la celda.<\/p>\n<h6>EJEMPLOS DE LISTAS DESPLEGABLES<\/h6>\n<p><iframe loading=\"lazy\" title=\"Desarrollando listas desplegables en Excel 2016\" src=\"https:\/\/player.vimeo.com\/video\/469360047?h=eb6cefacea&amp;dnt=1&amp;app_id=122963\" width=\"960\" height=\"540\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<h6>CONCLUSI\u00d3N<\/h6>\n<p>La validaci\u00f3n de datos en Excel nos brinda la posibilidad de crear listas desplegables para simplificar y mejorar la precisi\u00f3n en la entrada de datos. Las ventajas de utilizar esta funci\u00f3n son claras: evitamos errores de escritura, aseguramos la consistencia de los datos y facilitamos la selecci\u00f3n de opciones espec\u00edficas. Con los pasos mencionados anteriormente y algunos ejemplos sencillos, ahora tienes los conocimientos necesarios para crear tus propias listas desplegables en Excel. <strong><span style=\"color: #0a6e42;\">\u00a1Empieza a aprovechar esta herramienta y optimiza tu trabajo en hojas de c\u00e1lculo!<\/span><\/strong><\/p>\n<hr \/>\n<p><span style=\"color: #0a6e42;\"><strong>\u00bb<\/strong> <\/span>Si te gustan nuestros blogs, comp\u00e1rtelo con tus amigos. Puedes seguirnos en <span style=\"color: #3366ff;\"><a style=\"color: #3366ff;\" href=\"https:\/\/www.facebook.com\/excelfull7\"><strong>Facebook<\/strong><\/a> <\/span>e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\"><strong>Instagram<\/strong><\/a><\/span>.<\/p>\n<p><span style=\"color: #0a6e42;\"><strong>\u00bb<\/strong> <\/span>D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/p>\n<p><span style=\"color: #0a6e42;\"><strong>\u00bb<\/strong><\/span> Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\"><strong>Curso de Excel Online<\/strong><\/a><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; CREA UNA EXPERIENCIA INTUITIVA &#8230; <a title=\"LISTAS DESPLEGABLES EN EXCEL\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\" aria-label=\"Leer m\u00e1s sobre LISTAS DESPLEGABLES EN EXCEL\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":13691,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,549,550],"tags":[688,683],"class_list":["post-13684","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-intermedio","category-manejo-de-base-de-datos","tag-lista-desplegable","tag-validacion-en-excel","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>LISTAS DESPLEGABLES EN EXCEL - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"Las Listas Desplegables en Excel aseguran la consitencia en la entrada de datos al facilitar la selecci\u00f3n de opciones espec\u00edficas.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\" \/>\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 - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"Las Listas Desplegables en Excel aseguran la consitencia en la entrada de datos al facilitar la selecci\u00f3n de opciones espec\u00edficas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog de Excelfull\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/excelfull7\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-12T12:19:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"LISTAS DESPLEGABLES EN EXCEL\",\"datePublished\":\"2023-06-12T12:19:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\"},\"wordCount\":758,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png\",\"keywords\":[\"lista desplegable\",\"validacion en excel\"],\"articleSection\":[\"Excel\",\"Excel Intermedio\",\"Manejo de Base de Datos\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\",\"url\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\",\"name\":\"LISTAS DESPLEGABLES EN EXCEL - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png\",\"datePublished\":\"2023-06-12T12:19:04+00:00\",\"description\":\"Las Listas Desplegables en Excel aseguran la consitencia en la entrada de datos al facilitar la selecci\u00f3n de opciones espec\u00edficas.\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"LISTAS DESPLEGABLES EN EXCEL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/excelfull.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel\",\"item\":\"https:\/\/excelfull.com\/excel\/excel\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LISTAS DESPLEGABLES EN EXCEL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/excelfull.com\/excel\/#website\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"name\":\"Blog de Excelfull\",\"description\":\"Todo lo que necesitas saber sobre Excel\",\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"alternateName\":\"Blog Excel Online\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/excelfull.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\",\"name\":\"Nlog Excelfull\",\"alternateName\":\"Blog Excel En L\u00ednea\",\"url\":\"https:\/\/excelfull.com\/excel\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png\",\"width\":1342,\"height\":341,\"caption\":\"Nlog Excelfull\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/excelfull7\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\",\"name\":\"Excelfull\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g\",\"caption\":\"Excelfull\"},\"url\":\"https:\/\/excelfull.com\/excel\/author\/ema\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"LISTAS DESPLEGABLES EN EXCEL - EXCELFULL.COM","description":"Las Listas Desplegables en Excel aseguran la consitencia en la entrada de datos al facilitar la selecci\u00f3n de opciones espec\u00edficas.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/","og_locale":"es_ES","og_type":"article","og_title":"LISTAS DESPLEGABLES EN EXCEL - EXCELFULL.COM","og_description":"Las Listas Desplegables en Excel aseguran la consitencia en la entrada de datos al facilitar la selecci\u00f3n de opciones espec\u00edficas.","og_url":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-06-12T12:19:04+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"LISTAS DESPLEGABLES EN EXCEL","datePublished":"2023-06-12T12:19:04+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/"},"wordCount":758,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png","keywords":["lista desplegable","validacion en excel"],"articleSection":["Excel","Excel Intermedio","Manejo de Base de Datos"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/","url":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/","name":"LISTAS DESPLEGABLES EN EXCEL - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png","datePublished":"2023-06-12T12:19:04+00:00","description":"Las Listas Desplegables en Excel aseguran la consitencia en la entrada de datos al facilitar la selecci\u00f3n de opciones espec\u00edficas.","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/06\/LAS-LISTAS-DESPLEGABLES-EN-EXCEL.png","width":1280,"height":720,"caption":"LISTAS DESPLEGABLES EN EXCEL"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/listas-desplegables-en-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/excelfull.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel","item":"https:\/\/excelfull.com\/excel\/excel\/"},{"@type":"ListItem","position":3,"name":"LISTAS DESPLEGABLES EN EXCEL"}]},{"@type":"WebSite","@id":"https:\/\/excelfull.com\/excel\/#website","url":"https:\/\/excelfull.com\/excel\/","name":"Blog de Excelfull","description":"Todo lo que necesitas saber sobre Excel","publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"alternateName":"Blog Excel Online","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/excelfull.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/excelfull.com\/excel\/#organization","name":"Nlog Excelfull","alternateName":"Blog Excel En L\u00ednea","url":"https:\/\/excelfull.com\/excel\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/08\/Logo-excelfull.png","width":1342,"height":341,"caption":"Nlog Excelfull"},"image":{"@id":"https:\/\/excelfull.com\/excel\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/excelfull7"]},{"@type":"Person","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801","name":"Excelfull","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5bf7b801a90cbf07d593ad1261eb6e937c0ff73904ec636164fadb7ea30f685a?s=96&d=identicon&r=g","caption":"Excelfull"},"url":"https:\/\/excelfull.com\/excel\/author\/ema\/"}]}},"_links":{"self":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13684","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/comments?post=13684"}],"version-history":[{"count":3,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13684\/revisions"}],"predecessor-version":[{"id":13688,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/13684\/revisions\/13688"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/13691"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=13684"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=13684"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=13684"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}