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

[version en cours de rédaction][version en cours de rédaction]
(Page créée avec « {{Tuto Details |Main_Picture=Manual-Les_bases_du_tableur_-_Excel_Microsoft_Excel_2013-2019_logo.svg.png |Main_Picture_annotation={"version":"3.5.0","objects":[{"type":"ima... »)
 
Ligne 2 : Ligne 2 :
 
|Main_Picture=Manual-Les_bases_du_tableur_-_Excel_Microsoft_Excel_2013-2019_logo.svg.png
 
|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}
 
|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
 
|Categories=Numérique
 
|Public=Professionnels, Grand public, Médiateurs
 
|Public=Professionnels, Grand public, Médiateurs
Ligne 12 : Ligne 12 :
 
}}
 
}}
 
{{Introduction}}
 
{{Introduction}}
{{Materials}}
+
{{Materials
{{Tuto Step}}
+
|Prerequisites={{Prerequisites
 +
|Prerequisites=Créer un tableau - Excel
 +
}}{{Prerequisites
 +
|Prerequisites=Le tri simple - Excel
 +
}}
 +
}}
 +
{{Tuto Step
 +
|Step_Title=Sélectionnez une cellule
 +
|Step_Content=Cliquez sur une cellule de votre tableau ou de vos données.
 +
|Step_Picture_00=Le_tri_personnalis_-_Excel_Sans_titre.png
 +
}}
 +
{{Tuto Step
 +
|Step_Title=Onglet Données
 +
|Step_Content=# Cliquez sur l'onglet '''Données'''
 +
# Cliquez sur '''Trier'''
 +
|Step_Picture_00=Le_tri_personnalis_-_Excel_Sans_titre.png
 +
|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}
 +
}}
 +
{{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}}
 
{{Notes}}
 
{{PageLang}}
 
{{PageLang}}
 
{{Tuto Status
 
{{Tuto Status
|Complete=Draft
+
|Complete=Published
 
}}
 
}}

Version du 21 février 2024 à 11:08

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

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

Étape 1 - Sélectionnez une cellule

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




Étape 2 - Onglet Données

  1. Cliquez sur l'onglet Données
  2. Cliquez sur Trier




É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