{"id":36,"date":"2020-01-29T23:53:47","date_gmt":"2020-01-29T22:53:47","guid":{"rendered":"http:\/\/excel4ever.fr\/?p=36"},"modified":"2021-09-22T23:38:19","modified_gmt":"2021-09-22T21:38:19","slug":"plage-de-donnees","status":"publish","type":"post","link":"https:\/\/excel4ever.fr\/index.php\/2020\/01\/29\/plage-de-donnees\/","title":{"rendered":"La plage de donn\u00e9es"},"content":{"rendered":"\n<p>La <strong>plage de donn\u00e9es<\/strong> repr\u00e9sente une cellule, un groupe de cellules ou plusieurs groupes de cellules dans la feuille.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Exemple de plage de donn\u00e9es contenant une seule cellule :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"469\" height=\"179\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-005.png\" alt=\"\" class=\"wp-image-279\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-005.png 469w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-005-300x114.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-005-250x95.png 250w\" sizes=\"auto, (max-width: 469px) 100vw, 469px\" \/><\/figure>\n\n\n\n<p><em>Pour saisir une plage avec plusieurs cellules, il faut s\u00e9parer l&rsquo;\u00e9l\u00e9ment du d\u00e9but et l&rsquo;\u00e9l\u00e9ment de fin par le s\u00e9parateur &lt; <strong>:<\/strong> ><\/em><\/p>\n\n\n\n<p>Exemple de plage de donn\u00e9es contenant 9 cellules, \u00e0 partir de la cellule <strong>B4 <\/strong>jusqu&rsquo;\u00e0 la cellule <strong>D6 <\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"609\" height=\"208\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-001.png\" alt=\"\" class=\"wp-image-280\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-001.png 609w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-001-300x102.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-001-250x85.png 250w\" sizes=\"auto, (max-width: 609px) 100vw, 609px\" \/><\/figure>\n\n\n\n<p>Exemple de plage de donn\u00e9es contenant les colonnes <strong>A<\/strong>, <strong>B<\/strong> et <strong>C<\/strong> :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"469\" height=\"379\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-002.png\" alt=\"\" class=\"wp-image-281\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-002.png 469w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-002-300x242.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-002-250x202.png 250w\" sizes=\"auto, (max-width: 469px) 100vw, 469px\" \/><\/figure>\n\n\n\n<p>Exemple de plage de donn\u00e9es contenant les lignes <strong>1<\/strong>, <strong>2<\/strong> et <strong>3<\/strong> :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"686\" height=\"205\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-003.png\" alt=\"\" class=\"wp-image-282\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-003.png 686w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-003-300x90.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-003-250x75.png 250w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/figure>\n\n\n\n<p>Exemple d&rsquo;une formule utilisant deux plages de donn\u00e9es :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"634\" height=\"212\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-004.png\" alt=\"\" class=\"wp-image-283\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-004.png 634w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-004-300x100.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0015-004-250x84.png 250w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>La plage de donn\u00e9es repr\u00e9sente une cellule, un groupe de cellules ou plusieurs groupes de cellules dans la feuille. Exemple de plage de donn\u00e9es contenant une seule cellule : Pour saisir une plage avec plusieurs cellules, il faut s\u00e9parer l&rsquo;\u00e9l\u00e9ment du d\u00e9but et l&rsquo;\u00e9l\u00e9ment de fin par le s\u00e9parateur &lt; : > Exemple de plage [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-36","post","type-post","status-publish","format-standard","hentry","category-la-base"],"_links":{"self":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/36","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=36"}],"version-history":[{"count":4,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/36\/revisions"}],"predecessor-version":[{"id":284,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/36\/revisions\/284"}],"wp:attachment":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/media?parent=36"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/categories?post=36"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/tags?post=36"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}