{"id":1221,"date":"2015-01-06T14:17:40","date_gmt":"2015-01-06T13:17:40","guid":{"rendered":"http:\/\/people.unil.ch\/jacquelinefrey\/?p=1221"},"modified":"2022-08-15T15:19:54","modified_gmt":"2022-08-15T13:19:54","slug":"excel-utiliser-lindex","status":"publish","type":"post","link":"https:\/\/people.unil.ch\/jacquelinefrey\/2015\/01\/excel-utiliser-lindex\/","title":{"rendered":"Excel &#8211; Utiliser l&rsquo;index"},"content":{"rendered":"<h4><strong>Contexte<\/strong><\/h4>\n<p>Entre le cappuccino et la galette des rois, quelqu&rsquo;un me dit \u00ab\u00a0c&rsquo;est bien dommage que dans Excel il n&rsquo;y ait pas la possibilit\u00e9 de disposer instantan\u00e9ment d&rsquo;un index comme dans FileMaker&#8230;\u00a0\u00bb\u00a0 Cette personne faisait r\u00e9f\u00e9rence \u00e0 la possibilit\u00e9 d&rsquo;obtenir dans une cellule &#8211; appelons-la A21 &#8211; la liste de toutes les donn\u00e9es saisies dans la colonne A.<\/p>\n<h4><strong>Solution<\/strong><\/h4>\n<ul>\n<li>Cliquez sur une cellule (dans mon exemple A21) situ\u00e9e dans une colonne contenant des donn\u00e9es<\/li>\n<li>Appuyez sur les touches Alt + Fl\u00e8che en bas; une liste s&rsquo;affiche alors vous permettant :\n<ul>\n<li>de consulter la liste des entr\u00e9es class\u00e9es par ordre alphab\u00e9tique<\/li>\n<li>de choisir une valeur au lieu de la taper<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2015\/01\/index.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1225\" src=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2015\/01\/index.png\" alt=\"index\" width=\"200\" height=\"335\" srcset=\"https:\/\/people.unil.ch\/jacquelinefrey\/files\/2015\/01\/index.png 200w, https:\/\/people.unil.ch\/jacquelinefrey\/files\/2015\/01\/index-179x300.png 179w\" sizes=\"auto, (max-width: 200px) 100vw, 200px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contexte Entre le cappuccino et la galette des rois, quelqu&rsquo;un me dit \u00ab\u00a0c&rsquo;est bien dommage que dans Excel il n&rsquo;y ait pas la possibilit\u00e9 de disposer instantan\u00e9ment d&rsquo;un&hellip;<\/p>\n","protected":false},"author":83,"featured_media":3787,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"template-full-width-cover.php","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[4],"tags":[41],"class_list":{"0":"post-1221","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-excel","8":"tag-raccourci-clavier"},"_links":{"self":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/comments?post=1221"}],"version-history":[{"count":0,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/posts\/1221\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media\/3787"}],"wp:attachment":[{"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/media?parent=1221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/categories?post=1221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/people.unil.ch\/jacquelinefrey\/wp-json\/wp\/v2\/tags?post=1221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}