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

[version en cours de rédaction][version en cours de rédaction]
 
Ligne 7 : Ligne 7 :
 
|Type de contenu=Fiche action
 
|Type de contenu=Fiche action
 
|Difficulty=Medium
 
|Difficulty=Medium
 +
|Licence=CC-BY
 
|Duration=5
 
|Duration=5
 
|Duration-type=minute(s)
 
|Duration-type=minute(s)
−
|Licence=CC-BY
 
 
}}
 
}}
 
{{Introduction}}
 
{{Introduction}}
Ligne 22 : Ligne 22 :
 
|Step_Title=Sélectionner une cellule
 
|Step_Title=Sélectionner une cellule
 
|Step_Content=Cliquez sur une cellule de votre tableau ou de vos données.
 
|Step_Content=Cliquez sur une cellule de votre tableau ou de vos données.
−
|Step_Picture_00=Le_tri_personnalis_-_Excel_Sans_titre.png
+
|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-10-22_143526.png
 
}}
 
}}
 
{{Tuto Step
 
{{Tuto Step
−
|Step_Title=Onglet Données
+
|Step_Title=Onglet Accueil
−
|Step_Content=# Cliquez sur l'onglet '''Données'''
+
|Step_Content=#Vérifiez que vous êtes dans l'onglet '''Accueil'''
−
# Cliquez sur '''Trier'''
+
#Cliquez sur '''Trier et Filtrer'''
−
|Step_Picture_00=Le_tri_personnalis_-_Excel_Sans_titre.png
+
#Cliquez sur '''Tri personnalisé'''
−
|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.14,"width":1246,"height":990,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.48,"scaleY":0.48,"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/a/ae/Le_tri_personnalis_-_Excel_Sans_titre.png","filters":[]},{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":333.57,"top":43.5,"width":25.77,"height":27.4,"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":"wfarrow2line","version":"3.5.0","originX":"center","originY":"center","left":354.5,"top":77,"width":25,"height":40,"fill":"rgba(255,0,0,0)","stroke":"#FF0000","strokeWidth":4,"strokeDashArray":null,"strokeLineCap":"round","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,"x1":12.5,"x2":-12.5,"y1":20,"y2":-20,"x2a":-8.684007631977103,"y2a":1.1999576001271972,"x2b":4.883965232104303,"y2b":-7.280025439923682},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":367,"top":97,"width":16,"height":16,"fill":"#aaa","stroke":"#666","strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":0.5,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"radius":8,"startAngle":0,"endAngle":6.283185307179586},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":342,"top":57,"width":16,"height":16,"fill":"#aaa","stroke":"#666","strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":0.5,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"radius":8,"startAngle":0,"endAngle":6.283185307179586},{"type":"textbox","version":"3.5.0","originX":"center","originY":"center","left":394,"top":110,"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":"2","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":{} },{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":201.52,"top":22.77,"width":40.08,"height":17.82,"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":"wfarrow2line","version":"3.5.0","originX":"center","originY":"center","left":157.5,"top":54.5,"width":43,"height":37,"fill":"rgba(255,0,0,0)","stroke":"#FF0000","strokeWidth":4,"strokeDashArray":null,"strokeLineCap":"round","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,"x1":-21.5,"x2":21.5,"y1":18.5,"y2":-18.5,"x2a":11.557717841544914,"y2a":0.6089252832718355,"x2b":1.1218472071381536,"y2b":-11.51924869725494},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":136,"top":73,"width":16,"height":16,"fill":"#aaa","stroke":"#666","strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":0.5,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"radius":8,"startAngle":0,"endAngle":6.283185307179586},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":179,"top":36,"width":16,"height":16,"fill":"#aaa","stroke":"#666","strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1,"scaleY":1,"angle":0,"flipX":false,"flipY":false,"opacity":0.5,"shadow":null,"visible":true,"clipTo":null,"backgroundColor":"","fillRule":"nonzero","paintFirst":"fill","globalCompositeOperation":"source-over","transformMatrix":null,"skewX":0,"skewY":0,"radius":8,"startAngle":0,"endAngle":6.283185307179586},{"type":"textbox","version":"3.5.0","originX":"center","originY":"center","left":141,"top":78,"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":477,"width":600}
+
|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
 
{{Tuto Step
Ligne 35 : Ligne 36 :
 
|Step_Content=Si vous souhaitez trier vos valeurs sur plusieurs colonnes alors il faut ajouter des niveaux :  
 
|Step_Content=Si vous souhaitez trier vos valeurs sur plusieurs colonnes alors il faut ajouter des niveaux :  
  
−
# Cliquez sur ajouter un niveau
+
#Cliquez sur '''ajouter un niveau'''
 
|Step_Picture_00=Le_tri_personnalis__-_Excel_Capture_d_cran_2024-02-21_110003.png
 
|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}
 
|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}

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

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

Auteur avatarMathieu Demanet | Dernière modification 22/10/2024 par M.demanet en cours de rédaction

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
<languages />

Tutoriels prérequis

Étape 1 - Sélectionner une cellule

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

Le tri personnalis - Excel Capture d cran 2024-10-22 143526.png




Étape 2 - Onglet Accueil

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




Étape 3 - Ajouter un niveau

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

  1. 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

Récupérée de « https://rennesmetropole.dokit.app/w/index.php?title=Le_tri_personnalisé_-_Excel&oldid=7112 »
© 2017 - 2024 Dokit, SAS.