D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"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’effet produit : Seules les valeurs nulles ont disparu de l’\u00e9cran, les autres …<\/p>\n
Continue reading ‘Excel : masquer les valeurs nulles’ »<\/a><\/p>\n","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,"jetpack_seo_schema_type":"","ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_ayudawp_aiss_exclude":false,"_ayudawp_aiss_exclude_summary":false,"_ayudawp_aiss_summary":"","_ayudawp_aiss_summary_provider":"","_ayudawp_aiss_summary_hash":"","_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false,"_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}]}}
![\"Excel](\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Masquer-valeurs-nulles.png\")
<\/a><\/p>\n![\"Valeurs](\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2019\/02\/Excel-Valeurs-nulles-masqu\u00e9es.png\")
<\/a>