{"id":217645,"date":"2023-12-20T06:30:00","date_gmt":"2023-12-20T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=217645"},"modified":"2023-12-15T14:14:18","modified_gmt":"2023-12-15T14:14:18","slug":"fusionner-des-cellules-sur-excel","status":"publish","type":"post","link":"https:\/\/datascientest.com\/fusionner-des-cellules-sur-excel","title":{"rendered":"Comment fusionner des cellules sur Excel ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"217645\" class=\"elementor elementor-217645\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bc4da5a e-flex e-con-boxed e-con\" data-id=\"bc4da5a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-33aba17 elementor-widget elementor-widget-heading\" data-id=\"33aba17\" 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\">Pour traiter les donn\u00e9es, Microsoft Excel reste l\u2019outil incontournable. Avec ses multiples fonctionnalit\u00e9s, il facilite la pr\u00e9paration et la lecture des jeux de donn\u00e9es. Et parmi les fonctions \u00e0 ma\u00eetriser, il y a \u00e9videmment la fusion de cellules. <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-48e6fe3 elementor-widget elementor-widget-text-editor\" data-id=\"48e6fe3\" 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><span style=\"font-weight: 400;\">Si cette fonction est relativement basique, il existe aussi de nombreuses subtilit\u00e9s. Alors <\/span><b>comment fusionner des cellules avec Excel ? <\/b><span style=\"font-weight: 400;\">C\u2019est ce que nous allons voir dans cet article.\u00a0<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d216823 e-flex e-con-boxed e-con\" data-id=\"d216823\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0bab10c elementor-widget elementor-widget-heading\" data-id=\"0bab10c\" 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\">Comment fusionner des cellules sur Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba44c15 elementor-widget elementor-widget-text-editor\" data-id=\"ba44c15\" 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=\"font-weight: 400;\">Pour faciliter la lecture des tableaux, il est possible de fusionner plusieurs cellules en une seule sur Excel. Cette op\u00e9ration peut \u00eatre faite de mani\u00e8re verticale (plusieurs cellules d\u2019une m\u00eame colonne) ou horizontale (plusieurs cellules d\u2019une m\u00eame ligne). La fusion permet ainsi de <b>regrouper des donn\u00e9es couvrant plusieurs<\/b> <a href=\"https:\/\/datascientest.com\/comment-figer-une-ligne-sur-excel\">colonnes (ou lignes)<\/a> <b>au sein d&rsquo;un m\u00eame titre<\/b>.<\/span>\u00a0<\/p><p><span style=\"font-weight: 400;\">Voici les \u00e9tapes \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez les cellules \u00e0 fusionner ;<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Faites un clic droit et cliquez sur \u00ab\u00a0Fusionner les cellules\u00a0\u00bb OU cliquez sur le bouton \u00ab\u00a0fusionner et centrer\u00a0\u00bb dans l\u2019onglet \u00ab\u00a0Accueil\u00a0\u00bb.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-65c6f4c elementor-widget elementor-widget-text-editor\" data-id=\"65c6f4c\" 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=\"font-weight: 400;\">Vos cellules se regroupent automatiquement.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir<\/strong><\/span> : pour faciliter la fusion de cellules sur Excel, il est pr\u00e9f\u00e9rable que les cellules disposent d\u2019une bordure. Si ce n\u2019est pas le cas, vous pouvez toujours afficher le quadrillage. Pour cela, il suffit de cliquer sur <\/span><span style=\"font-weight: 400;\">: Outils de tableau &gt; Cr\u00e9ation &gt; Afficher le quadrillage.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-315d66e elementor-widget elementor-widget-image\" data-id=\"315d66e\" 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\" width=\"750\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel1.jpg\" class=\"attachment-full size-full wp-image-217683\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel1.jpg 750w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel1-300x200.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/>\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<div class=\"elementor-element elementor-element-0935bcd elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0935bcd\" 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-excel\">\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\">Suivre une formation pour apprendre Excel<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4020d38 e-flex e-con-boxed e-con\" data-id=\"4020d38\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2d05ed8 elementor-widget elementor-widget-heading\" data-id=\"2d05ed8\" 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\">Comment combiner les donn\u00e9es de plusieurs cellules sur Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f4f1b5 elementor-widget elementor-widget-text-editor\" data-id=\"4f4f1b5\" 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=\"font-weight: 400;\">S\u2019il est possible de fusionner des cellules avec Excel, il arrive aussi que les cellules \u00e0 combiner contiennent chacune des donn\u00e9es (textuelles ou num\u00e9riques). Dans cette hypoth\u00e8se, comment les fusionner sans perdre les jeux de donn\u00e9es existants ?\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Deux solutions s\u2019offrent \u00e0 vous. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6b8ba86 elementor-widget elementor-widget-heading\" data-id=\"6b8ba86\" 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-medium\">Le symbole Esperluette (&)<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e984e9 elementor-widget elementor-widget-text-editor\" data-id=\"3e984e9\" 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=\"font-weight: 400;\">Vous pouvez f<\/span><b>usionner des cellules sur Excel tout en conservant leur contenu gr\u00e2ce au symbole Esperluette. <\/b><span style=\"font-weight: 400;\">Voici la d\u00e9marche \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez une cellule dans laquelle vous souhaitez fusionner toutes les donn\u00e9es combin\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans cette m\u00eame cellule, tapez le symbole \u00e9gal (=), puis s\u00e9lectionner la premi\u00e8re cellule dont vous souhaitez int\u00e9grer les donn\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ajoutez le symbole et (&amp;), puis des guillemets, puis un espace, puis des guillemets, puis le symbole Esperluette (&amp;) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ajoutez la deuxi\u00e8me cellule dont vous souhaitez int\u00e9grer les donn\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Appuyez sur Entr\u00e9e.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-68004a2 elementor-widget elementor-widget-text-editor\" data-id=\"68004a2\" 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=\"font-weight: 400;\">Le r\u00e9sultat final peut ressembler \u00e0 cette formule : =A3<\/span><span style=\"font-weight: 400;\">&amp;\u00a0\u00bb \u00ab\u00a0&amp;B3&amp;\u00a0\u00bb \u00ab\u00a0&amp;C3 \u2026<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-377b185 elementor-widget elementor-widget-heading\" data-id=\"377b185\" 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-medium\">La fonction CONCAT<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-958b6e4 elementor-widget elementor-widget-text-editor\" data-id=\"958b6e4\" 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=\"font-weight: 400;\">Vous pouvez \u00e9galement combiner des donn\u00e9es r\u00e9parties sur plusieurs cellules Excel en utilisant la fonction CONCAT. Voici les d\u00e9marches \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez une cellule dans laquelle vous souhaitez ajouter toutes les donn\u00e9es combin\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans cette m\u00eame cellule, tapez le symbole \u00e9gal (=), puis CONCAT, puis une ouverture de parenth\u00e8se ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez la premi\u00e8re cellule dont vous souhaitez int\u00e9grer les donn\u00e9es ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ajoutez des points-virgules pour s\u00e9parer les cellules ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez les cellules suivantes que vous souhaitez int\u00e9grer ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Si besoin, utilisez les guillemets pour ajouter des espaces, de la ponctuation ou tout autre type de donn\u00e9e non contenu dans une cellule ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ajoutez une parenth\u00e8se de fermeture ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Appuyez sur Entr\u00e9e.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b636d49 elementor-widget elementor-widget-text-editor\" data-id=\"b636d49\" 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=\"font-weight: 400;\">Le r\u00e9sultat final peut ressembler \u00e0 cette formule : =CONCAT(\u201cNom \u201cA3<\/span><span style=\"font-weight: 400;\">;\u201dPr\u00e9nom \u201c;B3; \u201cVille \u201c;C3\u2026).\u00a0<\/span><\/p><p style=\"text-align: left;\"><span style=\"font-weight: 400;\">Cette option est particuli\u00e8rement int\u00e9ressante<\/span><b> si vous souhaitez ajouter du texte en plus des cellules \u00e0 fusionner. <\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9dbda78 elementor-widget elementor-widget-image\" data-id=\"9dbda78\" 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\" width=\"750\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel2.jpg\" class=\"attachment-full size-full wp-image-217687\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel2.jpg 750w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel2-300x200.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/>\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<div class=\"elementor-element elementor-element-fa27e27 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"fa27e27\" 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-excel\">\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\">Devenir un expert sur Excel<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-624c081 e-flex e-con-boxed e-con\" data-id=\"624c081\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6e651af elementor-widget elementor-widget-heading\" data-id=\"6e651af\" 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\">Comment annuler la fusion de cellule sur Excel ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21c9edb elementor-widget elementor-widget-text-editor\" data-id=\"21c9edb\" 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=\"font-weight: 400;\">SI les fusions de cellules sur Excel sont tr\u00e8s utiles, elles ne sont pas toujours pertinentes. Heureusement, il est possible d\u2019<\/span><b>annuler l\u2019op\u00e9ration en seulement quelques clics<\/b><span style=\"font-weight: 400;\">. Voici comment faire :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez les cellules \u00e0 d\u00e9fusionner :\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019onglet \u00ab\u00a0Accueil\u00a0\u00bb, cliquez sur la fl\u00e8che qui pointe vers le bas \u00e0 c\u00f4t\u00e9 de \u00ab\u00a0Fusionner et centrer\u00a0\u00bb<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Dissocier les cellules\u00a0\u00bb.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c1db5c elementor-widget elementor-widget-text-editor\" data-id=\"7c1db5c\" 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=\"font-weight: 400;\">Attention, il est seulement possible de dissocier des cellules pr\u00e9alablement fusionn\u00e9es.<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9f1b93d e-flex e-con-boxed e-con\" data-id=\"9f1b93d\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-176ca06 elementor-widget elementor-widget-heading\" data-id=\"176ca06\" 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\">Comment fusionner des cellules sur PowerPoint ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f08424 elementor-widget elementor-widget-text-editor\" data-id=\"4f08424\" 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=\"font-weight: 400;\">En plus de fusionner les cellules sur Excel, il est aussi possible de r\u00e9p\u00e9ter l\u2019op\u00e9ration sur PowerPoint. Cela vous permettra ainsi de <\/span><b>pr\u00e9senter des tableaux clairs et parfaitement compr\u00e9hensibles<\/b><span style=\"font-weight: 400;\"> pour votre audience.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici les d\u00e9marches \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez les cellules \u00e0 combiner sur votre diapositive (elles doivent \u00eatre contigu\u00ebs) ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">S\u00e9lectionnez l\u2019onglet Disposition ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rendez-vous dans le groupe Fusionner, et cliquez sur Fusionner les cellules.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4057daf elementor-widget elementor-widget-text-editor\" data-id=\"4057daf\" 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=\"font-weight: 400;\">Le tour est jou\u00e9. Dans cet onglet, vous pouvez \u00e9galement am\u00e9liorer l\u2019apparence de votre tableau, en testant diff\u00e9rents types de bordures, diff\u00e9rents alignements pour le contenu, etc.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Si vous souhaitez faire la d\u00e9marche inverse, il suffit de reprendre la m\u00eame manipulation. Mais \u00e0 la place de fusionner les cellules, cliquez sur \u00ab\u00a0Fractionner les cellules\u00a0\u00bb. Vous devrez ensuite pr\u00e9ciser le nombre de colonnes ou de lignes.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Il ne s\u2019agit ici que de quelques outils basiques des outils Microsoft. Si vous souhaitez exploiter de grands volumes de donn\u00e9es, il vous faudra ma\u00eetriser d\u2019autres fonctionnalit\u00e9s, et m\u00eame d\u2019autres outils. Pour cela, il convient de se former. C\u2019est justement possible avec DataScientest. <a href=\"https:\/\/datascientest.com\/formations-data\">D\u00e9couvrez nos formations !<\/a><\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6d3cb83 e-flex e-con-boxed e-con\" data-id=\"6d3cb83\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f6002b9 elementor-widget elementor-widget-heading\" data-id=\"f6002b9\" 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\">Ce qu\u2019il faut retenir<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-90f8435 elementor-widget elementor-widget-text-editor\" data-id=\"90f8435\" 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>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Fusionner des cellules sur Excel am\u00e9liore la lisibilit\u00e9 et la compr\u00e9hension des tableaux.\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Avec Excel, il est possible de fusionner des cellules, combiner leur contenu et dissocier des cellules pr\u00e9alablement fusionn\u00e9es.\u00a0<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Si cette fonction est indispensable pour le traitement des donn\u00e9es, il convient de ma\u00eetriser d\u2019autres <a href=\"https:\/\/datascientest.com\/formation-excel\">fonctions Excel<\/a> pour une analyse vraiment efficace.<\/span><\/li>\n<\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1642357 elementor-widget elementor-widget-image\" data-id=\"1642357\" 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\" width=\"750\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel3.jpg\" class=\"attachment-full size-full wp-image-217691\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel3.jpg 750w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel3-300x200.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/>\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<div class=\"elementor-element elementor-element-929e54c elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"929e54c\" 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-excel\">\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\">Commencer \u00e0 se former sur Excel<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a48de09 e-flex e-con-boxed e-con\" data-id=\"a48de09\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-995717b elementor-widget elementor-widget-html\" data-id=\"995717b\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fusionner des cellules sur Excel ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Pour faciliter la lecture des tableaux, il est possible de fusionner plusieurs cellules en une seule sur Excel. Cette op\u00e9ration peut \u00eatre faite de mani\u00e8re verticale (plusieurs cellules d\u2019une m\u00eame colonne) ou horizontale (plusieurs cellules d\u2019une m\u00eame ligne). La fusion permet ainsi de regrouper des donn\u00e9es couvrant plusieurs colonnes (ou lignes) au sein d'un m\u00eame titre.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment combiner les donn\u00e9es de plusieurs cellules sur Excel ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"S\u2019il est possible de fusionner des cellules avec Excel, il arrive aussi que les cellules \u00e0 combiner contiennent chacune des donn\u00e9es (textuelles ou num\u00e9riques). Dans cette hypoth\u00e8se, comment les fusionner sans perdre les jeux de donn\u00e9es existants ?\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fusionner des cellules sur PowerPoint ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"En plus de fusionner les cellules sur Excel, il est aussi possible de r\u00e9p\u00e9ter l\u2019op\u00e9ration sur PowerPoint. Cela vous permettra ainsi de pr\u00e9senter des tableaux clairs et parfaitement compr\u00e9hensibles pour votre audience.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Pour traiter les donn\u00e9es, Microsoft Excel reste l\u2019outil incontournable. Avec ses multiples fonctionnalit\u00e9s, il facilite la pr\u00e9paration et la lecture des jeux de donn\u00e9es. Et parmi les fonctions \u00e0 ma\u00eetriser, il y a \u00e9videmment la fusion de cellules. Si cette fonction est relativement basique, il existe aussi de nombreuses subtilit\u00e9s. Alors comment fusionner des cellules [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":217650,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"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 fusionner des cellules sur Excel ?<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez comment fusionner des cellules avec Excel afin d\u2019am\u00e9liorer la lisibilit\u00e9 de vos tableaux.\" \/>\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\/fusionner-des-cellules-sur-excel\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment fusionner des cellules sur Excel ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/fusionner-des-cellules-sur-excel\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-20T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-15T14:14:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/fusionner-des-cellules-sur-excel\",\"url\":\"https:\/\/datascientest.com\/fusionner-des-cellules-sur-excel\",\"name\":\"Comment fusionner des cellules sur Excel ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-12-20T06:30:00+00:00\",\"dateModified\":\"2023-12-15T14:14:18+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"D\u00e9couvrez comment fusionner des cellules avec Excel afin d\u2019am\u00e9liorer la lisibilit\u00e9 de vos tableaux.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/fusionner-des-cellules-sur-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\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment fusionner des cellules sur Excel ?","description":"D\u00e9couvrez comment fusionner des cellules avec Excel afin d\u2019am\u00e9liorer la lisibilit\u00e9 de vos tableaux.","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\/fusionner-des-cellules-sur-excel","og_locale":"fr_FR","og_type":"article","og_title":"Comment fusionner des cellules sur Excel ?","og_url":"https:\/\/datascientest.com\/fusionner-des-cellules-sur-excel","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-12-20T06:30:00+00:00","article_modified_time":"2023-12-15T14:14:18+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/fusion-cellulles-excel.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/fusionner-des-cellules-sur-excel","url":"https:\/\/datascientest.com\/fusionner-des-cellules-sur-excel","name":"Comment fusionner des cellules sur Excel ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-12-20T06:30:00+00:00","dateModified":"2023-12-15T14:14:18+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"D\u00e9couvrez comment fusionner des cellules avec Excel afin d\u2019am\u00e9liorer la lisibilit\u00e9 de vos tableaux.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/fusionner-des-cellules-sur-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\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/217645"}],"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\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=217645"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/217645\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/217650"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=217645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=217645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=217645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}