{"id":162918,"date":"2022-05-18T09:03:30","date_gmt":"2022-05-18T08:03:30","guid":{"rendered":"https:\/\/datascientest.com\/?p=159300"},"modified":"2024-02-13T16:12:23","modified_gmt":"2024-02-13T16:12:23","slug":"aller-a-la-ligne-dans-une-cellule-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel","title":{"rendered":"Comment aller \u00e0 la ligne dans une cellule Excel ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"162918\" class=\"elementor elementor-162918\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2788444 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2788444\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f58b146\" data-id=\"f58b146\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-278dd0f elementor-widget elementor-widget-heading\" data-id=\"278dd0f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Aller \u00e0 la ligne dans une feuille de calcul Excel, rien de plus simple ! Il suffit d\u2019appuyer sur la touche \u00ab Entr\u00e9e \u00bb de votre clavier ou de s\u00e9lectionner la cellule d\u2019en dessous \u00e0 l\u2019aide de votre souris. Mais ce n\u2019est pas aussi \u00e9vident d\u2019aller \u00e0 la ligne \u00e0 l\u2019int\u00e9rieur d\u2019une cellule.\u00a0<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9a49d74 elementor-widget elementor-widget-text-editor\" data-id=\"9a49d74\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Ce tutoriel a pour objectif de vous de vous apprendre \u00e0 faire un retour \u00e0 la ligne dans une cellule Excel \u00e0 l\u2019aide de deux m\u00e9thodes diff\u00e9rentes : l\u2019utilisation d\u2019un <strong>raccourci clavier<\/strong> pour sauter une ou plusieurs lignes et\u00a0 l\u2019utilisation de <strong>la fonction Rechercher et remplacer<\/strong> pour ajouter un retour \u00e0 la ligne apr\u00e8s un caract\u00e8re sp\u00e9cifique.<\/p><p>Lorsque vous utilisez Excel pour <strong>stocker et manipuler des entr\u00e9es de texte<\/strong>, vous pouvez cr\u00e9er une nouvelle ligne pour une zone sp\u00e9cifique d&rsquo;une cha\u00eene de texte.\u00a0<\/p><p>Les <strong>\u00e9tiquettes d&rsquo;envoi<\/strong> ou les <strong>informations personnelles<\/strong> plac\u00e9es dans une seule cellule sont de bons exemples de texte \u00e0 plusieurs lignes.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-948925d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"948925d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-22bf9a7\" data-id=\"22bf9a7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-64578c3 elementor-widget elementor-widget-heading\" data-id=\"64578c3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">1\u02b3\u1d49 m\u00e9thode : Commencer une nouvelle ligne sur Excel <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d97cc2c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d97cc2c\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6e4e457\" data-id=\"6e4e457\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-543ae27 elementor-widget elementor-widget-text-editor\" data-id=\"543ae27\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Le moyen le plus simple et rapide d\u2019ajouter une nouvelle ligne dans une cellule Excel est d\u2019utiliser un raccourci clavier.<\/p><p>Pour <b>Windows<\/b> : <strong>Alt + Entr\u00e9e<\/strong> est le raccourci pour un saut de ligne.\u00a0<\/p><p>Pour <b>Mac : <\/b><strong>Ctrl + Option + Entr\u00e9e<\/strong> ou <strong>Ctrl + Cmd + Entr\u00e9e<\/strong> sont les raccourcis pour un saut de ligne.<\/p><p><strong>Option + Entr\u00e9e<\/strong> peut \u00e9galement \u00eatre utilis\u00e9 dans <a href=\"https:\/\/apps.apple.com\/fr\/app\/microsoft-excel\/id462058435?mt=12\">Excel 365 pour Mac<\/a>. Comme Option est l&rsquo;\u00e9quivalent Mac de la touche Alt de Windows, il semble que le raccourci original de <strong>Windows (Alt + Entr\u00e9e)<\/strong> fonctionne d\u00e9sormais \u00e9galement. Si cela ne fonctionne pas, utilisez les raccourcis Mac standards indiqu\u00e9s ci-dessus.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-deda9e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"deda9e4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-99fe23c\" data-id=\"99fe23c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8424412 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"8424412\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Se former en analyse de donn\u00e9es<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-49117f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"49117f7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8600e1e\" data-id=\"8600e1e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3575570 elementor-widget elementor-widget-heading\" data-id=\"3575570\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Astuce : <\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-373880d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"373880d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e210378\" data-id=\"e210378\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6afd400 elementor-widget elementor-widget-text-editor\" data-id=\"6afd400\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #000000;\">Pour que votre feuille de calcul soit plus agr\u00e9able \u00e0 consulter, utilisez la fonctionnalit\u00e9 <strong>\u201cRenvoyer \u00e0 la ligne automatiquement\u201d<\/strong> dans le groupe Alignement de l&rsquo;onglet Accueil afin de renvoyer \u00e0 la ligne un texte qui d\u00e9passe de la cellule. Vous pouvez modifier la largeur de la cellule pour d\u00e9finir l\u2019endroit o\u00f9 vous souhaitez revenir \u00e0 la ligne.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-adde0c2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"adde0c2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-68d7455\" data-id=\"68d7455\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b552d5b elementor-widget elementor-widget-image\" data-id=\"b552d5b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/excel-1.jpg\" title=\"\" alt=\"excel (1)\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6ef28f3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6ef28f3\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fc63458\" data-id=\"fc63458\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b215a5 elementor-widget elementor-widget-text-editor\" data-id=\"0b215a5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Attention! Cette fonctionnalit\u00e9 doit \u00eatre activ\u00e9e pour pouvoir utiliser la 2\u00e8me m\u00e9thode.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1debcc4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1debcc4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-194652f\" data-id=\"194652f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8374707 elementor-widget elementor-widget-heading\" data-id=\"8374707\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2\u1d49 m\u00e9thode : Comment cr\u00e9er une nouvelle ligne Excel en utilisant une bo\u00eete de dialogue [Ne fonctionne qu\u2019avec Windows]<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bfe9d56 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bfe9d56\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-56fd7a7\" data-id=\"56fd7a7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0c896b1 elementor-widget elementor-widget-text-editor\" data-id=\"0c896b1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Si le raccourci clavier est utile pour <strong>saisir manuellement de nouvelles lignes dans des cellules individuelles<\/strong>,\u00a0 la fonction Rechercher et remplacer est excellente pour rompre plusieurs lignes \u00e0 la fois et dans plusieurs cellules. Par exemple, lorsque vous avez une suite d\u2019\u00e9l\u00e9ments s\u00e9par\u00e9s par des espaces, des tirets, des slashs ou des virgules et que vous souhaitez les faire figurer les uns en dessous des autres, vous pouvez utiliser la fonction <strong>Rechercher <\/strong>et <strong>Remplacer<\/strong> pour remplacer chaque s\u00e9parateur par un retour \u00e0 la ligne.\u00a0\u00a0<\/p><p>Cette m\u00e9thode est vraiment utile si vous avez une longue liste d\u2019ingr\u00e9dients par exemple, que vous voulez pr\u00e9senter comme une liste de courses.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-21606dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"21606dd\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6a46e11\" data-id=\"6a46e11\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fe11fb1 elementor-widget elementor-widget-heading\" data-id=\"fe11fb1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Comment proc\u00e9der  :<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d033597 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d033597\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7c5bd8e\" data-id=\"7c5bd8e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-178cb69 elementor-widget elementor-widget-text-editor\" data-id=\"178cb69\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li><strong>S\u00e9lectionnez toutes les cellules <\/strong>dans lesquelles vous voulez commencer une ou plusieurs nouvelles lignes.<\/li><li>Ouvrez le volet \u201cRemplacer\u201d de l\u2019onglet <strong>\u201cRechercher et Remplacer\u201d<\/strong><\/li><li>Dans la bo\u00eete de dialogue \u201cRechercher\u201d: tapez <strong>\u201c, \u201c (virgule et espace)<\/strong>. Si vos cha\u00eenes de texte ne sont s\u00e9par\u00e9es que par des virgules sans espace tapez uniquement <strong>\u201c,\u201d (virgule seulement)<\/strong>.<\/li><\/ul><p>Dans le champ \u201cRemplacer par\u201d, appuyez sur <strong>CTRL + J<\/strong> pour ins\u00e9rer un retour chariot. Cela permet d\u2019ins\u00e9rer un saut de ligne \u00e0 la place de chaque virgule.<br \/>Il vous suffit simplement d\u2019appuyer sur remplacer pour appliquer les modifications.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-60cc8a0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"60cc8a0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2658050\" data-id=\"2658050\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8fbed2f elementor-widget elementor-widget-heading\" data-id=\"8fbed2f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Astuce :<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f4d07e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f4d07e6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-958b994\" data-id=\"958b994\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-93f58c0 elementor-widget elementor-widget-text-editor\" data-id=\"93f58c0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Vous pouvez utiliser la fonction <strong>CONCATENER<\/strong> ou l&rsquo;op\u00e9rateur de concat\u00e9nation\u00a0 (&amp;) pour combiner les donn\u00e9es de plusieurs cellules. La fonction <strong>CAR (10<\/strong>) quant \u00e0 elle,\u00a0 vous aidera \u00e0 ins\u00e9rer des sauts de ligne entre les paragraphes.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9d7d077 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9d7d077\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8a9f878\" data-id=\"8a9f878\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2629758 elementor-widget elementor-widget-heading\" data-id=\"2629758\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Exemple d\u2019utilisation de la fonction CAR :<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ceabcf1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ceabcf1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-aa01e82\" data-id=\"aa01e82\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cd6eef1 elementor-widget elementor-widget-text-editor\" data-id=\"cd6eef1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Dans l\u2019exemple ci-dessous, on revient successivement \u00e0 la ligne en combinant la fonction CAR(10) qui \u00e9quivaut \u00e0 un retour \u00e0 la ligne et <span style=\"color: #5e36f3\"><strong>\u201c&amp;\u201d<\/strong><\/span> afin de marquer la s\u00e9paration.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-89b1652 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89b1652\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c43638f\" data-id=\"c43638f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d680af elementor-widget elementor-widget-image\" data-id=\"6d680af\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/Excel-2.jpg\" title=\"\" alt=\"Excel (2)\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9f85d89 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9f85d89\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5718a61\" data-id=\"5718a61\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c1672e1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"c1672e1\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-power-bi\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir notre formation sur Power BI<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Aller \u00e0 la ligne dans une feuille de calcul Excel, rien de plus simple ! Il suffit d\u2019appuyer sur la touche \u00ab Entr\u00e9e \u00bb de votre clavier ou de s\u00e9lectionner la cellule d\u2019en dessous \u00e0 l\u2019aide de votre souris. Mais ce n\u2019est pas aussi \u00e9vident d\u2019aller \u00e0 la ligne \u00e0 l\u2019int\u00e9rieur d\u2019une cellule.\u00a0 Ce tutoriel [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":172524,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Comment aller \u00e0 la ligne dans une cellule Excel ?<\/title>\n<meta name=\"description\" content=\"Aller \u00e0 la ligne dans une cellule Excel peut sembler \u00eatre simple. Mais, la proc\u00e9dure est bien plus complexe. D\u00e9couvrez comment le faire.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment aller \u00e0 la ligne dans une cellule Excel ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-18T08:03:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-13T16:12:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/Capture-de\u0301cran-2022-08-17-a\u0300-10.15.27.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1593\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel\",\"url\":\"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel\",\"name\":\"Comment aller \u00e0 la ligne dans une cellule Excel ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2022-05-18T08:03:30+00:00\",\"dateModified\":\"2024-02-13T16:12:23+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Aller \u00e0 la ligne dans une cellule Excel peut sembler \u00eatre simple. Mais, la proc\u00e9dure est bien plus complexe. D\u00e9couvrez comment le faire.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment aller \u00e0 la ligne dans une cellule Excel ?","description":"Aller \u00e0 la ligne dans une cellule Excel peut sembler \u00eatre simple. Mais, la proc\u00e9dure est bien plus complexe. D\u00e9couvrez comment le faire.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel","og_locale":"fr_FR","og_type":"article","og_title":"Comment aller \u00e0 la ligne dans une cellule Excel ?","og_url":"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2022-05-18T08:03:30+00:00","article_modified_time":"2024-02-13T16:12:23+00:00","og_image":[{"width":2560,"height":1593,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2022\/05\/Capture-de\u0301cran-2022-08-17-a\u0300-10.15.27.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel","url":"https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel","name":"Comment aller \u00e0 la ligne dans une cellule Excel ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2022-05-18T08:03:30+00:00","dateModified":"2024-02-13T16:12:23+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Aller \u00e0 la ligne dans une cellule Excel peut sembler \u00eatre simple. Mais, la proc\u00e9dure est bien plus complexe. D\u00e9couvrez comment le faire.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/aller-a-la-ligne-dans-une-cellule-excel"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/162918"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=162918"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/162918\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/172524"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=162918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=162918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=162918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}