{"id":424,"date":"2023-10-29T08:03:11","date_gmt":"2023-10-29T08:03:11","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/"},"modified":"2023-12-25T10:23:30","modified_gmt":"2023-12-25T10:23:30","slug":"aplicar-multiples-filtros","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/","title":{"rendered":"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1770914430\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Excel, si tiene varias columnas en los datos y desea filtrar varias columnas, puede hacerlo f\u00e1cilmente. Cuando aplica un filtro a un rango de datos continuo, Excel le permite filtrar varias columnas.<\/p>\n<p> En este tutorial, veremos los sencillos pasos para aplicar filtros de varias columnas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72663\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"aplicar m\u00faltiples filtros\" width=\"685\" height=\"296\"><\/figure>\n<\/div>\n<p> En los datos anteriores, necesitamos aplicar un filtro en dos columnas \u00abtipo\u00bb y \u00abcontribuido_por\u00bb.<\/p>\n<h2 class=\"wp-block-heading\"> Pasos para aplicar m\u00faltiples filtros en Excel<\/h2>\n<ol>\n<li> Primero, use el <a href=\"https:\/\/exceladvisor.org\/es\/atajos-de-teclado\/\">m\u00e9todo abreviado de teclado<\/a> (Alt \u21e2 D \u21e2 F \u21e2 F) para <a href=\"https:\/\/exceladvisor.org\/es\/filtro-1\/\">aplicar el filtro<\/a> , o tambi\u00e9n puede ir a Inicio \u21e2 Ordenar y filtrar \u21e2 Filtrar. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-aplicar-filtro\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-appliquer-le-filtre.png\" sizes=\"auto, \" srcset=\"\" alt=\"apply-filter\" width=\"717\" height=\"184\"><\/li>\n<li> A continuaci\u00f3n, debe hacer clic en el men\u00fa desplegable de filtro para la columna \u00abtipo\u00bb y desde all\u00ed debe desmarcar todos los valores que no sean \u00abCiudad\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"Men\u00fa desplegable de filtros en 3 clics\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cliquez-sur-la-liste-deroulante-des-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-on-filter-dropdown\" width=\"507\" height=\"390\"><\/li>\n<li> Despu\u00e9s de eso, haga clic en Aceptar para aplicar el filtro. Y cuando haga eso, filtrar\u00e1 todos los datos seg\u00fan la columna \u00abCiudad\u00bb de la columna \u00abtipo\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4-ok-para-aplicar-filtro\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-ok-pour-appliquer-le-filtre.png\" sizes=\"auto, \" srcset=\"\" alt=\"ok-to-apply-filter\" width=\"576\" height=\"199\"><\/li>\n<li> A continuaci\u00f3n, vaya a la columna \u00abcontributed_by\u00bb, abra el men\u00fa desplegable del filtro y desmarque todos los valores que no sean \u00abKenny Cunanan\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-abrir-filtro-desplegable\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-ouvrir-la-liste-deroulante-des-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"open-the-filter-dropdown\" width=\"520\" height=\"398\"><\/li>\n<li> Al final, haga clic en Aceptar para aplicar el filtro.<\/li>\n<\/ol>\n<p> Una vez hecho esto, se aplicar\u00e1n varios filtros a sus datos. Uno est\u00e1 en la columna \u00abtipo\u00bb y el otro est\u00e1 en la columna \u00abcontribuido_por\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72669\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-filtres-multiples-appliques.png\" sizes=\"auto, \" srcset=\"\" alt=\"m\u00faltiples filtros aplicados\" width=\"643\" height=\"345\"><\/figure>\n<\/div>\n<p> No solo dos, puedes aplicar m\u00faltiples filtros a tantas columnas como quieras. Puede ir m\u00e1s all\u00e1 y aplicar un filtro adicional a la columna \u00abestado\u00bb. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72670\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-appliquer-plusieurs-filtres.png\" sizes=\"auto, \" srcset=\"\" alt=\"aplicar m\u00faltiples filtros\" width=\"778\" height=\"163\"><\/figure>\n<\/div>\n<p> En el ejemplo anterior, tenemos el tercer filtro en la columna \u00abestado\u00bb donde hemos filtrado todos los valores con CA.<\/p>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/avance-de-excel\/\">Tutoriales avanzados de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/herramienta-de-analisis-rapido\/\">Herramienta de an\u00e1lisis r\u00e1pido en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/resaltar-los-valores-superiores-e-inferiores\/\">Resalte los valores N superiores e inferiores en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/casilla-de-verificacion\/\">Insertar una casilla de verificaci\u00f3n en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fusionar-celdas-sin-perder-datos\/\">Fusionar celdas sin perder datos en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/pegar-multiplicar-especial\/\">Multiplicar en Excel usando Pegado especial<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, si tiene varias columnas en los datos y desea filtrar varias columnas, puede hacerlo f\u00e1cilmente. Cuando aplica un filtro a un rango de datos continuo, Excel le permite filtrar varias columnas. En este tutorial, veremos los sencillos pasos para aplicar filtros de varias columnas. En los datos anteriores, necesitamos aplicar un filtro en [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-424","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, si tiene varias columnas en los datos y desea filtrar varias columnas, puede hacerlo f\u00e1cilmente. Cuando aplica un filtro a un rango de datos continuo, Excel le permite filtrar varias columnas. En este tutorial, veremos los sencillos pasos para aplicar filtros de varias columnas. En los datos anteriores, necesitamos aplicar un filtro en [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/\",\"name\":\"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\",\"datePublished\":\"2023-10-29T08:03:11+00:00\",\"dateModified\":\"2023-12-25T10:23:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?","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:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?","og_description":"En Excel, si tiene varias columnas en los datos y desea filtrar varias columnas, puede hacerlo f\u00e1cilmente. Cuando aplica un filtro a un rango de datos continuo, Excel le permite filtrar varias columnas. En este tutorial, veremos los sencillos pasos para aplicar filtros de varias columnas. En los datos anteriores, necesitamos aplicar un filtro en [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:30+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/","url":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/","name":"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png","datePublished":"2023-10-29T08:03:11+00:00","dateModified":"2023-12-25T10:23:30+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-appliquer-plusieurs-filtres.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo aplicar m\u00faltiples filtros a columnas en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=424"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/424\/revisions"}],"predecessor-version":[{"id":849,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/424\/revisions\/849"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}