{"id":773,"date":"2025-09-17T12:52:00","date_gmt":"2025-09-17T10:52:00","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=773"},"modified":"2025-10-14T16:31:41","modified_gmt":"2025-10-14T14:31:41","slug":"excel-filtrer-les-cellules-vides","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2025\/09\/excel-filtrer-les-cellules-vides\/","title":{"rendered":"Excel &#8211; Filtrer les cellules vides"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Vous avez cr\u00e9\u00e9 une liste d&rsquo;adresses volumineuse dans Excel et souhaiteriez savoir si une colonne (par ex. celle contenant les num\u00e9ros postaux) contient des cellules vides&#8230; dans le but de compl\u00e9ter les donn\u00e9es manquantes avant de r\u00e9aliser votre publipostage par exemple. Bien entendu, vous avez saisi des en-t\u00eates de colonnes pour vos donn\u00e9es.<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>Placez votre curseur sur la ligne d\u2019en-t\u00eate de colonnes<\/li>\n<li>Allez dans l&rsquo;onglet <strong>Donn\u00e9es<\/strong> &gt; cliquez sur le bouton <strong>Filtrer<\/strong><\/li>\n<li>Cliquez sur la petite fl\u00e8che qui appara\u00eet sur l&rsquo;en-t\u00eate de colonne \u00ab\u00a0No postaux\u00a0\u00bb<\/li>\n<li>D\u00e9cochez le filtre <strong>S\u00e9lectionner tout<\/strong><\/li>\n<li>Allez en bas de la liste<\/li>\n<li>Si un num\u00e9ro postal manque, Excel propose le filtre <strong>Vides<\/strong><\/li>\n<\/ul>\n<address>L\u2019option \u00ab\u00a0Vides\u00a0\u00bb est disponible <strong>uniquement<\/strong> si la plage de cellules ou la colonne \u00e0 filtrer contient au moins une cellule vide. \u00c7a semble logique mais \u00e7a peut surprendre la 1\u00e8re fois.<\/address>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Vous avez cr\u00e9\u00e9 une liste d&rsquo;adresses volumineuse dans Excel et souhaiteriez savoir si une colonne (par ex. celle contenant les num\u00e9ros postaux) contient des cellules vides&#8230; dans&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3806,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":0,"_seopress_analysis_target_kw":"","_seopress_news_disabled":"","_seopress_video_disabled":"","_seopress_video":[],"_seopress_pro_schemas_manual":[],"_seopress_pro_rich_snippets_disable_all":"","_seopress_pro_rich_snippets_disable":[],"_seopress_pro_schemas":[],"footnotes":""},"categories":[4],"tags":[23,19],"class_list":["post-773","post","type-post","status-publish","format-standard","has-post-thumbnail","category-excel","tag-outil","tag-tableau"],"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/773","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=773"}],"version-history":[{"count":1,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/773\/revisions"}],"predecessor-version":[{"id":4951,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/773\/revisions\/4951"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3806"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=773"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=773"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=773"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}