Le tri personnalisé - Excel : Différence entre versions

[version en cours de rédaction]

Version actuelle datée du 22 octobre 2024 à 13:38

Dans ce tutoriel, vous apprendrez à trier les données dans Excel 2026.

Auteur Mathieu Demanet | Dernière modification 22/10/2024 par M.demanet en cours de rédaction ⧼frevu-button-review-label⧽

Difficulté

Moyen

Durée

5 minute(s)

Public

Professionnels, Grand public, Médiateurs

Licence

CC-BY

Type de contenu

Fiche action

Dans ce tutoriel, vous apprendrez à trier les données dans Excel 2026.

Difficulté

Moyen

Durée

5 minute(s)

Public

Professionnels, Grand public, Médiateurs

Licence

CC-BY

Type de contenu

Fiche action

Tutoriels prérequis

Tutoriels prérequis

Créer un tableau - Excel

Le tri simple - Excel

Étape 1 - Sélectionner une cellule

Cliquez sur une cellule de votre tableau ou de vos données.

Étape 2 - Onglet Accueil

Vérifiez que vous êtes dans l'onglet Accueil
Cliquez sur Trier et Filtrer
Cliquez sur Tri personnalisé

Étape 3 - Ajouter un niveau

Si vous souhaitez trier vos valeurs sur plusieurs colonnes alors il faut ajouter des niveaux :

Cliquez sur ajouter un niveau

Étape 4 - Colonne

Pour Colonne, dans la liste déroulante, sélectionnez la première colonne à utiliser pour le tri (Trier par), puis la deuxième (Puis par).

Par exemple ici, nous Trier par Nom, Puis par Temps.

Étape 5 - Ordre

Pour Ordre, sélectionnez une option (par exemple, De A à Z, Du plus petit au plus grand ou Du plus grand au plus petit).

Étape 6 - Valider

Cliquez sur OK pour valider.

Commentaires

Published

@@ Ligne 2 : / Ligne 2 : @@
 |Main_Picture=Manual-Les_bases_du_tableur_-_Excel_Microsoft_Excel_2013-2019_logo.svg.png
 |Main_Picture_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":66,"top":1,"width":2170,"height":2048,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.22,"scaleY":0.22,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/d/de/Manual-Les_bases_du_tableur_-_Excel_Microsoft_Excel_2013-2019_logo.svg.png","filters":[]}],"height":449.8539435248296,"width":600}
-|Description=Dans ce tutoriel, vous apprendrez à trier les donnée dans Excel 2026.
+|Description=Dans ce tutoriel, vous apprendrez à trier les données dans Excel 2026.
 |Categories=Numérique
 |Public=Professionnels, Grand public, Médiateurs
 |Type de contenu=Fiche action
 |Difficulty=Medium
+|Licence=CC-BY
 |Duration=5
 |Duration-type=minute(s)
-|Licence=CC-BY
 }}
 {{Introduction}}
-{{Materials}}
+{{Materials
-{{Tuto Step}}
+|Prerequisites={{Prerequisites
+|Prerequisites=Créer un tableau - Excel
+}}{{Prerequisites
+|Prerequisites=Le tri simple - Excel
+}}
+}}
+{{Tuto Step
+|Step_Title=Sélectionner une cellule
+|Step_Content=Cliquez sur une cellule de votre tableau ou de vos données.
+|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-10-22_143526.png
+}}
+{{Tuto Step
+|Step_Title=Onglet Accueil
+|Step_Content=#Vérifiez que vous êtes dans l'onglet '''Accueil'''
+#Cliquez sur '''Trier et Filtrer'''
+#Cliquez sur '''Tri personnalisé'''
+|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-10-22_143541.png
+|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.01,"width":1917,"height":984,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.31,"scaleY":0.31,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/e/ea/Le_tri_personnalis_-_Excel_Capture_d_cran_2024-10-22_143541.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":559.21,"top":41.31,"width":69.14,"height":68.12,"fill":"rgba(255,0,0,0)","stroke":"#FF0000","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0}],"height":308,"width":600}
+}}
+{{Tuto Step
+|Step_Title=Ajouter un niveau
+|Step_Content=Si vous souhaitez trier vos valeurs sur plusieurs colonnes alors il faut ajouter des niveaux :
+#Cliquez sur '''ajouter un niveau'''
+|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-02-21_110003.png
+|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.21,"width":731,"height":259,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.82,"scaleY":0.82,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/f/f7/Le_tri_personnalis_-_Excel_Capture_d_cran_2024-02-21_110003.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":56.38,"top":39.98,"width":108.26,"height":24.68,"fill":"rgba(255,0,0,0)","stroke":"#FF0000","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0},{"type":"textbox","version":"3.5.0","originX":"center","originY":"center","left":74,"top":18,"width":47.8,"height":22.6,"fill":"#FF0000","stroke":"#FF0000","strokeWidth":1,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"text":"1","fontSize":20,"fontWeight":"normal","fontFamily":"sans-serif","fontStyle":"normal","lineHeight":1.16,"underline":false,"overline":false,"linethrough":false,"textAlign":"left","textBackgroundColor":"","charSpacing":0,"minWidth":20,"splitByGrapheme":false,"styles":{} }],"height":213,"width":600}
+}}
+{{Tuto Step
+|Step_Title=Colonne
+|Step_Content=Pour '''Colonne''', dans la liste déroulante, sélectionnez la première colonne à utiliser pour le tri ('''Trier par'''), puis la deuxième ('''Puis par''').
+Par exemple ici, nous '''Trier par''' Nom, '''Puis par''' Temps.
+|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-02-21_110309.png
+|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.24,"width":731,"height":265,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.82,"scaleY":0.82,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/b/bb/Le_tri_personnalis_-_Excel_Capture_d_cran_2024-02-21_110309.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":102.6,"top":84.35,"width":199.78,"height":51.97,"fill":"rgba(255,0,0,0)","stroke":"#FF0000","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0}],"height":218,"width":600}
+}}
+{{Tuto Step
+|Step_Title=Ordre
+|Step_Content=Pour '''Ordre''', sélectionnez une option (par exemple, '''De A à Z''', '''Du plus petit au plus grand''' ou '''Du plus grand au plus petit''').
+|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-02-21_110653.png
+|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.1,"width":730,"height":265,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.82,"scaleY":0.82,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/f/f5/Le_tri_personnalis_-_Excel_Capture_d_cran_2024-02-21_110653.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":499.6,"top":81.01,"width":189.79,"height":53.21,"fill":"rgba(255,0,0,0)","stroke":"#FF0000","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0}],"height":218,"width":600}
+}}
+{{Tuto Step
+|Step_Title=Valider
+|Step_Content=Cliquez sur OK pour valider.
+|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-02-21_110003.png
+|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.21,"width":731,"height":259,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.82,"scaleY":0.82,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"crossOrigin":"","cropX":0,"cropY":0,"src":"https://rennesmetropole.dokit.app/images/f/f7/Le_tri_personnalis_-_Excel_Capture_d_cran_2024-02-21_110003.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":497.68,"top":202.16,"width":69.68,"height":19.57,"fill":"rgba(255,0,0,0)","stroke":"#FF0000","strokeWidth":2,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":1,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"rx":0,"ry":0}],"height":213,"width":600}
+}}
 {{Notes}}
 {{PageLang}}
 {{Tuto Status
-|Complete=Draft
+|Complete=Published
 }}