{"id":10470,"date":"2022-11-14T06:57:11","date_gmt":"2022-11-14T05:57:11","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10470"},"modified":"2022-11-12T20:09:49","modified_gmt":"2022-11-12T19:09:49","slug":"excel-figer-les-volets","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10470","title":{"rendered":"Excel : figer les volets"},"content":{"rendered":"<p style=\"text-align: justify;\">L\u2019utilisateur perd vite de vue les ent\u00eates de colonnes et de lignes d\u00e8s lors qu\u2019il descend dans les profondeurs de tableaux de donn\u00e9es tr\u00e8s \u00e9tendus.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10472\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-VOLETS2.png\" alt=\"XL VOLETS2\" width=\"427\" height=\"265\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-VOLETS2.png 427w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-VOLETS2-300x186.png 300w\" sizes=\"auto, (max-width: 427px) 100vw, 427px\" \/><\/p>\n<p style=\"text-align: justify;\">Pour r\u00e9soudre cette difficult\u00e9, Excel propose de figer les volets.<\/p>\n<p style=\"text-align: justify;\">Mode op\u00e9ratoire :<\/p>\n<ul>\n<li style=\"text-align: justify;\">Cliquer sur une cellule :\n<ul>\n<li style=\"text-align: justify;\">Pour conserver les ent\u00eates de lignes : cliquer sur la cellule figurant sous les ent\u00eates en colonne A<\/li>\n<li style=\"text-align: justify;\">Pour conserver les ent\u00eates de colonnes : cliquer sur la cellule figurant \u00e0 droite des ent\u00eates en ligne 1<\/li>\n<li style=\"text-align: justify;\">Pour conserver les deux : cliquer sur la cellule imm\u00e9diatement en dessous et \u00e0 droite des ent\u00eates<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>Rendez-vous dans le menu Affichage puis cliquer sur Figer les volets.<\/li>\n<li style=\"text-align: justify;\">Lors du d\u00e9filement vers le bas les ent\u00eates restent affich\u00e9es :<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10471\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-VOLETS1.png\" alt=\"XL VOLETS1\" width=\"280\" height=\"153\"><\/p>\n<ul>\n<li style=\"text-align: justify;\">Pour supprimer les volets, refaire de m\u00eame puis Lib\u00e9rer les volets.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-10473\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-VOLETS3.png\" alt=\"XL VOLETS3\" width=\"386\" height=\"307\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-VOLETS3.png 386w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2022\/11\/XL-VOLETS3-300x239.png 300w\" sizes=\"auto, (max-width: 386px) 100vw, 386px\" \/><\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Approfondir le sujet :&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">Analyse de donn\u00e9es et automatisation<\/a>&nbsp;\/&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?glossary=excel\">Tout savoir sur Excel<\/a>&nbsp;\/&nbsp;<a title=\"S\u00e9rie d'articles Ma\u00eetriser Excel\" href=\"https:\/\/www.auditsi.eu\/?p=4475\">D\u00e9couvrir la s\u00e9rie d\u2019articles Ma\u00eetriser Excel<\/a><\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none; text-align: justify;\">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%20figer%20les%20volets\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>L\u2019utilisateur perd vite de vue les ent\u00eates de colonnes et de lignes d\u00e8s lors qu\u2019il descend dans les profondeurs de tableaux de donn\u00e9es tr\u00e8s \u00e9tendus. Pour r\u00e9soudre cette difficult\u00e9, Excel propose de figer les volets. Mode op\u00e9ratoire : Cliquer sur une cellule : Pour conserver les ent\u00eates de lignes : cliquer sur la cellule figurant &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10470\" class=\"more-link\">Continue reading &lsquo;Excel : figer les volets&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%20figer%20les%20volets\";<\/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":[1326],"tags":[1633,2775],"class_list":["post-10470","post","type-post","status-publish","format-standard","hentry","category-maitriser-excel","tag-excel","tag-volets"],"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\/10470","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=10470"}],"version-history":[{"count":2,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10470\/revisions"}],"predecessor-version":[{"id":10475,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10470\/revisions\/10475"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}