{"id":14625,"date":"2023-10-31T10:57:01","date_gmt":"2023-10-31T13:57:01","guid":{"rendered":"https:\/\/excelfull.com\/excel\/?p=14625"},"modified":"2023-11-07T21:11:53","modified_gmt":"2023-11-08T00:11:53","slug":"filtrar-datos-en-una-tabla","status":"publish","type":"post","link":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/","title":{"rendered":"FILTRAR DATOS EN UNA TABLA"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #0a6e42;\"><strong><u>GESTI\u00d3N DE DATOS SIN ESTR\u00c9S: APRENDE A FILTRAR DATOS EN UNA TABLA DE EXCEL Y OPTIMIZA TUS AN\u00c1LISIS<\/u><\/strong><\/span><\/p><div id=\"excel-1310379797\" 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<p>Excel es una herramienta poderosa para manejar y analizar datos. Una de las funciones m\u00e1s \u00fatiles y fundamentales en Excel es la capacidad de <strong>filtrar datos en una tabla<\/strong>. El filtrado te permite seleccionar y mostrar solo los datos que cumplan con ciertos criterios, lo que facilita el an\u00e1lisis y la extracci\u00f3n de informaci\u00f3n relevante. En este art\u00edculo, te guiaremos a trav\u00e9s de los pasos para filtrar datos en Excel y te proporcionaremos consejos \u00fatiles para sacar el m\u00e1ximo provecho de esta funci\u00f3n.<\/p>\n<h2>COMO FILTRAR DATOS EN UNA TABLA DE EXCEL<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14626 alignleft\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/Ttabla-de-excel-150x150.png\" alt=\"\" width=\"57\" height=\"57\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/Ttabla-de-excel-150x150.png 150w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/Ttabla-de-excel.png 512w\" sizes=\"auto, (max-width: 57px) 100vw, 57px\" \/><\/p>\n<h3 style=\"padding-left: 80px;\">PASO 1: PREPARAR TUS DATOS<\/h3>\n<p style=\"padding-left: 80px;\">Antes de empezar a filtrar tus datos, aseg\u00farate de que tu tabla de Excel est\u00e9 bien organizada. Esto implica tener t\u00edtulos claros en la primera fila y que cada columna tenga un tipo de informaci\u00f3n espec\u00edfica. Por ejemplo, si est\u00e1s trabajando con una tabla de ventas, podr\u00edas tener columnas para el nombre del producto, la fecha, la cantidad vendida, el precio y otros detalles relevantes.<\/p>\n<p style=\"padding-left: 80px;\">Si aun no sabes c\u00f3mo hacer una tabla en Excel, te invitamos a que leas el articulo <strong><a href=\"https:\/\/excelfull.com\/excel\/como-hacer-una-tabla-en-excel\/\" target=\"_blank\" rel=\"noopener\">C\u00d3MO HACER UNA TABLA EN EXCEL<\/a><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14584 alignleft\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/paso-1-150x150.png\" alt=\"\" width=\"44\" height=\"44\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/paso-1-150x150.png 150w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/paso-1.png 512w\" sizes=\"auto, (max-width: 44px) 100vw, 44px\" \/><\/p>\n<h3 style=\"padding-left: 80px;\">PASO 2: SELECCIONAR LA TABLA<\/h3>\n<p style=\"padding-left: 80px;\">Para aplicar filtros, selecciona toda la tabla. Puedes hacerlo haciendo clic en la celda superior izquierda de la tabla y arrastrando el cursor hasta la celda inferior derecha.<\/p>\n<p>&nbsp;<\/p>\n<p style=\"font-family: -apple-system, system-ui, BlinkMacSystemFont, 'Segoe UI', Helvetica, Arial, sans-serif, 'Apple Color Emoji', 'Segoe UI Emoji', 'Segoe UI Symbol'; font-style: normal;\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14627 alignleft\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/aplicar-filtro-150x150.png\" alt=\"\" width=\"54\" height=\"54\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/aplicar-filtro-150x150.png 150w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/aplicar-filtro.png 512w\" sizes=\"auto, (max-width: 54px) 100vw, 54px\" \/><\/p>\n<h3 style=\"padding-left: 80px;\">PASO 3: APLICAR EL FILTRO<\/h3>\n<p style=\"padding-left: 80px;\">Con la tabla seleccionada, ve a la pesta\u00f1a <strong>\u00abDatos\u00bb<\/strong> en la cinta de opciones de Excel. Luego, haz clic en el icono <strong>\u00abFiltro\u00bb<\/strong> en el grupo <strong>\u00abOrdenar y filtrar\u00bb<\/strong>. Ver\u00e1s peque\u00f1as flechas en la fila de encabezados de cada columna de tu tabla.<\/p>\n<p style=\"padding-left: 80px;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-12436 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/10\/filtro.png\" alt=\"filtrar datos en excel\" width=\"891\" height=\"154\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/10\/filtro.png 891w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2022\/10\/filtro-768x133.png 768w\" sizes=\"auto, (max-width: 891px) 100vw, 891px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14630 alignleft\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtrar-dartos-1-150x150.png\" alt=\"\" width=\"64\" height=\"64\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtrar-dartos-1-150x150.png 150w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtrar-dartos-1.png 512w\" sizes=\"auto, (max-width: 64px) 100vw, 64px\" \/><\/p>\n<h3 style=\"padding-left: 80px;\">PASO 4: FILTRAR DATOS<\/h3>\n<p style=\"padding-left: 80px;\">Una vez que hayas habilitado los filtros, puedes comenzar a filtrar tus datos. Haz clic en la flecha de filtro en la columna que deseas filtrar. Aparecer\u00e1 un men\u00fa desplegable con diversas opciones de filtrado.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14632 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtrar-4.jpg\" alt=\"FILTRAR DATOS EN UNA TABLA\" width=\"514\" height=\"166\" \/><\/p>\n<p style=\"padding-left: 80px;\"><strong><span style=\"color: #0a6e42;\">Filtrar por Texto:<\/span><\/strong><\/p>\n<p style=\"padding-left: 80px;\">Si deseas filtrar datos basados en texto, selecciona la opci\u00f3n <strong>\u00abFiltros de Texto\u00bb<\/strong>. Esto te permitir\u00e1 buscar y seleccionar los valores espec\u00edficos que deseas mostrar en tu tabla. Desactiva <b class=\"ocpUI\">(Seleccionar todo)<\/b> y selecciona las casillas que desee mostrar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14633 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtrar-5.jpg\" alt=\"FILTRAR DATOS EN UNA TABLA\" width=\"268\" height=\"399\" \/><\/p>\n<p style=\"padding-left: 80px;\"><strong><span style=\"color: #0a6e42;\">Filtrar por N\u00fameros:<\/span><\/strong><\/p>\n<p style=\"padding-left: 80px;\">Para filtrar datos num\u00e9ricos, elige la opci\u00f3n <strong>\u00abFiltros Num\u00e9ricos\u00bb<\/strong>. Puedes definir rangos num\u00e9ricos, como \u00abmayor que\u00bb, \u00abmenor que\u00bb o seleccionar valores num\u00e9ricos espec\u00edficos.<\/p>\n<p style=\"padding-left: 40px;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14634 size-full\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtro-numeros.jpg\" alt=\"FILTRAR DATOS EN UNA TABLA\" width=\"450\" height=\"445\" \/><\/p>\n<p>&nbsp;<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14631 alignleft\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/resultado-150x150.png\" alt=\"\" width=\"55\" height=\"55\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/resultado-150x150.png 150w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/resultado.png 512w\" sizes=\"auto, (max-width: 55px) 100vw, 55px\" \/><span style=\"font-family: inherit; font-style: inherit;\">PASO 5: MOSTRAR RESULTADOS<\/span><\/h3>\n<p style=\"padding-left: 80px;\">Una vez que hayas seleccionado tus criterios de filtro, Excel mostrar\u00e1 solo las filas que cumplan con esos criterios y ocultar\u00e1 las dem\u00e1s. Puedes aplicar m\u00faltiples filtros a diferentes columnas para refinar tus resultados y obtener informaci\u00f3n espec\u00edfica.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14628 alignleft\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/eliminar-filtro-150x150.png\" alt=\"\" width=\"50\" height=\"50\" srcset=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/eliminar-filtro-150x150.png 150w, https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/eliminar-filtro.png 512w\" sizes=\"auto, (max-width: 50px) 100vw, 50px\" \/><\/p>\n<h3 style=\"padding-left: 80px;\">PASO 6: QUITAR LOS FILTROS<\/h3>\n<p style=\"padding-left: 80px;\">Para quitar los filtros y mostrar todos los datos nuevamente, simplemente regresa a la pesta\u00f1a <strong>\u00abDatos\u00bb<\/strong> y haz clic en <strong>\u00abBorrar\u00bb<\/strong> en el grupo <strong>\u00abOrdenar y filtrar\u00bb<\/strong>.<\/p>\n<p>&nbsp;<\/p>\n<h2>CONSEJOS \u00daTILES<\/h2>\n<ul>\n<li>Puedes utilizar filtros personalizados para definir criterios de filtrado m\u00e1s espec\u00edficos.<\/li>\n<li>Los filtros en Excel funcionan bien con fechas, por lo que puedes filtrar por un rango de fechas espec\u00edfico.<\/li>\n<li>Recuerda guardar tu archivo de Excel despu\u00e9s de aplicar filtros, ya que estos no se guardan autom\u00e1ticamente.<\/li>\n<\/ul>\n<h2>MIRA Y APRENDE<\/h2>\n<div style=\"width: 960px;\" class=\"wp-video\"><video class=\"wp-video-shortcode\" id=\"video-14625-1\" width=\"960\" height=\"544\" preload=\"metadata\" controls=\"controls\"><source type=\"video\/mp4\" src=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtro-tabla.mp4?_=1\" \/><a href=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtro-tabla.mp4\">https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/filtro-tabla.mp4<\/a><\/video><\/div>\n<p>&nbsp;<\/p>\n<h2>CONCLUSI\u00d3N<\/h2>\n<p>Filtrar datos en Excel es una habilidad esencial para cualquier persona que trabaje con tablas Te permite explorar y analizar grandes conjuntos de datos de manera eficiente, lo que puede ahorrarte tiempo y mejorar la precisi\u00f3n de tus an\u00e1lisis.<span style=\"color: #0a6e42;\"> <strong>\u00a1As\u00ed que no dudes en aplicar estos pasos y perfeccionar tus habilidades de filtrado en Excel!<\/strong><\/span><\/p>\n<hr \/>\n<blockquote><p><strong><span style=\"color: #0a6e42;\">\u00bb<\/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\">Facebook<\/a><\/span> e <span style=\"color: #ff00ff;\"><a style=\"color: #ff00ff;\" href=\"https:\/\/www.instagram.com\/excelfull_oficial\/\">Instagram<\/a><\/span>.<\/strong><\/p>\n<p><strong><span style=\"color: #0a6e42;\">\u00bb<\/span> D\u00e9janos tu comentario al final de esta p\u00e1gina.<\/strong><\/p>\n<p><strong><span style=\"color: #0a6e42;\">\u00bb<\/span> Explora m\u00e1s sobre nosotros directo aqu\u00ed: <a href=\"https:\/\/excelfull.com\/\">Curso de Excel Online<\/a><\/strong><\/p><\/blockquote>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; GESTI\u00d3N DE DATOS SIN &#8230; <a title=\"FILTRAR DATOS EN UNA TABLA\" class=\"read-more\" href=\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/\" aria-label=\"Leer m\u00e1s sobre FILTRAR DATOS EN UNA TABLA\">Leer m\u00e1s<\/a><\/p>\n","protected":false},"author":3,"featured_media":14637,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[328,346,749],"tags":[507,504,491],"class_list":["post-14625","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-basico","category-tablas","tag-filtros","tag-ordenar-y-filtrar","tag-tablas","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>FILTRAR DATOS EN UNA TABLA - EXCELFULL.COM<\/title>\n<meta name=\"description\" content=\"&nbsp; GESTI\u00d3N DE DATOS SIN ESTR\u00c9S: APRENDE A FILTRAR DATOS EN UNA TABLA DE EXCEL Y OPTIMIZA TUS AN\u00c1LISIS Excel es una herramienta poderosa para manejar y\" \/>\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\/filtrar-datos-en-una-tabla\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FILTRAR DATOS EN UNA TABLA - EXCELFULL.COM\" \/>\n<meta property=\"og:description\" content=\"&nbsp; GESTI\u00d3N DE DATOS SIN ESTR\u00c9S: APRENDE A FILTRAR DATOS EN UNA TABLA DE EXCEL Y OPTIMIZA TUS AN\u00c1LISIS Excel es una herramienta poderosa para manejar y\" \/>\n<meta property=\"og:url\" content=\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/\" \/>\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-10-31T13:57:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-08T00:11:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Excelfull\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Excelfull\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/\"},\"author\":{\"name\":\"Excelfull\",\"@id\":\"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801\"},\"headline\":\"FILTRAR DATOS EN UNA TABLA\",\"datePublished\":\"2023-10-31T13:57:01+00:00\",\"dateModified\":\"2023-11-08T00:11:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/\"},\"wordCount\":672,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#organization\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png\",\"keywords\":[\"filtros\",\"ordenar y filtrar\",\"tablas\"],\"articleSection\":[\"Excel\",\"Excel B\u00e1sico\",\"Tablas\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/\",\"url\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/\",\"name\":\"FILTRAR DATOS EN UNA TABLA - EXCELFULL.COM\",\"isPartOf\":{\"@id\":\"https:\/\/excelfull.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png\",\"datePublished\":\"2023-10-31T13:57:01+00:00\",\"dateModified\":\"2023-11-08T00:11:53+00:00\",\"description\":\"&nbsp; GESTI\u00d3N DE DATOS SIN ESTR\u00c9S: APRENDE A FILTRAR DATOS EN UNA TABLA DE EXCEL Y OPTIMIZA TUS AN\u00c1LISIS Excel es una herramienta poderosa para manejar y\",\"breadcrumb\":{\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage\",\"url\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png\",\"contentUrl\":\"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png\",\"width\":1280,\"height\":720,\"caption\":\"FILTRAR DATOS EN UNA TABLA\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#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\":\"FILTRAR DATOS EN UNA TABLA\"}]},{\"@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":"FILTRAR DATOS EN UNA TABLA - EXCELFULL.COM","description":"&nbsp; GESTI\u00d3N DE DATOS SIN ESTR\u00c9S: APRENDE A FILTRAR DATOS EN UNA TABLA DE EXCEL Y OPTIMIZA TUS AN\u00c1LISIS Excel es una herramienta poderosa para manejar y","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\/filtrar-datos-en-una-tabla\/","og_locale":"es_ES","og_type":"article","og_title":"FILTRAR DATOS EN UNA TABLA - EXCELFULL.COM","og_description":"&nbsp; GESTI\u00d3N DE DATOS SIN ESTR\u00c9S: APRENDE A FILTRAR DATOS EN UNA TABLA DE EXCEL Y OPTIMIZA TUS AN\u00c1LISIS Excel es una herramienta poderosa para manejar y","og_url":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/","og_site_name":"Blog de Excelfull","article_publisher":"https:\/\/www.facebook.com\/excelfull7","article_published_time":"2023-10-31T13:57:01+00:00","article_modified_time":"2023-11-08T00:11:53+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png","type":"image\/png"}],"author":"Excelfull","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Excelfull","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#article","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/"},"author":{"name":"Excelfull","@id":"https:\/\/excelfull.com\/excel\/#\/schema\/person\/8f7a28824a9700f3f823e56071d1f801"},"headline":"FILTRAR DATOS EN UNA TABLA","datePublished":"2023-10-31T13:57:01+00:00","dateModified":"2023-11-08T00:11:53+00:00","mainEntityOfPage":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/"},"wordCount":672,"commentCount":0,"publisher":{"@id":"https:\/\/excelfull.com\/excel\/#organization"},"image":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png","keywords":["filtros","ordenar y filtrar","tablas"],"articleSection":["Excel","Excel B\u00e1sico","Tablas"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/","url":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/","name":"FILTRAR DATOS EN UNA TABLA - EXCELFULL.COM","isPartOf":{"@id":"https:\/\/excelfull.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage"},"image":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage"},"thumbnailUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png","datePublished":"2023-10-31T13:57:01+00:00","dateModified":"2023-11-08T00:11:53+00:00","description":"&nbsp; GESTI\u00d3N DE DATOS SIN ESTR\u00c9S: APRENDE A FILTRAR DATOS EN UNA TABLA DE EXCEL Y OPTIMIZA TUS AN\u00c1LISIS Excel es una herramienta poderosa para manejar y","breadcrumb":{"@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#primaryimage","url":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png","contentUrl":"https:\/\/excelfull.com\/excel\/wp-content\/uploads\/2023\/10\/FILTRAR-DATOS-EN-UNA-TABLA-DE-EXCEL.png","width":1280,"height":720,"caption":"FILTRAR DATOS EN UNA TABLA"},{"@type":"BreadcrumbList","@id":"https:\/\/excelfull.com\/excel\/filtrar-datos-en-una-tabla\/#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":"FILTRAR DATOS EN UNA TABLA"}]},{"@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\/14625","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=14625"}],"version-history":[{"count":4,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/14625\/revisions"}],"predecessor-version":[{"id":14640,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/posts\/14625\/revisions\/14640"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media\/14637"}],"wp:attachment":[{"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/media?parent=14625"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/categories?post=14625"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excelfull.com\/excel\/wp-json\/wp\/v2\/tags?post=14625"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}