{"id":262,"date":"2021-09-20T23:14:33","date_gmt":"2021-09-20T21:14:33","guid":{"rendered":"http:\/\/excel4ever.fr\/?p=262"},"modified":"2021-09-20T23:28:18","modified_gmt":"2021-09-20T21:28:18","slug":"afficher-les-numeros-de-colonne","status":"publish","type":"post","link":"https:\/\/excel4ever.fr\/index.php\/2021\/09\/20\/afficher-les-numeros-de-colonne\/","title":{"rendered":"Afficher les num\u00e9ros de colonne"},"content":{"rendered":"\n<p>Il y a deux fa\u00e7ons d&rsquo;afficher la num\u00e9rotation des colonnes dans Excel.<\/p>\n\n\n\n<p>La premi\u00e8re fa\u00e7on (qui est souvent le r\u00e9glage par d\u00e9faut) est la num\u00e9rotation par des lettres :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"646\" height=\"179\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-001.png\" alt=\"\" class=\"wp-image-263\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-001.png 646w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-001-300x83.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-001-250x69.png 250w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><figcaption><br>La deuxi\u00e8me fa\u00e7on est la num\u00e9rotation par des chiffres :<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"182\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-003.png\" alt=\"\" class=\"wp-image-265\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-003.png 647w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-003-300x84.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-003-250x70.png 250w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><\/figure>\n\n\n\n<p>Pour changer l&rsquo;affichage et afficher les num\u00e9ros au lieu des lettres, il faut aller dans les options puis cliquer sur le menu <strong>Formules<\/strong>. Ensuite, cocher la case qui s&rsquo;appelle <strong>Style de r\u00e9f\u00e9rence L1C1<\/strong> :<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"936\" height=\"346\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-002.png\" alt=\"\" class=\"wp-image-264\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-002.png 936w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-002-300x111.png 300w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-002-768x284.png 768w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2021\/09\/0013-002-250x92.png 250w\" sizes=\"auto, (max-width: 936px) 100vw, 936px\" \/><\/figure>\n\n\n\n<p>Une fois le changement valid\u00e9, la feuille appara\u00eet avec les num\u00e9ros de colonne. Il suffit de cocher\/d\u00e9cocher cette option pour passer d&rsquo;un affichage \u00e0 un autre.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Il y a deux fa\u00e7ons d&rsquo;afficher la num\u00e9rotation des colonnes dans Excel. La premi\u00e8re fa\u00e7on (qui est souvent le r\u00e9glage par d\u00e9faut) est la num\u00e9rotation par des lettres : Pour changer l&rsquo;affichage et afficher les num\u00e9ros au lieu des lettres, il faut aller dans les options puis cliquer sur le menu Formules. Ensuite, cocher la [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-262","post","type-post","status-publish","format-standard","hentry","category-la-base"],"_links":{"self":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/262","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=262"}],"version-history":[{"count":3,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/262\/revisions"}],"predecessor-version":[{"id":268,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/262\/revisions\/268"}],"wp:attachment":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/media?parent=262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/categories?post=262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/tags?post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}