{"id":23052,"date":"2026-07-24T21:08:55","date_gmt":"2026-07-24T19:08:55","guid":{"rendered":"https:\/\/help.mapal-os.com\/?p=23052"},"modified":"2026-07-24T21:14:06","modified_gmt":"2026-07-24T19:14:06","slug":"activar-y-utilizar-los-filtros-en-excel","status":"publish","type":"post","link":"https:\/\/help.mapal-os.com\/es\/easilys-es\/pedidos-de-proveedores\/recepciones\/activar-y-utilizar-los-filtros-en-excel\/","title":{"rendered":"Activar y utilizar los filtros en Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Empieza desde:<\/strong> Tu archivo de Excel abierto<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Abrir el archivo<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Abre Excel.<\/li>\n\n\n\n<li>Abre el archivo que contiene los datos que quieres filtrar.<\/li>\n\n\n\n<li>Selecciona una celda de la tabla.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"279\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-95.png\" alt=\"\" class=\"wp-image-23053\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-95.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-95-300x82.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-95-768x209.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Activar el filtro<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Hay dos m\u00e9todos disponibles. Utiliza el que prefieras.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00e9todo 1: desde la pesta\u00f1a Inicio<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Selecciona la pesta\u00f1a <strong>Inicio<\/strong> en la parte superior de la ventana.<\/li>\n\n\n\n<li>Selecciona <strong>Ordenar y filtrar<\/strong>, en el grupo <strong>Edici\u00f3n<\/strong>, a la derecha de la cinta de opciones.<\/li>\n\n\n\n<li>Selecciona <strong>Filtro<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"362\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-96.png\" alt=\"\" class=\"wp-image-23054\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-96.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-96-300x106.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-96-768x272.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Observaciones:<\/strong> Tambi\u00e9n puedes utilizar el atajo de teclado <strong>Ctrl + May\u00fas + L<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00e9todo 2: desde la pesta\u00f1a Datos<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Selecciona la pesta\u00f1a <strong>Datos<\/strong> en la parte superior de la ventana.<\/li>\n\n\n\n<li>Selecciona el icono <strong>Filtro<\/strong>, con forma de embudo.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"243\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-97.png\" alt=\"\" class=\"wp-image-23055\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-97.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-97-300x71.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-97-768x182.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Aparece una flecha en cada encabezado de columna.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"85\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-98.png\" alt=\"\" class=\"wp-image-23056\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-98.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-98-300x25.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/image-98-768x64.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Utilizar el filtro<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Selecciona la flecha de la columna que quieres filtrar.<\/li>\n\n\n\n<li>Desmarca <strong>(Seleccionar todo)<\/strong>.<\/li>\n\n\n\n<li>Marca solo los valores que quieres mostrar.<\/li>\n\n\n\n<li>Selecciona <strong>OK<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">La tabla muestra ahora solo las filas que coinciden con tu selecci\u00f3n.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Los filtros de Excel te permiten ordenar y buscar datos en una tabla r\u00e1pidamente, por ejemplo en un archivo exportado desde Easilys. Este art\u00edculo explica c\u00f3mo activar la funci\u00f3n Autofiltro y utilizarla para mostrar solo las filas que necesitas.<\/p>\n","protected":false},"author":251318858,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[132668],"tags":[133241,133238],"class_list":["post-23052","post","type-post","status-publish","format-standard","hentry","category-recepciones","tag-filtros","tag-excel"],"acf":{"article_type":"default","post_id":"","post_url_text":"","post_url":"","info_box":{"title":"","info":""},"post_video":"","import_category":"","overview_item":null,"troubleshoot_case":null},"_links":{"self":[{"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/posts\/23052","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/users\/251318858"}],"replies":[{"embeddable":true,"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/comments?post=23052"}],"version-history":[{"count":1,"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/posts\/23052\/revisions"}],"predecessor-version":[{"id":23061,"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/posts\/23052\/revisions\/23061"}],"wp:attachment":[{"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/media?parent=23052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/categories?post=23052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.mapal-os.com\/es\/wp-json\/wp\/v2\/tags?post=23052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}