{"id":23032,"date":"2026-07-24T21:08:55","date_gmt":"2026-07-24T19:08:55","guid":{"rendered":"https:\/\/help.mapal-os.com\/?p=23032"},"modified":"2026-07-24T21:08:58","modified_gmt":"2026-07-24T19:08:58","slug":"activer-et-utiliser-les-filtres-sur-excel","status":"publish","type":"post","link":"https:\/\/help.mapal-os.com\/fr\/easilys-fr\/commandes-fournisseurs\/receptions\/activer-et-utiliser-les-filtres-sur-excel\/","title":{"rendered":"Activer et utiliser les filtres sur Excel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>Point de d\u00e9part :<\/strong> Votre fichier Excel ouvert<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ouvrir votre fichier<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Lancez Excel.<\/li>\n\n\n\n<li>Ouvrez le fichier contenant les donn\u00e9es que vous souhaitez filtrer.<\/li>\n\n\n\n<li>S\u00e9lectionnez une cellule dans votre tableau.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"279\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.05.49-p.-m-1024x279.png\" alt=\"\" class=\"wp-image-23033\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.05.49-p.-m-1024x279.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.05.49-p.-m-300x82.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.05.49-p.-m-768x209.png 768w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.05.49-p.-m.png 1420w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Activer le filtre<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Deux m\u00e9thodes sont disponibles. Utilisez celle qui vous convient.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00e9thode 1 : depuis l'onglet Accueil<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u00e9lectionnez l'onglet <strong>Accueil<\/strong> en haut de la fen\u00eatre.<\/li>\n\n\n\n<li>S\u00e9lectionnez <strong>Trier et filtrer<\/strong>, dans le groupe <strong>\u00c9dition<\/strong> \u00e0 droite du ruban.<\/li>\n\n\n\n<li>S\u00e9lectionnez <strong>Filtrer<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"362\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.06-p.-m-1024x362.png\" alt=\"\" class=\"wp-image-23034\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.06-p.-m-1024x362.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.06-p.-m-300x106.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.06-p.-m-768x271.png 768w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.06-p.-m.png 1418w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Remarque :<\/strong> Vous pouvez \u00e9galement utiliser le raccourci clavier <strong>Ctrl + Maj + L<\/strong>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">M\u00e9thode 2 : depuis l'onglet Donn\u00e9es<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u00e9lectionnez l'onglet <strong>Donn\u00e9es<\/strong> en haut de la fen\u00eatre.<\/li>\n\n\n\n<li>S\u00e9lectionnez l'ic\u00f4ne <strong>Filtrer<\/strong>, en forme d'entonnoir.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"243\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.16-p.-m-1024x243.png\" alt=\"\" class=\"wp-image-23035\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.16-p.-m-1024x243.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.16-p.-m-300x71.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.16-p.-m-768x182.png 768w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.16-p.-m.png 1416w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Une fl\u00e8che appara\u00eet dans chaque en-t\u00eate de colonne.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"85\" src=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.25-p.-m-1024x85.png\" alt=\"\" class=\"wp-image-23036\" srcset=\"https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.25-p.-m-1024x85.png 1024w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.25-p.-m-300x25.png 300w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.25-p.-m-768x64.png 768w, https:\/\/help.mapal-os.com\/wp-content\/uploads\/2026\/07\/Captura-de-pantalla-2026-07-24-a-las-2.06.25-p.-m.png 1418w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Utiliser le filtre<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u00e9lectionnez la fl\u00e8che dans la colonne que vous souhaitez filtrer.<\/li>\n\n\n\n<li>D\u00e9cochez <strong>(S\u00e9lectionner tout)<\/strong>.<\/li>\n\n\n\n<li>Cochez uniquement les valeurs que vous souhaitez afficher.<\/li>\n\n\n\n<li>S\u00e9lectionnez <strong>OK<\/strong>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Votre tableau n'affiche plus que les lignes correspondant \u00e0 votre s\u00e9lection.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Les filtres Excel vous permettent de trier et de rechercher rapidement des donn\u00e9es dans un tableau, par exemple dans un fichier export\u00e9 depuis Easilys. Cet article explique comment activer la fonction Filtre automatique et l'utiliser pour n'afficher que les lignes qui vous int\u00e9ressent.<\/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":[132155],"tags":[133238,133239],"class_list":["post-23032","post","type-post","status-publish","format-standard","hentry","category-receptions","tag-excel","tag-filtre"],"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\/fr\/wp-json\/wp\/v2\/posts\/23032","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/users\/251318858"}],"replies":[{"embeddable":true,"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/comments?post=23032"}],"version-history":[{"count":0,"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/posts\/23032\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/media?parent=23032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/categories?post=23032"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.mapal-os.com\/fr\/wp-json\/wp\/v2\/tags?post=23032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}