{"id":9248,"date":"2011-06-11T15:22:48","date_gmt":"2011-06-11T14:22:48","guid":{"rendered":"http:\/\/best-of-high-tech.com\/fr\/?p=9248"},"modified":"2011-06-11T15:22:48","modified_gmt":"2011-06-11T14:22:48","slug":"afficher-masquer-zero-excel","status":"publish","type":"post","link":"https:\/\/best-of-high-tech.com\/fr\/afficher-masquer-zero-excel\/","title":{"rendered":"afficher ou masquer les valeurs z\u00e9ro dans une feuille de calcul excel"},"content":{"rendered":"<p>\n\tPar d&eacute;faut, Excel affiche toutes les informations que vous saisissez, m&ecirc;me les z&eacute;ros. Dans une feuille de calculs qui en contient beaucoup, il peut &ecirc;tre difficile de voir les informations importantes. Vous pouvez choisir de masquer ou d&#39;afficher tous les z&eacute;ros de la page, m&ecirc;me s&#39;il s&#39;agit de r&eacute;sultats de fonctions.&nbsp;<\/p>\n<ol start=\"1\" type=\"1\">\n<li>\n\t\tDans le menu&nbsp;Outils, cliquez sur&nbsp;Options, puis sur l&#39;onglet&nbsp;Affichage.<\/li>\n<li>\n\t\tEffectuez l&#39;une des actions suivantes&nbsp;:<\/p>\n<ul>\n<li>\n\t\t\t\tPour afficher les valeurs z&eacute;ro (0) dans les cellules, activez la case &agrave; cocher&nbsp;Valeurs z&eacute;ro.<\/li>\n<li>\n\t\t\t\tPour afficher les valeurs z&eacute;ro sous la forme de cellules vides, d&eacute;sactivez cette case &agrave; cocher.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>\n\t<img loading=\"lazy\" decoding=\"async\" alt=\"afficher zero excel\" class=\"alignnone size-full wp-image-9252\" height=\"182\" src=\"http:\/\/best-of-high-tech.com\/fr\/wp-content\/uploads\/2011\/05\/afficher-zero-excel.gif\" title=\"afficher zero excel\" width=\"396\" srcset=\"https:\/\/best-of-high-tech.com\/fr\/wp-content\/uploads\/2011\/05\/afficher-zero-excel.gif 396w, https:\/\/best-of-high-tech.com\/fr\/wp-content\/uploads\/2011\/05\/afficher-zero-excel-300x137.gif 300w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/p>\n<p>\n\tLes z&eacute;ros ne sont d&eacute;sormais plus affich&eacute;s &agrave; l&#39;&eacute;cran, mais &eacute;galement &agrave; l&#39;impression.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel affiche toutes les infos m\u00eame les z\u00e9ros. Dans une feuille de calculs qui en contient beaucoup, il est difficile de voir les informations importantes.  <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[77],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts\/9248"}],"collection":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/comments?post=9248"}],"version-history":[{"count":6,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts\/9248\/revisions"}],"predecessor-version":[{"id":9775,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/posts\/9248\/revisions\/9775"}],"wp:attachment":[{"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/media?parent=9248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/categories?post=9248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/best-of-high-tech.com\/fr\/wp-json\/wp\/v2\/tags?post=9248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}