{"id":8813,"date":"2026-07-13T19:16:01","date_gmt":"2026-07-13T17:16:01","guid":{"rendered":"https:\/\/tutoriel-googlesheets.fr\/accueil-v2\/"},"modified":"2026-07-13T19:23:40","modified_gmt":"2026-07-13T17:23:40","slug":"accueil-v2","status":"publish","type":"page","link":"https:\/\/tutoriel-googlesheets.fr\/it\/","title":{"rendered":"Tutoriels Google Sheets \u2014 Formules, astuces &#038; productivit\u00e9"},"content":{"rendered":"<!-- 01 \u2014 HERO full-bleed \u00e0 d\u00e9grad\u00e9 (mc_hero rendu dans .mm-hero) -->\n\n<section class=\"mm-hero\">\n\n<style id=\"mc-css\">\n\/* CORE \u2014 mc-wrap = container 1200px CENTERED d\u00e9fensif *\/\n.mc-wrap{max-width:1200px;margin:0 auto;padding:0 24px;box-sizing:border-box;width:100%}\n\/* HERO \u2014 grid 2-col forc\u00e9, image gauche, card droite *\/\n.mc-hero{display:grid !important;grid-template-columns:1.05fr 1fr;gap:44px;align-items:center;margin:44px auto;justify-self:center;background:transparent;width:100%;max-width:100%}\n.mc-hero::before,.mc-hero::after{display:none !important;content:none !important;background:none !important}\n.mc-hero__media{position:relative;aspect-ratio:3\/2;max-height:470px;overflow:hidden;border-radius:8px;background:rgba(0,0,0,.06);width:100%;margin:0;grid-column:1}\n.mc-hero__media::before,.mc-hero__media::after{display:none !important;content:none !important}\n.mc-hero__media img{width:100%;height:100%;object-fit:cover;display:block;filter:none}\n.mc-hero__text{position:relative;grid-column:2;margin:0;background:transparent;padding:0}\n.mc-hero__text::before,.mc-hero__text::after{display:none !important;content:none !important;background:none !important}\n.mc-hero__kicker{font-size:11px;letter-spacing:2.5px;text-transform:uppercase;font-weight:700;opacity:.65;margin-bottom:14px}\n.mc-hero__title{font-size:clamp(28px,3.4vw,46px);line-height:1.08;margin:0 0 16px;font-family:inherit;text-shadow:none}\n.mc-hero__title a{color:inherit;text-decoration:none}\n.mc-hero__excerpt{font-size:16px;line-height:1.6;opacity:.78;margin:0 0 18px;text-shadow:none}\n.mc-hero__byline{font-size:13px;opacity:.6;margin-bottom:16px;text-shadow:none}\n.mc-hero__cta{display:inline-block;font-size:12px;letter-spacing:1.5px;text-transform:uppercase;font-weight:700;text-decoration:none;border-bottom:2px solid currentColor;padding-bottom:3px;color:inherit}\n\/* CARDS \u2014 grid responsive *\/\n.mc-cards{display:grid;gap:34px 28px;margin:8px auto 12px;width:100%}\n.mc-card{display:flex;flex-direction:column}\n.mc-card__media{aspect-ratio:16\/10;overflow:hidden;border-radius:5px;margin-bottom:13px;background:rgba(0,0,0,.06)}\n.mc-card__media img{width:100%;height:100%;object-fit:cover;display:block;transition:transform .5s}\n.mc-card:hover .mc-card__media img{transform:scale(1.04)}\n.mc-card__cat{font-size:10.5px;letter-spacing:1.8px;text-transform:uppercase;font-weight:700;opacity:.65;margin-bottom:6px}\n.mc-card__title{font-size:19px;line-height:1.26;margin:0 0 8px;font-family:inherit}\n.mc-card__title a{color:inherit;text-decoration:none}\n.mc-card__title a:hover{opacity:.7}\n.mc-card__date{font-size:12px;letter-spacing:.5px;opacity:.55;margin:auto 0 0}\n\/* HERO ASIDE variant *\/\n.mc-hero:has(.mc-hero__aside){grid-template-columns:1.15fr 1fr .8fr}\n.mc-hero__aside{border-left:1px solid rgba(128,128,128,.2);padding-left:24px;align-self:stretch}\n.mc-hero__aside-t{font-size:11px;letter-spacing:2px;text-transform:uppercase;font-weight:700;opacity:.6;margin-bottom:16px}\n.mc-aside-item{display:grid;grid-template-columns:64px 1fr;gap:12px;align-items:center;margin-bottom:16px;text-decoration:none;color:inherit}\n.mc-aside-img{display:block;aspect-ratio:1\/1;border-radius:4px;overflow:hidden;background:rgba(0,0,0,.06)}\n.mc-aside-img img{width:100%;height:100%;object-fit:cover;display:block}\n.mc-aside-tt{font-size:13.5px;line-height:1.3}\n.mc-aside-item:hover .mc-aside-tt{opacity:.7}\n\/* ANTI-R\u00c9GRESSION baseline d\u00e9fensive *\/\nbody #right-sidebar,body #left-sidebar,body aside.sidebar,body .widget-area.sidebar{display:none !important}\nbody .content-area,body #primary{float:none !important;width:100% !important;max-width:100% !important}\nbody .site-description,body p.main-title{display:none !important}\n@media(min-width:769px){body .main-navigation .main-nav ul{display:flex !important;flex-wrap:nowrap !important;justify-content:center !important;align-items:center !important;margin:0 !important;padding:0 !important;list-style:none !important}body .main-navigation .main-nav ul li{display:inline-block !important;float:none !important;margin:0 !important}body .main-navigation .main-nav ul li a{display:inline-block !important;padding:10px 14px !important;white-space:nowrap !important}}\n@media(max-width:900px){.mc-hero,.mc-hero:has(.mc-hero__aside){grid-template-columns:1fr;gap:24px}.mc-hero__media,.mc-hero__text{grid-column:auto}.mc-cards{grid-template-columns:1fr 1fr !important}.mc-hero__aside{border-left:none;padding-left:0;border-top:1px solid rgba(128,128,128,.2);padding-top:20px}}\n@media(max-width:560px){.mc-cards{grid-template-columns:1fr !important}}\n<\/style><div class=\"mc-wrap\"><div class=\"mm-hero mc-hero\"><div class=\"mm-hero__media mc-hero__media\"><\/div><div class=\"mm-hero__text mc-hero__text\"><div class=\"mm-hero__kicker mc-hero__kicker\">Le m\u00e9mo Google Sheets<\/div><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_88 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Sauvegarder_ses_donnees_methode_simple_pour_un_particulier\" >Sauvegarder ses donn\u00e9es : m\u00e9thode simple pour un particulier<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#A_la_une_cette_semaine\" >\u00c0 la une cette semaine<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Google_Sheets_RECHERCHEV_la_formule_expliquee_pas_a_pas\" >Google Sheets RECHERCHEV : la formule expliqu\u00e9e pas \u00e0 pas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Suivre_son_crawl_dans_Google_Sheets_le_tableau_de_bord_SEO_que_Jimenez_Julien_monte_en_formules\" >Suivre son crawl dans Google Sheets : le tableau de bord SEO que Jimenez Julien monte en formules<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Les_formules_Google_Sheets_qui_sauvent_12_depannages_express\" >Les formules Google Sheets qui sauvent : 12 d\u00e9pannages express<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_transposer_des_lignes_en_colonnes_dans_Google_Sheets\" >Comment transposer des lignes en colonnes dans Google Sheets ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_remplacer_une_formule_par_sa_valeur_dans_Google_Sheets_coller_special\" >Comment remplacer une formule par sa valeur dans Google Sheets (coller sp\u00e9cial) ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_fusionner_des_cellules_dans_Google_Sheets\" >Comment fusionner des cellules dans Google Sheets ?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Nos_rubriques\" >Nos rubriques<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Formules_Google_Sheets\" >Formules Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Astuces_Google_Sheets\" >Astuces Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Cartographie_schemas\" >Cartographie &#038; sch\u00e9mas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Astuces_de_productivite\" >Astuces de productivit\u00e9<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Maitriser_les_formules\" >Ma\u00eetriser les formules<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_creer_une_liste_deroulante_conditionnelle_dans_Google_Sheets\" >Comment cr\u00e9er une liste d\u00e9roulante conditionnelle dans Google Sheets ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_separer_un_texte_en_colonnes_dans_Google_Sheets_SPLIT\" >Comment s\u00e9parer un texte en colonnes dans Google Sheets (SPLIT) ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_figer_une_cellule_dans_une_formule_Google_Sheets_reference_absolue\" >Comment figer une cellule dans une formule Google Sheets (r\u00e9f\u00e9rence absolue) ?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Pourquoi_un_carnet_dedie_a_Google_Sheets\" >Pourquoi un carnet d\u00e9di\u00e9 \u00e0 Google Sheets ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Astuces_raccourcis\" >Astuces &#038; raccourcis<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_calculer_un_pourcentage_dans_Google_Sheets\" >Comment calculer un pourcentage dans Google Sheets ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_concatener_combiner_deux_cellules_dans_Google_Sheets\" >Comment concat\u00e9ner (combiner) deux cellules dans Google Sheets ?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Comment_trier_par_ordre_alphabetique_dans_Google_Sheets\" >Comment trier par ordre alphab\u00e9tique dans Google Sheets ?<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Recevez_nos_meilleures_astuces_Sheets\" >Recevez nos meilleures astuces Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#La_redaction\" >La r\u00e9daction<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Lucas_Martin\" >Lucas Martin<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/#Pourquoi_nous_lire\" >Pourquoi nous lire<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"mm-hero__title mc-hero__title\"><span class=\"ez-toc-section\" id=\"Sauvegarder_ses_donnees_methode_simple_pour_un_particulier\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/sauvegarder-ses-donnees-methode-simple-pour-un-particulier\/\">Sauvegarder ses donn\u00e9es : m\u00e9thode simple pour un particulier<\/a><span class=\"ez-toc-section-end\"><\/span><\/h2><p class=\"mm-hero__excerpt mc-hero__excerpt\">\u26a1 En bref La r\u00e8gle 3-2-1 reste la r\u00e9f\u00e9rence, m\u00eame \u00e0 la maison. Une sauvegarde jamais test\u00e9e n&rsquo;est pas une sauvegarde. Le cloud synchronise, il ... Leggi tutto<\/p><div class=\"mm-hero__byline mc-hero__byline\">Par <strong>Julien<\/strong> \u00b7 R\u00e9daction<\/div><a class=\"mm-hero__cta mc-hero__cta\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/sauvegarder-ses-donnees-methode-simple-pour-un-particulier\/\">Lire l'article \u2192<\/a><\/div><\/div><\/div>\n\n\n<\/section>\n\n<!-- 02 \u2014 EN CE MOMENT : pills arrondies (4 vrais articles) -->\n<section class=\"mm-dispatches\">\n  <div class=\"mm-dispatches__wrap\">\n    <span class=\"mm-dispatches__label\">En ce moment<\/span>\n    <div class=\"mm-dispatches__items\">\n      <a class=\"mm-dispatches__item\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/excel-comment-maitriser-la-puissance-des-feuilles-de-calcul-pour-analyser-vos-donnees\/\">Analyser ses donn\u00e9es sur Excel<\/a>\n      <a class=\"mm-dispatches__item\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/google-slides-comment-creer-des-presentations-impactantes-en-quelques-clics\/\">Des pr\u00e9sentations nettes sur Google Slides<\/a>\n      <a class=\"mm-dispatches__item\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-optimiser-votre-stockage-avec-google-drive-astuces-et-conseils\/\">Optimiser son stockage Google Drive<\/a>\n      <a class=\"mm-dispatches__item\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-creer-des-formulaires-efficaces-avec-google-forms-en-2025\/\">Des formulaires Google Forms efficaces<\/a>\n    <\/div>\n  <\/div>\n<\/section>\n\n<!-- 03 \u2014 Featured \/ \u00c0 la une header -->\n<section class=\"mm-section mm-section--sand\" style=\"padding-bottom:0\">\n  <header class=\"mm-section__header\">\n    <div>\n      <span class=\"mm-section__label\">N\u00b0 01 \u2014 \u00c0 la une<\/span>\n      <h2 class=\"mm-section__title\"><span class=\"ez-toc-section\" id=\"A_la_une_cette_semaine\"><\/span>\u00c0 la une cette semaine<span class=\"ez-toc-section-end\"><\/span><\/h2>\n      <p class=\"mm-section__sub\">Nos derniers tutoriels et astuces pour aller plus loin avec vos tableurs.<\/p>\n    <\/div>\n    <a class=\"mm-section__more\" href=\"\/it\/formule-google-sheet\/\">Tout voir \u2192<\/a>\n  <\/header>\n<\/section>\n\n\n<!-- Cards r\u00e9cents grid 3 cols -->\n<div class=\"gb-container gb-container-mm-recent-c mm-section mm-section--sand\">\n<div class=\"gb-container gb-container-mm-recent-in mm-wrap\">\n<div class=\"mc-wrap\"><div class=\"mm-cards mc-cards\" style=\"display:grid;grid-template-columns:repeat(3,1fr);gap:32px 28px\"><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">Non class\u00e9<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Google_Sheets_RECHERCHEV_la_formule_expliquee_pas_a_pas\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/google-sheets-recherchev\/\">Google Sheets RECHERCHEV : la formule expliqu\u00e9e pas \u00e0 pas<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">28 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">Non class\u00e9<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Suivre_son_crawl_dans_Google_Sheets_le_tableau_de_bord_SEO_que_Jimenez_Julien_monte_en_formules\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/jimenez-julien-suivi-seo-google-sheets\/\">Suivre son crawl dans Google Sheets : le tableau de bord SEO que Jimenez Julien monte en formules<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">27 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Les_formules_Google_Sheets_qui_sauvent_12_depannages_express\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/les-formules-google-sheets-qui-sauvent-12-depannages-express\/\">Les formules Google Sheets qui sauvent : 12 d\u00e9pannages express<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_transposer_des_lignes_en_colonnes_dans_Google_Sheets\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-transposer-des-lignes-en-colonnes-dans-google-sheets\/\">Comment transposer des lignes en colonnes dans Google Sheets ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_remplacer_une_formule_par_sa_valeur_dans_Google_Sheets_coller_special\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-remplacer-une-formule-par-sa-valeur-dans-google-sheets-coller-special\/\">Comment remplacer une formule par sa valeur dans Google Sheets (coller sp\u00e9cial) ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_fusionner_des_cellules_dans_Google_Sheets\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-fusionner-des-cellules-dans-google-sheets\/\">Comment fusionner des cellules dans Google Sheets ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><\/div><\/div>\n\n<\/div>\n<\/div>\n\n<!-- 04 \u2014 SOMMAIRE \/ Rubriques : cartes num\u00e9rot\u00e9es (\u2260 stamps timbres v4) -->\n\n<section class=\"mm-depts\">\n  <header class=\"mm-section__header\">\n    <div>\n      <span class=\"mm-section__label\">N\u00b0 02 \u2014 Sommaire<\/span>\n      <h2 class=\"mm-section__title\"><span class=\"ez-toc-section\" id=\"Nos_rubriques\"><\/span>Nos rubriques<span class=\"ez-toc-section-end\"><\/span><\/h2>\n    <\/div>\n  <\/header>\n  <nav class=\"mm-depts__grid\">\n    <a class=\"mm-dept\" href=\"\/it\/formule-google-sheet\/\">\n      <div class=\"mm-dept__stamp\">01<\/div>\n      <h3 class=\"mm-dept__name\"><span class=\"ez-toc-section\" id=\"Formules_Google_Sheets\"><\/span>Formules Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n      <span class=\"mm-dept__count\">47 articles<\/span>\n    <\/a>\n    <a class=\"mm-dept\" href=\"\/it\/astuces-google-sheet\/\">\n      <div class=\"mm-dept__stamp\">02<\/div>\n      <h3 class=\"mm-dept__name\"><span class=\"ez-toc-section\" id=\"Astuces_Google_Sheets\"><\/span>Astuces Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h3>\n      <span class=\"mm-dept__count\">15 articles<\/span>\n    <\/a>\n    <a class=\"mm-dept\" href=\"\/it\/cartographie-schema\/\">\n      <div class=\"mm-dept__stamp\">03<\/div>\n      <h3 class=\"mm-dept__name\"><span class=\"ez-toc-section\" id=\"Cartographie_schemas\"><\/span>Cartographie &#038; sch\u00e9mas<span class=\"ez-toc-section-end\"><\/span><\/h3>\n      <span class=\"mm-dept__count\">Visualiser vos donn\u00e9es<\/span>\n    <\/a>\n    <a class=\"mm-dept\" href=\"\/it\/astuces-de-productivite\/\">\n      <div class=\"mm-dept__stamp\">04<\/div>\n      <h3 class=\"mm-dept__name\"><span class=\"ez-toc-section\" id=\"Astuces_de_productivite\"><\/span>Astuces de productivit\u00e9<span class=\"ez-toc-section-end\"><\/span><\/h3>\n      <span class=\"mm-dept__count\">Gagner du temps au quotidien<\/span>\n    <\/a>\n  <\/nav>\n<\/section>\n\n<!-- 05 \u2014 PULL QUOTE sur carte \u00e0 d\u00e9grad\u00e9 -->\n<section class=\"mm-pullquote\">\n  <div class=\"mm-pullquote__wrap\">\n    <span class=\"mm-pullquote__mark\">\u00ab\u00a0<\/span>\n    <p class=\"mm-pullquote__text\">Une bonne formule ne remplace pas la r\u00e9flexion, elle la prolonge. La vraie productivit\u00e9 sur Google Sheets na\u00eet d\u2019astuces simples, test\u00e9es et r\u00e9utilisables.<\/p>\n    <p class=\"mm-pullquote__attr\">\u2014 <strong>Lucas Martin<\/strong> \u00b7 Contributeur high-tech<\/p>\n  <\/div>\n<\/section>\n\n<!-- 06 \u2014 Section cat\u00e9gorie 1 header -->\n<section class=\"mm-section mm-section--sand\" style=\"padding-bottom:0\">\n  <header class=\"mm-section__header\">\n    <div>\n      <span class=\"mm-section__label\">N\u00b0 03 \u2014 Formules<\/span>\n      <h2 class=\"mm-section__title\"><span class=\"ez-toc-section\" id=\"Maitriser_les_formules\"><\/span>Ma\u00eetriser les formules<span class=\"ez-toc-section-end\"><\/span><\/h2>\n      <p class=\"mm-section__sub\">De RECHERCHEV aux formules matricielles, nos guides pas \u00e0 pas.<\/p>\n    <\/div>\n    <a class=\"mm-section__more\" href=\"\/it\/formule-google-sheet\/\">Toute la rubrique \u2192<\/a>\n  <\/header>\n<\/section>\n\n\n<!-- Section cat 1 \u2014 3 cards -->\n<div class=\"gb-container gb-container-mm-cons-c mm-section mm-section--sand\">\n<div class=\"gb-container gb-container-mm-cons-in mm-wrap\">\n<div class=\"mc-wrap\"><div class=\"mm-cards mc-cards\" style=\"display:grid;grid-template-columns:repeat(3,1fr);gap:32px 28px\"><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_creer_une_liste_deroulante_conditionnelle_dans_Google_Sheets\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-creer-une-liste-deroulante-conditionnelle-dans-google-sheets\/\">Comment cr\u00e9er une liste d\u00e9roulante conditionnelle dans Google Sheets ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_separer_un_texte_en_colonnes_dans_Google_Sheets_SPLIT\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-separer-un-texte-en-colonnes-dans-google-sheets-split\/\">Comment s\u00e9parer un texte en colonnes dans Google Sheets (SPLIT) ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_figer_une_cellule_dans_une_formule_Google_Sheets_reference_absolue\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-figer-une-cellule-dans-une-formule-google-sheets-reference-absolue\/\">Comment figer une cellule dans une formule Google Sheets (r\u00e9f\u00e9rence absolue) ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><\/div><\/div>\n\n<\/div>\n<\/div>\n\n<!-- 07 \u2014 EDITO sur carte cream arrondie (\u2260 carte postale postmark v4) -->\n\n<section class=\"mm-edito\">\n  <div class=\"mm-edito__wrap\">\n    <article class=\"mm-edito__postcard\">\n      <div class=\"mm-edito__meta\">\n        <span>Le mot de la r\u00e9daction<\/span>\n        <span>\u00b7<\/span>\n        <span><strong>septembre 2026<\/strong><\/span>\n      <\/div>\n      <h2 class=\"mm-edito__title\"><span class=\"ez-toc-section\" id=\"Pourquoi_un_carnet_dedie_a_Google_Sheets\"><\/span>Pourquoi un carnet d\u00e9di\u00e9 \u00e0 Google Sheets ?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n      <p class=\"mm-edito__body\">Google Sheets est devenu l\u2019un des outils de bureau les plus utilis\u00e9s au monde, et pourtant la plupart d\u2019entre nous n\u2019en exploitent qu\u2019une fraction. Ici, on part d\u2019un principe simple : chaque astuce est test\u00e9e sur une vraie feuille avant d\u2019\u00eatre publi\u00e9e.<\/p>\n      <p class=\"mm-edito__body\">Pas de jargon inutile, pas de tutoriel qui suppose que vous \u00eates d\u00e9j\u00e0 expert. On explique la formule, on montre le r\u00e9sultat, et on signale les pi\u00e8ges. L\u2019objectif : que vous repartiez avec une manipulation r\u00e9utilisable d\u00e8s aujourd\u2019hui.<\/p>\n      <div class=\"mm-edito__sig\">\n        <img decoding=\"async\" class=\"mm-edito__avatar mm-edito__avatar--img\" src=\"https:\/\/tutoriel-googlesheets.fr\/wp-content\/uploads\/2026\/07\/lucas-martin.jpg\" alt=\"Lucas Martin\" loading=\"lazy\" \/>\n        <div>\n          <p class=\"mm-edito__name\">Lucas Martin<\/p>\n          <p class=\"mm-edito__role\">Contributeur high-tech \u00b7 Tutoriels Google Sheets<\/p>\n        <\/div>\n      <\/div>\n    <\/article>\n  <\/div>\n<\/section>\n\n<!-- 08 \u2014 Section cat\u00e9gorie 2 header -->\n<section class=\"mm-section mm-section--sand-2\" style=\"padding-bottom:0\">\n  <header class=\"mm-section__header\">\n    <div>\n      <span class=\"mm-section__label\">N\u00b0 04 \u2014 Astuces<\/span>\n      <h2 class=\"mm-section__title\"><span class=\"ez-toc-section\" id=\"Astuces_raccourcis\"><\/span>Astuces &#038; raccourcis<span class=\"ez-toc-section-end\"><\/span><\/h2>\n      <p class=\"mm-section__sub\">Les petits r\u00e9glages qui font gagner des heures sur vos feuilles.<\/p>\n    <\/div>\n    <a class=\"mm-section__more\" href=\"\/it\/astuces-google-sheet\/\">Toute la rubrique \u2192<\/a>\n  <\/header>\n<\/section>\n\n\n<!-- Section cat 2 \u2014 3 cards -->\n<div class=\"gb-container gb-container-mm-ent-c mm-section mm-section--sand-2\">\n<div class=\"gb-container gb-container-mm-ent-in mm-wrap\">\n<div class=\"mc-wrap\"><div class=\"mm-cards mc-cards\" style=\"display:grid;grid-template-columns:repeat(3,1fr);gap:32px 28px\"><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_calculer_un_pourcentage_dans_Google_Sheets\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-calculer-un-pourcentage-dans-google-sheets\/\">Comment calculer un pourcentage dans Google Sheets ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_concatener_combiner_deux_cellules_dans_Google_Sheets\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-concatener-combiner-deux-cellules-dans-google-sheets\/\">Comment concat\u00e9ner (combiner) deux cellules dans Google Sheets ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><article class=\"mm-card mc-card\"><div class=\"mm-card__media mc-card__media\"><\/div><span class=\"mm-card__cat mc-card__cat\">D\u00e9pannage formules<\/span><h3 class=\"mm-card__title mc-card__title\"><span class=\"ez-toc-section\" id=\"Comment_trier_par_ordre_alphabetique_dans_Google_Sheets\"><\/span><a href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/\">Comment trier par ordre alphab\u00e9tique dans Google Sheets ?<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3><p class=\"mm-card__date mc-card__date\">16 Lug 2026<\/p><\/article><\/div><\/div>\n\n<\/div>\n<\/div>\n\n<!-- 09 \u2014 NEWSLETTER carte dark arrondie + TEAM + TRUST -->\n\n<section class=\"mm-news\">\n  <div class=\"mm-news__wrap\">\n    <div class=\"mm-news__stamp\">\u2726<\/div>\n    <div class=\"mm-news__kicker\">La newsletter<\/div>\n    <h2 class=\"mm-news__title\"><span class=\"ez-toc-section\" id=\"Recevez_nos_meilleures_astuces_Sheets\"><\/span>Recevez nos meilleures astuces Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n    <p class=\"mm-news__sub\">Un e-mail par semaine : une formule utile, une astuce productivit\u00e9, un cas concret. Rien d\u2019autre.<\/p>\n    <form class=\"mm-news__form\" onsubmit=\"event.preventDefault();this.querySelector('.mm-news__ok').classList.add('show');this.querySelector('input').value='';\" action=\"\">\n      <input type=\"email\" required placeholder=\"votre@email.com\" autocomplete=\"email\">\n      <button type=\"submit\">Je m&rsquo;inscris<\/button>\n    <input type=\"hidden\" name=\"trp-form-language\" value=\"it\"\/><\/form>\n    <p class=\"mm-news__ok\">\u2713 Inscription confirm\u00e9e. \u00c0 tr\u00e8s vite.<\/p>\n    <p class=\"mm-news__legal\">Aucun spam \u00b7 D\u00e9sinscription en 1 clic<\/p>\n  <\/div>\n<\/section>\n\n<section class=\"mm-team\">\n  <header class=\"mm-section__header\">\n    <div>\n      <span class=\"mm-section__label\">N\u00b0 05 \u2014 La r\u00e9daction<\/span>\n      <h2 class=\"mm-section__title\"><span class=\"ez-toc-section\" id=\"La_redaction\"><\/span>La r\u00e9daction<span class=\"ez-toc-section-end\"><\/span><\/h2>\n    <\/div>\n  <\/header>\n  <article class=\"mm-team__card\">\n    <img decoding=\"async\" class=\"mm-team__avatar mm-team__avatar--img\" src=\"https:\/\/tutoriel-googlesheets.fr\/wp-content\/uploads\/2026\/07\/lucas-martin.jpg\" alt=\"Lucas Martin\" loading=\"lazy\" \/>\n    <div>\n      <h3 class=\"mm-team__name\"><span class=\"ez-toc-section\" id=\"Lucas_Martin\"><\/span>Lucas Martin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n      <p class=\"mm-team__role\">Contributeur high-tech<\/p>\n      <p class=\"mm-team__bio\">Curieux de tout ce qui clignote, je couvre les gadgets, les objets connect\u00e9s et les petites astuces logicielles. J\u2019aime tester un produit puis dire franchement s\u2019il m\u00e9rite son prix. Mes articles s\u2019adressent \u00e0 ceux qui veulent un avis direct, sans fiche technique indigeste, pour acheter ou configurer en confiance.<\/p>\n      <p class=\"mm-team__expertise\"><strong>Ses sujets :<\/strong> Google Sheets, tableurs, objets connect\u00e9s, astuces logicielles<\/p>\n    <\/div>\n  <\/article>\n<\/section>\n\n<section class=\"mm-trust\">\n  <header class=\"mm-trust__header\">\n    <span class=\"mm-trust__label\">En confiance<\/span>\n    <h2 class=\"mm-trust__title\"><span class=\"ez-toc-section\" id=\"Pourquoi_nous_lire\"><\/span>Pourquoi nous lire<span class=\"ez-toc-section-end\"><\/span><\/h2>\n  <\/header>\n  <div class=\"mm-trust__grid\">\n    <div class=\"mm-trust__item\">\n      <p class=\"mm-trust__num\"><em>97<\/em><\/p>\n      <p class=\"mm-trust__lbl\">Tutoriels publi\u00e9s<\/p>\n    <\/div>\n    <div class=\"mm-trust__item\">\n      <p class=\"mm-trust__num\">100%<\/p>\n      <p class=\"mm-trust__lbl\">Astuces test\u00e9es<\/p>\n    <\/div>\n    <div class=\"mm-trust__item\">\n      <p class=\"mm-trust__num\">~4 min<\/p>\n      <p class=\"mm-trust__lbl\">Lecture moyenne<\/p>\n    <\/div>\n    <div class=\"mm-trust__item\">\n      <p class=\"mm-trust__num\"><em>Hebdo<\/em><\/p>\n      <p class=\"mm-trust__lbl\">Nouveaux guides<\/p>\n    <\/div>\n  <\/div>\n<\/section>","protected":false},"excerpt":{"rendered":"<p>En ce moment Analyser ses donn\u00e9es sur Excel Des pr\u00e9sentations nettes sur Google Slides Optimiser son stockage Google Drive Des formulaires Google Forms efficaces N\u00b0 &#8230; <a title=\"Comment trier par ordre alphab\u00e9tique dans Google Sheets ?\" class=\"read-more\" href=\"https:\/\/tutoriel-googlesheets.fr\/it\/comment-trier-par-ordre-alphabetique-dans-google-sheets\/\" aria-label=\"Per saperne di pi\u00f9 su Comment trier par ordre alphab\u00e9tique dans Google Sheets ?\">Leggi tutto<\/a><\/p>","protected":false},"author":11,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-8813","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tutoriel-googlesheets.fr\/it\/wp-json\/wp\/v2\/pages\/8813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tutoriel-googlesheets.fr\/it\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tutoriel-googlesheets.fr\/it\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tutoriel-googlesheets.fr\/it\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/tutoriel-googlesheets.fr\/it\/wp-json\/wp\/v2\/comments?post=8813"}],"version-history":[{"count":0,"href":"https:\/\/tutoriel-googlesheets.fr\/it\/wp-json\/wp\/v2\/pages\/8813\/revisions"}],"wp:attachment":[{"href":"https:\/\/tutoriel-googlesheets.fr\/it\/wp-json\/wp\/v2\/media?parent=8813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}