{"id":842,"date":"2023-10-17T01:27:19","date_gmt":"2023-10-17T01:27:19","guid":{"rendered":"https:\/\/lasstatistique.com\/?p=842"},"modified":"2024-08-14T08:06:20","modified_gmt":"2024-08-14T08:06:20","slug":"cour-2-excel","status":"publish","type":"post","link":"https:\/\/lasstatistique.com\/?p=842","title":{"rendered":"Cours 2 : Excel"},"content":{"rendered":"

CHAPITRE III :<\/b> MISE EN FORME DANS EXCEL<\/b><\/span><\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 III.1- Mise en forme des feuilles de calcul Excel<\/span><\/b><\/p>\n

L\u2019onglet Accueil d\u2019Excel<\/span> illustr\u00e9 \u00e0 la figure\u00a0suivante contient les commandes de mise en forme et d\u2019\u00e9dition qui vous permettent d\u2019am\u00e9liorer l\u2019apparence et la lisibilit\u00e9 des feuilles de calcul.<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0III.2- Aligner et mettre en retrait le contenu d\u2019une cellule<\/span><\/b><\/p>\n

Pour le faire, cliquez sur la cellule ou s\u00e9lectionnez une plage de cellule; puis cliquez sous l\u2019onglet Accueil<\/span>, dans le groupe Alignement et choisissez l\u2019action que vous voulez ex\u00e9cuter. Voir figure<\/p>\n

Pour choisir la police et la taille de police, allez sous l\u2019onglet Accueil<\/span>, dans le groupe Police, et ex\u00e9cutez l\u2019action souhaiter.<\/p>\n

\"\"<\/p>\n

\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0III.3- Fusionner et fractionner des cellules<\/span><\/b><\/p>\n

– Pour fusionner, s\u00e9lectionnez\u00a0 les cellules que vous voulez fusionnez. Sous l\u2019onglet Accueil<\/span>, dans le groupe Alignement, cliquez sur la partie principale du bouton Fusionner et centrer.<\/p>\n

– Pour fractionner, ou annuler la fusion, des cellules juste apr\u00e8s les avoir fusionn\u00e9es, appuyez sur Ctrl+Z<\/span>. Sinon, ouvrez le menu Fusionner et centrer, puis s\u00e9lectionnez Annuler Fusionner cellules pour fractionner les cellules fusionn\u00e9es.<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 III.4- Appliquer des styles de cellule<\/span><\/b><\/p>\n

– Sous l\u2019onglet Accueil<\/span>, dans le groupe Style, ouvrez le menu Styles de cellules. La galerie de styles de cellules s\u2019affiche, comme illustr\u00e9 \u00e0 la figure.<\/p>\n

\"\"<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0III.5- Renommer une feuille de calcul<\/span><\/b><\/p>\n

– Double-cliquez sur l\u2019onglet de feuille de calcul dont vous souhaitez renommer pour s\u00e9lectionner son nom.<\/p>\n

– Tapez le nouveau nom et appuyez sur Entr\u00e9e. Le nouveau nom s\u2019affiche sur l\u2019onglet.<\/p>\n

\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 III.6- Ins\u00e9rer et supprimer une feuille de calcul Excel<\/span><\/b><\/p>\n

– Insertion:<\/b> Sous l\u2019onglet Accueil<\/span>, dans le groupe Cellules, cliquez sur la fl\u00e8che vers le bas en dessous de Ins\u00e9rer<\/span>, puis sur ins\u00e9rer.<\/p>\n

– Suppression: <\/b>Cliquez sur la feuille que vous voulez supprim\u00e9, puis sous l\u2019onglet Accueil<\/span>, dans le groupe Cellules, cliquez sur la fl\u00e8che vers le bas Supprimer et cliquez sur Supprimer une feuille.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

CHAPITRE III : MISE EN FORME DANS EXCEL \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 III.1- Mise en forme des feuilles<\/p>\n","protected":false},"author":1,"featured_media":824,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[40,41],"tags":[],"class_list":["post-842","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cours","category-excel"],"yoast_head":"\nCours 2 : Excel - LASStatistique<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/lasstatistique.com\/?p=842\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cours 2 : Excel - LASStatistique\" \/>\n<meta property=\"og:description\" content=\"CHAPITRE III : MISE EN FORME DANS EXCEL \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 III.1- Mise en forme des feuilles\" \/>\n<meta property=\"og:url\" content=\"https:\/\/lasstatistique.com\/?p=842\" \/>\n<meta property=\"og:site_name\" content=\"LASStatistique\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ASstatistique\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-17T01:27:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-14T08:06:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@AsStatistique\" \/>\n<meta name=\"twitter:site\" content=\"@AsStatistique\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/person\\\/c8fa17c25e80a74f42e1d8b8dcd9c470\"},\"headline\":\"Cours 2 : Excel\",\"datePublished\":\"2023-10-17T01:27:19+00:00\",\"dateModified\":\"2024-08-14T08:06:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842\"},\"wordCount\":350,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"articleSection\":[\"Cours\",\"Excel\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/lasstatistique.com\\\/?p=842#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842\",\"name\":\"Cours 2 : Excel - LASStatistique\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"datePublished\":\"2023-10-17T01:27:19+00:00\",\"dateModified\":\"2024-08-14T08:06:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/lasstatistique.com\\\/?p=842\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842#primaryimage\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"contentUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/microsoft-excel-2013-logo.png\",\"width\":800,\"height\":600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/?p=842#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/lasstatistique.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cours\",\"item\":\"https:\\\/\\\/lasstatistique.com\\\/?cat=40\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Cours 2 : Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#website\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/\",\"name\":\"LASStatistique\",\"description\":\"L'AS Statistique\",\"publisher\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/lasstatistique.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#organization\",\"name\":\"L'AS STATISTIQUE\",\"alternateName\":\"lasstatistique\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/cropped-logoAS-removebg-preview.png\",\"contentUrl\":\"https:\\\/\\\/lasstatistique.com\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/cropped-logoAS-removebg-preview.png\",\"width\":500,\"height\":245,\"caption\":\"L'AS STATISTIQUE\"},\"image\":{\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/ASstatistique\\\/\",\"https:\\\/\\\/x.com\\\/AsStatistique\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/l-as\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/lasstatistique.com\\\/#\\\/schema\\\/person\\\/c8fa17c25e80a74f42e1d8b8dcd9c470\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/lasstatistique.com\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cours 2 : Excel - LASStatistique","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:\/\/lasstatistique.com\/?p=842","og_locale":"fr_FR","og_type":"article","og_title":"Cours 2 : Excel - LASStatistique","og_description":"CHAPITRE III : MISE EN FORME DANS EXCEL \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 III.1- Mise en forme des feuilles","og_url":"https:\/\/lasstatistique.com\/?p=842","og_site_name":"LASStatistique","article_publisher":"https:\/\/www.facebook.com\/ASstatistique\/","article_published_time":"2023-10-17T01:27:19+00:00","article_modified_time":"2024-08-14T08:06:20+00:00","og_image":[{"width":800,"height":600,"url":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@AsStatistique","twitter_site":"@AsStatistique","twitter_misc":{"\u00c9crit par":"admin","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/lasstatistique.com\/?p=842#article","isPartOf":{"@id":"https:\/\/lasstatistique.com\/?p=842"},"author":{"name":"admin","@id":"https:\/\/lasstatistique.com\/#\/schema\/person\/c8fa17c25e80a74f42e1d8b8dcd9c470"},"headline":"Cours 2 : Excel","datePublished":"2023-10-17T01:27:19+00:00","dateModified":"2024-08-14T08:06:20+00:00","mainEntityOfPage":{"@id":"https:\/\/lasstatistique.com\/?p=842"},"wordCount":350,"commentCount":0,"publisher":{"@id":"https:\/\/lasstatistique.com\/#organization"},"image":{"@id":"https:\/\/lasstatistique.com\/?p=842#primaryimage"},"thumbnailUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","articleSection":["Cours","Excel"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/lasstatistique.com\/?p=842#respond"]}]},{"@type":"WebPage","@id":"https:\/\/lasstatistique.com\/?p=842","url":"https:\/\/lasstatistique.com\/?p=842","name":"Cours 2 : Excel - LASStatistique","isPartOf":{"@id":"https:\/\/lasstatistique.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/lasstatistique.com\/?p=842#primaryimage"},"image":{"@id":"https:\/\/lasstatistique.com\/?p=842#primaryimage"},"thumbnailUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","datePublished":"2023-10-17T01:27:19+00:00","dateModified":"2024-08-14T08:06:20+00:00","breadcrumb":{"@id":"https:\/\/lasstatistique.com\/?p=842#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/lasstatistique.com\/?p=842"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/lasstatistique.com\/?p=842#primaryimage","url":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","contentUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/10\/microsoft-excel-2013-logo.png","width":800,"height":600},{"@type":"BreadcrumbList","@id":"https:\/\/lasstatistique.com\/?p=842#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/lasstatistique.com\/"},{"@type":"ListItem","position":2,"name":"Cours","item":"https:\/\/lasstatistique.com\/?cat=40"},{"@type":"ListItem","position":3,"name":"Cours 2 : Excel"}]},{"@type":"WebSite","@id":"https:\/\/lasstatistique.com\/#website","url":"https:\/\/lasstatistique.com\/","name":"LASStatistique","description":"L'AS Statistique","publisher":{"@id":"https:\/\/lasstatistique.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/lasstatistique.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/lasstatistique.com\/#organization","name":"L'AS STATISTIQUE","alternateName":"lasstatistique","url":"https:\/\/lasstatistique.com\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/lasstatistique.com\/#\/schema\/logo\/image\/","url":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/06\/cropped-logoAS-removebg-preview.png","contentUrl":"https:\/\/lasstatistique.com\/wp-content\/uploads\/2023\/06\/cropped-logoAS-removebg-preview.png","width":500,"height":245,"caption":"L'AS STATISTIQUE"},"image":{"@id":"https:\/\/lasstatistique.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ASstatistique\/","https:\/\/x.com\/AsStatistique","https:\/\/www.linkedin.com\/company\/l-as\/"]},{"@type":"Person","@id":"https:\/\/lasstatistique.com\/#\/schema\/person\/c8fa17c25e80a74f42e1d8b8dcd9c470","name":"admin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10025711df1f8aa24f62df0b21ee0b064751df6536cd9cf6bbdb353a32926b97?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/lasstatistique.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts\/842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=842"}],"version-history":[{"count":5,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts\/842\/revisions"}],"predecessor-version":[{"id":875,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/posts\/842\/revisions\/875"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=\/wp\/v2\/media\/824"}],"wp:attachment":[{"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lasstatistique.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}