{"id":97,"date":"2020-03-10T22:06:04","date_gmt":"2020-03-10T21:06:04","guid":{"rendered":"http:\/\/excel4ever.fr\/?p=97"},"modified":"2020-03-12T00:39:36","modified_gmt":"2020-03-11T23:39:36","slug":"changer-la-taille-des-cellules","status":"publish","type":"post","link":"https:\/\/excel4ever.fr\/index.php\/2020\/03\/10\/changer-la-taille-des-cellules\/","title":{"rendered":"Changer la taille des cellules"},"content":{"rendered":"\n<p>Par exemple, prenons ce tableau :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"200\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-01.png\" alt=\"\" class=\"wp-image-126\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-01.png 355w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-01-300x169.png 300w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/figure><\/div>\n\n\n\n<p>On remarque tout de suite que les cellules ne sont pas adapt\u00e9es \u00e0 leur contenu, et que ce tableau n&rsquo;est pas tr\u00e8s sexy. Pour changer la taille des cellules, plusieurs possibilit\u00e9s. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">En \u00ab\u00a0Drag &amp; Drop\u00a0\u00bb<\/h2>\n\n\n\n<p>Place le curseur de la souris sur la ligne ou la colonne qui s\u00e9pare la cellule de la cellule suivante. Tu dois obtenir le curseur suivant :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-04.png\" alt=\"\" class=\"wp-image-127\" width=\"374\" height=\"250\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-04.png 455w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-04-300x200.png 300w\" sizes=\"auto, (max-width: 374px) 100vw, 374px\" \/><\/figure><\/div>\n\n\n\n<p>Ou alors ce curseur s&rsquo;il s&rsquo;agit des lignes :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"384\" height=\"224\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-05.png\" alt=\"\" class=\"wp-image-128\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-05.png 384w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-05-300x175.png 300w\" sizes=\"auto, (max-width: 384px) 100vw, 384px\" \/><\/figure><\/div>\n\n\n\n<p>Fais un clic gauche prolong\u00e9 et d\u00e9place le curseur. La cellule va se redimensionner au fur et \u00e0 mesure du d\u00e9placement. Rel\u00e2che le clic lorsque tu auras atteint la taille souhait\u00e9e.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">En choisissant la taille<\/h2>\n\n\n\n<p>Place le curseur de la souris sur la ligne ou sur la colonne pour obtenir le symbole suivant :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-11.png\" alt=\"\" class=\"wp-image-136\" width=\"461\" height=\"279\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-11.png 592w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-11-300x182.png 300w\" sizes=\"auto, (max-width: 461px) 100vw, 461px\" \/><\/figure><\/div>\n\n\n\n<p>Fais un clic droit. Un menu va s&rsquo;ouvrir, clique sur <span class=\"has-text-color has-vivid-cyan-blue-color\">Largeur de colonne<\/span> comme ceci :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-02.png\" alt=\"\" class=\"wp-image-130\" width=\"332\" height=\"357\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-02.png 342w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-02-279x300.png 279w\" sizes=\"auto, (max-width: 332px) 100vw, 332px\" \/><\/figure><\/div>\n\n\n\n<p>Si tu cliques droit sur une ligne, c&rsquo;est ce menu qui s&rsquo;ouvre avec l&rsquo;option <span class=\"has-text-color has-vivid-cyan-blue-color\">Hauteur de ligne<\/span> :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-03.png\" alt=\"\" class=\"wp-image-131\" width=\"328\" height=\"402\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-03.png 333w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-03-245x300.png 245w\" sizes=\"auto, (max-width: 328px) 100vw, 328px\" \/><\/figure><\/div>\n\n\n\n<p>Puis, Excel propose de saisir une valeur en largeur ou en hauteur :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-07.png\" alt=\"\" class=\"wp-image-132\" width=\"363\" height=\"342\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-07.png 391w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-07-300x282.png 300w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-08.png\" alt=\"\" class=\"wp-image-133\" width=\"325\" height=\"321\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-08.png 340w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-08-300x296.png 300w\" sizes=\"auto, (max-width: 325px) 100vw, 325px\" \/><\/figure><\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><em>En s\u00e9lectionnant plusieurs colonnes, la hauteur s&rsquo;applique \u00e0 toutes les colonnes s\u00e9lectionn\u00e9es. Cela permet d&rsquo;avoir une largeur identique et un tableau plus harmonieux.<\/em><\/p><\/blockquote>\n\n\n\n<p>Par exemple, une largeur de 30 appliqu\u00e9e \u00e0 une s\u00e9lection des 3 colonnes donne ce r\u00e9sultat :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"689\" height=\"224\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-10.png\" alt=\"\" class=\"wp-image-135\" srcset=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-10.png 689w, https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-10-300x98.png 300w\" sizes=\"auto, (max-width: 689px) 100vw, 689px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Ajuster automatiquement par rapport au contenu de la cellule<\/h2>\n\n\n\n<p>Comme pour la premi\u00e8re \u00e9tape \u00ab\u00a0Drag &amp; Drop\u00a0\u00bb, place le curseur de la souris entre deux cellules. Quand l&rsquo;icone de d\u00e9placement appara\u00eet, double clique. Excel dimensionnera la largeur automatiquement par rapport au contenu.<\/p>\n\n\n\n<p>Cela fonctionne aussi pour les lignes. On peut m\u00eame s\u00e9lectionner plusieurs colonnes et plusieurs lignes. Le redimensionnement s&rsquo;appliquera \u00e0 l&rsquo;ensemble des lignes et des colonnes s\u00e9lectionn\u00e9es.<\/p>\n\n\n\n<p>On se retrouve avec un tableau qui ressemble \u00e0 \u00e7a, beaucoup plus lisible :<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"287\" height=\"186\" src=\"https:\/\/excel4ever.fr\/wp-content\/uploads\/2020\/02\/0003-09.png\" alt=\"\" class=\"wp-image-134\"\/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Par exemple, prenons ce tableau : On remarque tout de suite que les cellules ne sont pas adapt\u00e9es \u00e0 leur contenu, et que ce tableau n&rsquo;est pas tr\u00e8s sexy. Pour changer la taille des cellules, plusieurs possibilit\u00e9s. En \u00ab\u00a0Drag &amp; Drop\u00a0\u00bb Place le curseur de la souris sur la ligne ou la colonne qui s\u00e9pare [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-97","post","type-post","status-publish","format-standard","hentry","category-les-fonctionnalites"],"_links":{"self":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/97","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=97"}],"version-history":[{"count":5,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/97\/revisions"}],"predecessor-version":[{"id":138,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/posts\/97\/revisions\/138"}],"wp:attachment":[{"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/media?parent=97"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/categories?post=97"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/excel4ever.fr\/index.php\/wp-json\/wp\/v2\/tags?post=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}