{"id":10456,"date":"2022-11-28T06:58:53","date_gmt":"2022-11-28T05:58:53","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10456"},"modified":"2022-11-12T20:22:50","modified_gmt":"2022-11-12T19:22:50","slug":"excel-nommer-des-cellules","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10456","title":{"rendered":"Excel : nommer des cellules"},"content":{"rendered":"<p style=\"text-align: justify;\">Pour faciliter la lecture des formules de calcul, il est possible de nommer des cellules ou des plages de cellules et de faire r\u00e9f\u00e9rence \u00e0 ces noms en lieu et place de ces cellules\/plages dans les formules.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10459\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS1.png\" alt=\"XL NOMS1\" width=\"236\" height=\"106\"><\/p>\n<p>Exemples de calcul avec des noms :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Plage nomm\u00e9e : =SOMME(HT) au lieu de =SOMME(A5:A20)<\/li>\n<li style=\"text-align: justify;\">Cellule nomm\u00e9e : =HT*Tx_TVA au lieu de =C5*D5<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Menu Formules :<\/p>\n<ul>\n<li style=\"text-align: justify;\">D\u00e9finir un nom :<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10458\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS2.png\" alt=\"XL NOMS2\" width=\"344\" height=\"264\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS2.png 344w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS2-300x230.png 300w\" sizes=\"auto, (max-width: 344px) 100vw, 344px\" \/><\/p>\n<ul>\n<li style=\"text-align: justify;\">Voir ou modifier un nom : Gestionnaire de noms<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10460\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS3.png\" alt=\"XL NOMS3\" width=\"483\" height=\"378\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS3.png 483w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS3-300x235.png 300w\" sizes=\"auto, (max-width: 483px) 100vw, 483px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10461\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS4.png\" alt=\"XL NOMS4\" width=\"322\" height=\"247\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS4.png 322w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-NOMS4-300x230.png 300w\" sizes=\"auto, (max-width: 322px) 100vw, 322px\" \/><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">2.13.0.0<\/div>\n<p>___<\/p>\n<p>Approfondir le sujet : <a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">Analyse de donn\u00e9es et automatisation<\/a> \/ <a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a>&nbsp;\/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\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%20nommer%20des%20cellules\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Pour faciliter la lecture des formules de calcul, il est possible de nommer des cellules ou des plages de cellules et de faire r\u00e9f\u00e9rence \u00e0 ces noms en lieu et place de ces cellules\/plages dans les formules. Exemples de calcul avec des noms : Plage nomm\u00e9e : =SOMME(HT) au lieu de =SOMME(A5:A20) Cellule nomm\u00e9e : &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10456\" class=\"more-link\">Continue reading &lsquo;Excel : nommer des cellules&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%20nommer%20des%20cellules\";<\/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":[1326],"tags":[1713,1633,1561],"class_list":["post-10456","post","type-post","status-publish","format-standard","hentry","category-maitriser-excel","tag-cellule","tag-excel","tag-plage-de-cellules"],"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\/10456","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=10456"}],"version-history":[{"count":3,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10456\/revisions"}],"predecessor-version":[{"id":10477,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10456\/revisions\/10477"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}