{"id":55,"date":"2021-09-22T00:33:24","date_gmt":"2021-09-21T22:33:24","guid":{"rendered":"http:\/\/excel4ever.fr\/?p=55"},"modified":"2021-09-22T00:33:24","modified_gmt":"2021-09-21T22:33:24","slug":"utiliser-les-noms-de-cellules-et-de-plages","status":"publish","type":"post","link":"https:\/\/excel4ever.fr\/index.php\/2021\/09\/22\/utiliser-les-noms-de-cellules-et-de-plages\/","title":{"rendered":"Utiliser les noms de cellules et de plages"},"content":{"rendered":"\n<p>Le nom d&rsquo;une cellule s&rsquo;affiche au dessus de la grille de donn\u00e9es sur la gauche.<\/p>\n\n\n\n<p>Par d\u00e9faut le nom d&rsquo;une cellule est constitu\u00e9 du num\u00e9ro de sa ligne suivi du num\u00e9ro de sa colonne. Par exemple, la cellule qui contient la marge de Janvier porte le nom <strong>D3<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"303\" height=\"347\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-001-1.png\" alt=\"\" class=\"wp-image-270\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-001-1.png 303w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-001-1-262x300.png 262w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-001-1-218x250.png 218w\" sizes=\"auto, (max-width: 303px) 100vw, 303px\" \/><\/figure>\n\n\n\n<p>Pour changer son nom, il suffit simplement de cliquer dans l&rsquo;\u00e9tiquette et d&rsquo;\u00e9crire le nouveau nom, par exemple ici je renomme la cellule <strong>D3 <\/strong>en <strong>marge_janvier<\/strong> :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-002-2.png\" alt=\"\" class=\"wp-image-273\" width=\"307\" height=\"352\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-002-2.png 307w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-002-2-262x300.png 262w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-002-2-218x250.png 218w\" sizes=\"auto, (max-width: 307px) 100vw, 307px\" \/><\/figure>\n\n\n\n<p>Le nouveau nom <strong>marge_janvier<\/strong> est utilisable dans les formules de la m\u00eame mani\u00e8re que l&rsquo;ancien nom :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"240\" height=\"121\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-003.png\" alt=\"\" class=\"wp-image-274\"\/><\/figure>\n\n\n\n<p>Cela peut s&rsquo;av\u00e9rer plus pratique de retenir des noms personnalis\u00e9s plut\u00f4t que les noms par d\u00e9faut.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Il est \u00e9galement possible de renommer toute une plage de cellules. Je d\u00e9cide de s\u00e9lectionner toutes les cellules de D3 \u00e0 D14 contenant les marges, et je nomme ce groupe de cellules <strong>marge_annuelle<\/strong> :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"359\" height=\"353\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-004.png\" alt=\"\" class=\"wp-image-275\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-004.png 359w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-004-300x295.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-004-250x246.png 250w\" sizes=\"auto, (max-width: 359px) 100vw, 359px\" \/><\/figure>\n\n\n\n<p>Je peux appeler ce groupe dans une formule afin de faire des calculs, par exemple la somme et la moyenne de cette plage de cellules pourraient s&rsquo;\u00e9crire comme ceci :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"304\" height=\"155\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-005.png\" alt=\"\" class=\"wp-image-276\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-005.png 304w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-005-300x153.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-005-250x127.png 250w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"297\" height=\"155\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-006.png\" alt=\"\" class=\"wp-image-277\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-006.png 297w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0014-006-250x130.png 250w\" sizes=\"auto, (max-width: 297px) 100vw, 297px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Le nom d&rsquo;une cellule s&rsquo;affiche au dessus de la grille de donn\u00e9es sur la gauche. Par d\u00e9faut le nom d&rsquo;une cellule est constitu\u00e9 du num\u00e9ro de sa ligne suivi du num\u00e9ro de sa colonne. Par exemple, la cellule qui contient la marge de Janvier porte le nom D3: Pour changer son nom, il suffit simplement [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-55","post","type-post","status-publish","format-standard","hentry","category-les-fonctionnalites"],"_links":{"self":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":2,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"predecessor-version":[{"id":278,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/55\/revisions\/278"}],"wp:attachment":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}