{"id":11398,"date":"2023-07-24T06:29:24","date_gmt":"2023-07-24T04:29:24","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=11398"},"modified":"2023-07-02T13:40:14","modified_gmt":"2023-07-02T11:40:14","slug":"excel-afficher-des-points-de-suite","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=11398","title":{"rendered":"Excel : afficher des points de suite"},"content":{"rendered":"<p style=\"text-align: justify;\">Les <strong>points de suite<\/strong> font partie des mises en forme qui facilitent la <strong>lisibilit\u00e9 d&#8217;un document<\/strong> en liant visuellement deux informations, par exemple dans une table des mati\u00e8res, en rapprochant un titre et son num\u00e9ro de page&#8230;<\/p>\n<p style=\"text-align: justify;\">La mise en oeuvre des points de suite avec Excel est tr\u00e8s simple et fait partie des <a href=\"https:\/\/www.auditsi.eu\/?p=8013\">formats personnalis\u00e9s<\/a>.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11401\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite.png\" alt=\"Excel Points de suite\" width=\"801\" height=\"578\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite.png 801w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite-300x216.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite-768x554.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite-730x527.png 730w\" sizes=\"auto, (max-width: 801px) 100vw, 801px\" \/><br \/>\nPour appliquer des points de suite \u00e0 une plage de cellules, la s\u00e9lectionner puis Accueil \/ Format \/ Format de cellule&#8230; Dans la fen\u00eatre Format de cellule, choisir la Cat\u00e9gorie &#8220;Personnalis\u00e9e&#8221; puis dans la zone de saisie Type, saisir la <strong>s\u00e9quence arobase ast\u00e9risque point (@*.)<\/strong> :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11403\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Format-Points-de-suite.png\" alt=\"Excel Format Points de suite\" width=\"564\" height=\"484\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Format-Points-de-suite.png 564w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Format-Points-de-suite-300x257.png 300w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/p>\n<p style=\"text-align: justify;\">Ceci fait, valider la saisie par le bouton OK. Les points de suite sont appliqu\u00e9s (ils apparaissent <strong>\u00e0 droite du texte<\/strong>).<\/p>\n<p style=\"text-align: justify;\">Pour appliquer les <strong>points de suite \u00e0 gauche du texte<\/strong>, la s\u00e9quence \u00e0 saisir est : <strong>*.@<\/strong><\/p>\n<p style=\"text-align: justify;\">Enfin, pour <strong>afficher un double point<\/strong> cadr\u00e9 \u00e0 droite \u00e0 la suite d&#8217;un texte, il faut saisir la s\u00e9quence : <strong>@* &#8220;:&#8221;<\/strong> (le double point est saisi entre guillemets, touche 3 du clavier alphanum\u00e9rique).<\/p>\n<p style=\"text-align: justify;\">En synth\u00e8se, les diff\u00e9rentes s\u00e9quences de mise en forme sont :<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11405\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite-Sequences.png\" alt=\"Excel Points de suite S\u00e9quences\" width=\"495\" height=\"182\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite-Sequences.png 495w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/07\/Excel-Points-de-suite-Sequences-300x110.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/p>\n<p style=\"text-align: justify;\">Pour aller plus loin : <a href=\"https:\/\/www.auditsi.eu\/?p=7998\">afficher ses donn\u00e9es en k\u20ac ou M\u20ac<\/a>.<\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet des formats personnalis\u00e9s (et bien d&#8217;autres choses) : <a href=\"https:\/\/www.auditsi.eu\/?p=10572\">Formation \u00e0 l&#8217;analyse de donn\u00e9es et \u00e0 l&#8217;automatisation (support gratuit)<\/a>.<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\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%20afficher%20des%20points%20de%20suite\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les points de suite font partie des mises en forme qui facilitent la lisibilit\u00e9 d&#8217;un document en liant visuellement deux informations, par exemple dans une table des mati\u00e8res, en rapprochant un titre et son num\u00e9ro de page&#8230; La mise en oeuvre des points de suite avec Excel est tr\u00e8s simple et fait partie des formats &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=11398\" class=\"more-link\">Continue reading &lsquo;Excel : afficher des points de suite&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%20afficher%20des%20points%20de%20suite\";<\/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":[48],"tags":[2940,2002,1999,1382,2941,11],"class_list":["post-11398","post","type-post","status-publish","format-standard","hentry","category-excel","tag-double-point","tag-format-de-cellule","tag-format-personnalise","tag-mise-en-forme","tag-points-de-suite","tag-scandales-financiers"],"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\/11398","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=11398"}],"version-history":[{"count":6,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/11398\/revisions"}],"predecessor-version":[{"id":11409,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/11398\/revisions\/11409"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}