{"id":4735,"date":"2021-04-22T17:30:39","date_gmt":"2021-04-22T15:30:39","guid":{"rendered":"https:\/\/www.amg-informatique.fr\/w2\/formation\/?p=4735"},"modified":"2021-10-12T11:59:08","modified_gmt":"2021-10-12T09:59:08","slug":"lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel","status":"publish","type":"post","link":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/","title":{"rendered":"[L&rsquo;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:0px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-two\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:24;line-height:1.31;\"><strong>[L&rsquo;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel<\/strong><\/h2><\/div><div class=\"fusion-text fusion-text-1\"><p>Aujourd\u2019hui, c\u2019est jeudi et donc l\u2019astuce de la semaine ! Pour cette nouvelle \u00e9dition, l\u2019\u00e9quipe AMG Informatique vous d\u00e9voile le raccourci clavier. Celui-ci va vous permettre de r\u00e9aliser un retour \u00e0 la ligne dans une cellule Excel !<\/p>\n<p><strong>Vous souhaitez suivre une formation sur Excel, \u00e9ligible au CPF ?<\/strong><br \/>\nConsultez notre <a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-initiation\/\" target=\"_blank\" rel=\"noopener\">programme de formation Excel initiation<\/a>.<\/p>\n<\/div><div class=\"fusion-video fusion-youtube\" style=\"--awb-max-width:1000px;--awb-max-height:600px;--awb-align-self:flex-start;--awb-width:100%;\" data-autoplay=\"1\"><div class=\"video-shortcode\"><div class=\"fluid-width-video-wrapper\" style=\"padding-top:60%;\" ><iframe title=\"YouTube video player 1\" src=\"https:\/\/www.youtube.com\/embed\/mc202yI5thw?wmode=transparent&autoplay=0\" width=\"1000\" height=\"600\" allowfullscreen allow=\"autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture;\"><\/iframe><\/div><\/div><\/div><div class=\"fusion-separator fusion-full-width-sep\" style=\"align-self: center;margin-left: auto;margin-right: auto;margin-top:20px;margin-bottom:20px;width:100%;\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 fusion-flex-container hundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-padding-top:20px;--awb-padding-bottom:20px;--awb-background-color:#f6f6f6;--awb-background-image:linear-gradient(241deg, #7d318e 0%,#c1587e 100%);--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"width:104% !important;max-width:104% !important;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_3 1_3 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:33.333333333333%;--awb-margin-top-large:0px;--awb-spacing-right-large:5.76%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:5.76%;--awb-width-medium:33.333333333333%;--awb-order-medium:0;--awb-spacing-right-medium:5.76%;--awb-spacing-left-medium:5.76%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-center fusion-content-layout-column\"><div class=\"fusion-lottie fusion-lottie-1\" data-id=\"1\"><div class=\"fusion-lottie-animation\" data-path=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/2021\/03\/excel.json\" data-loop=\"1\" data-reverse=\"0\" data-speed=\"1\" data-trigger=\"none\"><lottie-player loop=\"1\" speed=\"1\"><\/lottie-player><\/div><\/div><\/div><\/div><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_2_3 2_3 fusion-flex-column\" style=\"--awb-padding-top:30px;--awb-padding-right:30px;--awb-padding-bottom:30px;--awb-padding-left:30px;--awb-overflow:hidden;--awb-bg-color:#ffffff;--awb-bg-color-hover:#ffffff;--awb-bg-size:cover;--awb-border-radius:15px 15px 15px 15px;--awb-width-large:66.666666666667%;--awb-margin-top-large:12px;--awb-spacing-right-large:2.88%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:2.88%;--awb-width-medium:66.666666666667%;--awb-order-medium:0;--awb-spacing-right-medium:2.88%;--awb-spacing-left-medium:2.88%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-center fusion-content-layout-column\"><div class=\"fusion-title title fusion-title-2 fusion-sep-none fusion-title-text fusion-title-size-two\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:24;line-height:1.31;\"><strong><span style=\"color: #c72a2d;\">Vous souhaitez b\u00e9n\u00e9ficier d&rsquo;une formation Excel ?<\/span><\/strong><\/h2><\/div><div class=\"fusion-text fusion-text-2\"><p><strong>AMG Formation<\/strong> vous propose des <strong>formations Excel \u00e9ligibles au CPF<\/strong>, en pr\u00e9sentiel (dans nos locaux de Dijon ou sur site), \u00e0 distance ou sur nos plateformes d\u2019e-learning :<\/p>\n<ul>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-initiation\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel initiation<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-intermediaire\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel interm\u00e9diaire<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-perfectionnement\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel perfectionnement<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-gerer-un-planning\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel &#8211; G\u00e9rer un planning<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-simulations-et-previsions\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel &#8211; Simulations et pr\u00e9visions<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-tableaux-de-bord-et-syntheses\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel &#8211; Tableaux de bord et synth\u00e8ses<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-macros-et-automatisation\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel &#8211; Macros et automatisation<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<li><a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/nos-formations-informatiques-en-presentiel\/excel-programmation-vba\/\" target=\"_blank\" rel=\"noopener\"><strong>Formation Excel &#8211; Programmation VBA<\/strong> (formation \u00e9ligible au CPF)<\/a><\/li>\n<\/ul>\n<p><strong>AMG Formation<\/strong> est un <strong>organisme de formation certifi\u00e9 QUALIOPI et DATADOCK \u00e0 Dijon<\/strong>. En tant que<strong> centre agr\u00e9\u00e9 TOSA, ICDL et ENI,<\/strong> nos formations sont certifiantes.<br \/>\nElles s\u2019adressent \u00e0 tous types de publics (salari\u00e9s des secteurs priv\u00e9s, publics ou associatifs, demandeurs d\u2019emploi, agents des collectivit\u00e9s) sans condition d\u2019\u00e2ge.<\/p>\n<\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 fusion-flex-container nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"--awb-border-radius-top-left:0px;--awb-border-radius-top-right:0px;--awb-border-radius-bottom-right:0px;--awb-border-radius-bottom-left:0px;--awb-flex-wrap:wrap;\" ><div class=\"fusion-builder-row fusion-row fusion-flex-align-items-flex-start fusion-flex-content-wrap\" style=\"max-width:1216.8px;margin-left: calc(-4% \/ 2 );margin-right: calc(-4% \/ 2 );\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-3 fusion_builder_column_1_1 1_1 fusion-flex-column\" style=\"--awb-bg-size:cover;--awb-width-large:100%;--awb-margin-top-large:0px;--awb-spacing-right-large:1.92%;--awb-margin-bottom-large:20px;--awb-spacing-left-large:1.92%;--awb-width-medium:100%;--awb-order-medium:0;--awb-spacing-right-medium:1.92%;--awb-spacing-left-medium:1.92%;--awb-width-small:100%;--awb-order-small:0;--awb-spacing-right-small:1.92%;--awb-spacing-left-small:1.92%;\"><div class=\"fusion-column-wrapper fusion-column-has-shadow fusion-flex-justify-content-flex-start fusion-content-layout-column\"><div class=\"fusion-separator fusion-full-width-sep\" style=\"align-self: center;margin-left: auto;margin-right: auto;margin-top:20px;margin-bottom:20px;width:100%;\"><\/div><div class=\"fusion-title title fusion-title-3 fusion-sep-none fusion-title-text fusion-title-size-two\"><h2 class=\"fusion-title-heading title-heading-left fusion-responsive-typography-calculated\" style=\"margin:0;--fontSize:24;line-height:1.31;\"><strong>[Tutoriel d\u00e9taill\u00e9] Effectuer un retour \u00e0 la ligne dans une cellule Excel<\/strong><\/h2><\/div><div class=\"fusion-text fusion-text-3\"><p>Envie d&rsquo;effectuer un retour \u00e0 la ligne ? C&rsquo;est tr\u00e8s simple et nous allons vous donner la solution !<\/p>\n<p>Ce tutoriel vous permettra d&rsquo;apprendre rapidement \u00e0 effectuer un retour \u00e0 la ligne avec seulement 2 touches de clavier. Rien de bien compliqu\u00e9, le plus dur \u00e9tant de trouver le contenu que vous allez saisir dans votre cellule.<\/p>\n<p>N&rsquo;h\u00e9sitez pas \u00e0 donner votre avis concernant ce tutoriel \u00e0 travers nos r\u00e9seaux sociaux (voir ci-dessous).<\/p>\n<p>Voici les quelques \u00e9tapes que vous pouvez retrouver dans la vid\u00e9o ci-dessus\u00a0:<\/p>\n<h3>1) Tout d\u2019abord, ouvrez un document Excel.<\/h3>\n<\/div><div class=\"fusion-image-element \" style=\"--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><img decoding=\"async\" width=\"1000\" height=\"498\" alt=\"Ouvrir une cellule Excel\" title=\"Classeur Excel\" src=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-1-BR-1.jpg\" class=\"img-responsive wp-image-4749\" srcset=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-1-BR-1-200x100.jpg 200w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-1-BR-1-400x199.jpg 400w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-1-BR-1-600x299.jpg 600w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-1-BR-1-800x398.jpg 800w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-1-BR-1.jpg 1000w\" sizes=\"(max-width: 640px) 100vw, 1000px\" \/><\/span><\/div><div class=\"fusion-text fusion-text-4\"><h3>2) Ensuite, cliquez sur la cellule de votre choix.<\/h3>\n<p>Comme vous pouvez le constater, nous avons choisi la cellule C7 pour illustrer cet exemple.<\/p>\n<p>Puis, commencez \u00e0 \u00e9crire votre texte ou votre formule.<\/p>\n<\/div><div class=\"fusion-image-element \" style=\"--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-2 hover-type-none\"><img decoding=\"async\" width=\"1000\" height=\"499\" alt=\"Cliquez sur une cellule Excel\" title=\"Capture retour \u00e0 la ligne\" src=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-br-1.jpg\" class=\"img-responsive wp-image-4750\" srcset=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-br-1-200x100.jpg 200w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-br-1-400x200.jpg 400w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-br-1-600x299.jpg 600w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-br-1-800x399.jpg 800w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-br-1.jpg 1000w\" sizes=\"(max-width: 640px) 100vw, 1000px\" \/><\/span><\/div><div class=\"fusion-text fusion-text-5\"><h3>3) Apr\u00e8s, tapez simultan\u00e9ment sur les touches \u00ab Alt \u00bb et \u00ab Entr\u00e9e \u00bb .<\/h3>\n<p>Ceci va permettre d\u2019appliquer le retour \u00e0 la ligne dans votre cellule Excel.<\/p>\n<\/div><div class=\"fusion-image-element \" style=\"--awb-max-width:1000px;--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-3 hover-type-none\"><img decoding=\"async\" width=\"1644\" height=\"535\" alt=\"clavier\" title=\"Clavier retour \u00e0 la ligne\" src=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Clavier-retour-a-la-ligne.jpg\" class=\"img-responsive wp-image-4748\" srcset=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Clavier-retour-a-la-ligne-200x65.jpg 200w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Clavier-retour-a-la-ligne-400x130.jpg 400w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Clavier-retour-a-la-ligne-600x195.jpg 600w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Clavier-retour-a-la-ligne-800x260.jpg 800w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Clavier-retour-a-la-ligne-1200x391.jpg 1200w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Clavier-retour-a-la-ligne.jpg 1644w\" sizes=\"(max-width: 640px) 100vw, 1200px\" \/><\/span><\/div><div class=\"fusion-text fusion-text-6\"><p>Ce sont les deux touches entour\u00e9es en rouge ci-dessus. \u00c0 l\u2019issue de cette op\u00e9ration, le r\u00e9sultat va s\u2019appliquer dans votre cellule.<\/p>\n<\/div><div class=\"fusion-text fusion-text-7\"><h3>4) Voil\u00e0 le r\u00e9sultat !<\/h3>\n<p>Enfin, vous pourrez saisir la suite de votre contenu \u00e0 la ligne de votre cellule !<\/p>\n<\/div><div class=\"fusion-image-element \" style=\"--awb-caption-title-font-family:var(--h2_typography-font-family);--awb-caption-title-font-weight:var(--h2_typography-font-weight);--awb-caption-title-font-style:var(--h2_typography-font-style);--awb-caption-title-size:var(--h2_typography-font-size);--awb-caption-title-transform:var(--h2_typography-text-transform);--awb-caption-title-line-height:var(--h2_typography-line-height);--awb-caption-title-letter-spacing:var(--h2_typography-letter-spacing);\"><span class=\" fusion-imageframe imageframe-none imageframe-4 hover-type-none\"><img decoding=\"async\" width=\"1000\" height=\"499\" alt=\"Voici le r\u00e9sultat\" title=\"Image retour \u00e0 la ligne\" src=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-2-br-1.jpg\" class=\"img-responsive wp-image-4751\" srcset=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-2-br-1-200x100.jpg 200w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-2-br-1-400x200.jpg 400w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-2-br-1-600x299.jpg 600w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-2-br-1-800x399.jpg 800w, https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/Capture-retour-a-la-ligne-2-br-1.jpg 1000w\" sizes=\"(max-width: 640px) 100vw, 1000px\" \/><\/span><\/div><div class=\"fusion-text fusion-text-8\"><p>Voil\u00e0 c\u2019est tout pour cette semaine\u00a0! Rendez-vous la semaine prochaine pour une nouvelle astuce avec AMG Informatique. Pour consulter les astuces pr\u00e9c\u00e9dentes, n\u2019h\u00e9sitez pas \u00e0 regarder nos diff\u00e9rents r\u00e9seaux sociaux (<a href=\"https:\/\/fr.linkedin.com\/company\/amg-informatique\" target=\"_blank\" rel=\"noopener\">LinkedIn<\/a>, <a href=\"https:\/\/www.facebook.com\/AMG.INFORMATIQUE\" target=\"_blank\" rel=\"noopener\">Facebook<\/a>,<a href=\"https:\/\/twitter.com\/AMGINFORMATIQUE\" target=\"_blank\" rel=\"noopener\"> Twitter<\/a> et <a href=\"https:\/\/www.youtube.com\/channel\/UC33XmIoOAE9qyCjb5eHUUTA\" target=\"_blank\" rel=\"noopener\">YouTube<\/a>) et dans la rubrique Formation, dans l\u2019onglet <a href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/actualites-2\/\" target=\"_blank\" rel=\"noopener\">Actualit\u00e9s<\/a> de notre site internet.<\/p>\n<\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[32,21,24,22,23],"class_list":["post-4735","post","type-post","status-publish","format-standard","hentry","category-formations-bureautiques","tag-astuce","tag-excel","tag-formation","tag-retour-a-la-ligne","tag-tutoriel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>[L&#039;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel - AMG Formation<\/title>\n<meta name=\"description\" content=\"AMG Formation vous d\u00e9voile l&#039;astuce permettant de r\u00e9aliser un retour \u00e0 la ligne dans une cellule Excel. Centre de formation agr\u00e9\u00e9 \u00e0 Dijon\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[L&#039;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel - AMG Formation\" \/>\n<meta property=\"og:description\" content=\"AMG Formation vous d\u00e9voile l&#039;astuce permettant de r\u00e9aliser un retour \u00e0 la ligne dans une cellule Excel. Centre de formation agr\u00e9\u00e9 \u00e0 Dijon\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"AMG Formation\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/fr-fr.facebook.com\/AMG.INFORMATIQUE\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-22T15:30:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-12T09:59:08+00:00\" \/>\n<meta name=\"author\" content=\"Fr\u00e9d\u00e9ric PINHEIRO\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fr\u00e9d\u00e9ric PINHEIRO\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/\"},\"author\":{\"name\":\"Fr\u00e9d\u00e9ric PINHEIRO\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#\\\/schema\\\/person\\\/84e5bd4c68650217ef0caef36865e3c6\"},\"headline\":\"[L&rsquo;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel\",\"datePublished\":\"2021-04-22T15:30:39+00:00\",\"dateModified\":\"2021-10-12T09:59:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/\"},\"wordCount\":3941,\"publisher\":{\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#organization\"},\"keywords\":[\"astuce\",\"excel\",\"formation\",\"retour \u00e0 la ligne\",\"tutoriel\"],\"articleSection\":[\"Formations bureautiques\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/\",\"url\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/\",\"name\":\"[L'astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel - AMG Formation\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#website\"},\"datePublished\":\"2021-04-22T15:30:39+00:00\",\"dateModified\":\"2021-10-12T09:59:08+00:00\",\"description\":\"AMG Formation vous d\u00e9voile l'astuce permettant de r\u00e9aliser un retour \u00e0 la ligne dans une cellule Excel. Centre de formation agr\u00e9\u00e9 \u00e0 Dijon\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[L&rsquo;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#website\",\"url\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/\",\"name\":\"AMG Formation\",\"description\":\"Centre de formation \u00e0 Dijon\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#organization\",\"name\":\"AMG Formation Dijon\",\"url\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/logo-amg-formation.png\",\"contentUrl\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/wp-content\\\/uploads\\\/2021\\\/03\\\/logo-amg-formation.png\",\"width\":200,\"height\":70,\"caption\":\"AMG Formation Dijon\"},\"image\":{\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/fr-fr.facebook.com\\\/AMG.INFORMATIQUE\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/10596945\\\/admin\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/#\\\/schema\\\/person\\\/84e5bd4c68650217ef0caef36865e3c6\",\"name\":\"Fr\u00e9d\u00e9ric PINHEIRO\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a038a337a9e93bb21b11baf3f3f7e46de3a269dc6a2c84e5b8154ce875ce8fe8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a038a337a9e93bb21b11baf3f3f7e46de3a269dc6a2c84e5b8154ce875ce8fe8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a038a337a9e93bb21b11baf3f3f7e46de3a269dc6a2c84e5b8154ce875ce8fe8?s=96&d=mm&r=g\",\"caption\":\"Fr\u00e9d\u00e9ric PINHEIRO\"},\"url\":\"https:\\\/\\\/www.amg-informatique.fr\\\/w2\\\/formation\\\/author\\\/fredamg\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[L'astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel - AMG Formation","description":"AMG Formation vous d\u00e9voile l'astuce permettant de r\u00e9aliser un retour \u00e0 la ligne dans une cellule Excel. Centre de formation agr\u00e9\u00e9 \u00e0 Dijon","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:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/","og_locale":"fr_FR","og_type":"article","og_title":"[L'astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel - AMG Formation","og_description":"AMG Formation vous d\u00e9voile l'astuce permettant de r\u00e9aliser un retour \u00e0 la ligne dans une cellule Excel. Centre de formation agr\u00e9\u00e9 \u00e0 Dijon","og_url":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/","og_site_name":"AMG Formation","article_publisher":"https:\/\/fr-fr.facebook.com\/AMG.INFORMATIQUE","article_published_time":"2021-04-22T15:30:39+00:00","article_modified_time":"2021-10-12T09:59:08+00:00","author":"Fr\u00e9d\u00e9ric PINHEIRO","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Fr\u00e9d\u00e9ric PINHEIRO","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/#article","isPartOf":{"@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/"},"author":{"name":"Fr\u00e9d\u00e9ric PINHEIRO","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#\/schema\/person\/84e5bd4c68650217ef0caef36865e3c6"},"headline":"[L&rsquo;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel","datePublished":"2021-04-22T15:30:39+00:00","dateModified":"2021-10-12T09:59:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/"},"wordCount":3941,"publisher":{"@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#organization"},"keywords":["astuce","excel","formation","retour \u00e0 la ligne","tutoriel"],"articleSection":["Formations bureautiques"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/","url":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/","name":"[L'astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel - AMG Formation","isPartOf":{"@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#website"},"datePublished":"2021-04-22T15:30:39+00:00","dateModified":"2021-10-12T09:59:08+00:00","description":"AMG Formation vous d\u00e9voile l'astuce permettant de r\u00e9aliser un retour \u00e0 la ligne dans une cellule Excel. Centre de formation agr\u00e9\u00e9 \u00e0 Dijon","breadcrumb":{"@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/lastuce-du-jeudi-realiser-un-retour-a-la-ligne-sur-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.amg-informatique.fr\/w2\/formation\/"},{"@type":"ListItem","position":2,"name":"[L&rsquo;astuce du jeudi] R\u00e9aliser un retour \u00e0 la ligne sur Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#website","url":"https:\/\/www.amg-informatique.fr\/w2\/formation\/","name":"AMG Formation","description":"Centre de formation \u00e0 Dijon","publisher":{"@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.amg-informatique.fr\/w2\/formation\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#organization","name":"AMG Formation Dijon","url":"https:\/\/www.amg-informatique.fr\/w2\/formation\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#\/schema\/logo\/image\/","url":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/2021\/03\/logo-amg-formation.png","contentUrl":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-content\/uploads\/2021\/03\/logo-amg-formation.png","width":200,"height":70,"caption":"AMG Formation Dijon"},"image":{"@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/fr-fr.facebook.com\/AMG.INFORMATIQUE","https:\/\/www.linkedin.com\/company\/10596945\/admin\/"]},{"@type":"Person","@id":"https:\/\/www.amg-informatique.fr\/w2\/formation\/#\/schema\/person\/84e5bd4c68650217ef0caef36865e3c6","name":"Fr\u00e9d\u00e9ric PINHEIRO","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/a038a337a9e93bb21b11baf3f3f7e46de3a269dc6a2c84e5b8154ce875ce8fe8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a038a337a9e93bb21b11baf3f3f7e46de3a269dc6a2c84e5b8154ce875ce8fe8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a038a337a9e93bb21b11baf3f3f7e46de3a269dc6a2c84e5b8154ce875ce8fe8?s=96&d=mm&r=g","caption":"Fr\u00e9d\u00e9ric PINHEIRO"},"url":"https:\/\/www.amg-informatique.fr\/w2\/formation\/author\/fredamg\/"}]}},"_links":{"self":[{"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/posts\/4735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/comments?post=4735"}],"version-history":[{"count":24,"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/posts\/4735\/revisions"}],"predecessor-version":[{"id":5861,"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/posts\/4735\/revisions\/5861"}],"wp:attachment":[{"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/media?parent=4735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/categories?post=4735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amg-informatique.fr\/w2\/formation\/wp-json\/wp\/v2\/tags?post=4735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}