{"id":8069,"date":"2019-02-24T13:44:20","date_gmt":"2019-02-24T12:44:20","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=8069"},"modified":"2019-02-24T13:54:12","modified_gmt":"2019-02-24T12:54:12","slug":"excel-masquer-les-valeurs-nulles","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=8069","title":{"rendered":"Excel : masquer les valeurs nulles"},"content":{"rendered":"<p style=\"text-align: justify;\">Les valeurs nulles sont g\u00e9n\u00e9ralement non significatives mais encombrent les tableaux de donn\u00e9es emp\u00eachant leur lisibilit\u00e9.<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8070\" rel=\"attachment wp-att-8070\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8070\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Masquer-valeurs-nulles.png\" alt=\"Excel - Masquer les valeurs nulles\" width=\"564\" height=\"465\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Masquer-valeurs-nulles.png 564w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Masquer-valeurs-nulles-300x247.png 300w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\">Pour donner plus de lisibilit\u00e9 aux tableaux de donn\u00e9es, il est possible de masquer les valeurs nulles (0) avec le <a href=\"https:\/\/www.auditsi.eu\/?p=8013\">format personnalis\u00e9<\/a> suivant :<\/p>\n<p style=\"text-align: center;\">0;-0;;@<\/p>\n<p style=\"text-align: justify;\">Voici l&#8217;effet produit :<\/p>\n<div id=\"attachment_8071\" style=\"width: 355px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.auditsi.eu\/?attachment_id=8071\" rel=\"attachment wp-att-8071\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8071\" class=\"size-full wp-image-8071\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Valeurs-nulles-masqu\u00e9es.png\" alt=\"Valeurs nulles masqu\u00e9es\" width=\"345\" height=\"184\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Valeurs-nulles-masqu\u00e9es.png 345w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Valeurs-nulles-masqu\u00e9es-300x160.png 300w\" sizes=\"auto, (max-width: 345px) 100vw, 345px\" \/><\/a><p id=\"caption-attachment-8071\" class=\"wp-caption-text\">Valeurs nulles masqu\u00e9es<\/p><\/div>\n<p>Seules les valeurs nulles ont disparu de l&#8217;\u00e9cran, les autres sont toujours pr\u00e9sentes.<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?p=8013\">Personnaliser l\u2019affichage de ses donn\u00e9es<\/a>\u00a0\/ <a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"http:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20masquer%20les%20valeurs%20nulles\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les valeurs nulles sont g\u00e9n\u00e9ralement non significatives mais encombrent les tableaux de donn\u00e9es emp\u00eachant leur lisibilit\u00e9. Pour donner plus de lisibilit\u00e9 aux tableaux de donn\u00e9es, il est possible de masquer les valeurs nulles (0) avec le format personnalis\u00e9 suivant : 0;-0;;@ Voici l&#8217;effet produit : Seules les valeurs nulles ont disparu de l&#8217;\u00e9cran, les autres &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=8069\" class=\"more-link\">Continue reading &lsquo;Excel : masquer les valeurs nulles&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Excel%20%3A%20masquer%20les%20valeurs%20nulles\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[48,1326],"tags":[1633,2002,1999,2005,2015],"class_list":["post-8069","post","type-post","status-publish","format-standard","hentry","category-excel","category-maitriser-excel","tag-excel","tag-format-de-cellule","tag-format-personnalise","tag-masquer","tag-valeur-nulle"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8069"}],"version-history":[{"count":4,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8069\/revisions"}],"predecessor-version":[{"id":8075,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/8069\/revisions\/8075"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}