Le tri simple - Excel : Différence entre versions

[version en cours de rédaction][version en cours de rédaction]
 
(2 révisions intermédiaires par le même utilisateur non affichées)
Ligne 12 : Ligne 12 :
 
}}
 
}}
 
{{Introduction}}
 
{{Introduction}}
−
{{Materials}}
+
{{Materials
 +
|Prerequisites={{Prerequisites
 +
|Prerequisites=Créer un tableau - Excel
 +
}}
 +
}}
 
{{Tuto Step
 
{{Tuto Step
 
|Step_Title=Trier
 
|Step_Title=Trier
−
|Step_Content=1- Sélectionnez une cellule de la colonne à trier.
+
|Step_Content=Si vos valeurs se trouvent dans un tableau, vous pouvez trier directement.
−
 
 
−
2- Cliquez sur l’onglet '''Accueil'''.
 
−
 
 
−
3- Dans le groupe '''Édition''', cliquez sur l’icône '''Trier et filtrer'''.
 
  
−
4- Cliquez sur filtrer
+
Retrouver le tutoriel pour créer des tableaux dans les prérequis juste au-dessus.
−
|Step_Picture_00=Le_tri_simple_-_Excel_excel25.png
+
|Step_Picture_00=Le_tri_simple_-_Excel_Capture_d_cran_2024-02-20_154441.png
−
|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":-0.07,"width":1916,"height":489,"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/b/be/Le_tri_simple_-_Excel_excel25.png","filters":[]},{"type":"wfarrow2line","version":"3.5.0","originX":"center","originY":"center","left":475,"top":59,"width":100,"height":0,"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":-50,"x2":50,"y1":0,"y2":0,"x2a":30,"y2a":-8,"x2b":30,"y2b":8},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":425,"top":59,"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":525,"top":59,"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":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":533.22,"top":20.45,"width":16.57,"height":27.62,"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":153,"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.06,"width":1240,"height":783,"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/5/54/Le_tri_simple_-_Excel_Capture_d_cran_2024-02-20_154441.png","filters":[]}],"height":379,"width":600}
 
}}
 
}}
 
{{Tuto Step
 
{{Tuto Step
 
|Step_Title=Trier
 
|Step_Title=Trier
−
|Step_Content=Les entêtes de colonnes se retrouvent affectées d'une flèche qui va permettre de développer les menus de filtrage.
+
|Step_Content=Les entêtes de colonnes se retrouvent affectées '''d'une flèche qui va permettre de développer les menus de filtrage.'''
  
  
Ligne 35 : Ligne 35 :
 
Selon le type de données contenues dans la colonne, vous pouvez '''trier''' :
 
Selon le type de données contenues dans la colonne, vous pouvez '''trier''' :
  
−
* '''de A à Z''' ou '''Trier de Z à A''' pour les champs de type texte ;
+
*'''de A à Z''' ou '''Trier de Z à A''' pour les champs de type texte ;
−
* '''du plus ancien au plus récent''' ou '''Trier du plus récent au plus ancien''' pour les champs de type date ;
+
*'''du plus ancien au plus récent''' ou '''Trier du plus récent au plus ancien''' pour les champs de type date ;
−
* '''du plus petit au plus grand''' ou '''Trier du plus grand au plus petit''' pour les champs de type numérique.
+
*'''du plus petit au plus grand''' ou '''Trier du plus grand au plus petit''' pour les champs de type numérique.
−
|Step_Picture_00=Le_tri_simple_-_Excel_excel27.png
+
|Step_Picture_00=Le_tri_simple_-_Excel_Capture_d_cran_2024-02-20_154646.png
−
|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":0.09,"width":850,"height":446,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.71,"scaleY":0.71,"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/6/60/Le_tri_simple_-_Excel_excel27.png","filters":[]},{"type":"wfarrow2line","version":"3.5.0","originX":"center","originY":"center","left":174,"top":59.5,"width":88,"height":53,"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":44,"x2":-44,"y1":26.5,"y2":-26.5,"x2a":-30.994756467904928,"y2a":-9.32840599504812,"x2b":-22.73993123196434,"y2b":-23.03453091510041},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":218,"top":86,"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":130,"top":33,"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}],"height":315,"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.11,"width":1242,"height":457,"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/c/c6/Le_tri_simple_-_Excel_Capture_d_cran_2024-02-20_154646.png","filters":[]},{"type":"wfarrow2line","version":"3.5.0","originX":"center","originY":"center","left":178.5,"top":30,"width":91,"height":10,"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":45.5,"x2":-45.5,"y1":5,"y2":-5,"x2a":-26.4935359748194,"y2a":5.136780813429654,"x2b":-24.745815144917735,"y2b":-10.767478738675493},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":224,"top":35,"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":133,"top":25,"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":255,"top":37,"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":{} },{"type":"wfrect","version":"3.5.0","originX":"center","originY":"center","left":47.75,"top":46.79,"width":97.52,"height":38.09,"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":128,"top":89,"width":56,"height":44,"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":28,"x2":-28,"y1":22,"y2":-22,"x2a":-17.216205639006777,"y2a":-3.3530222507825505,"x2b":-7.331060808096321,"y2b":-15.93411567194131},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":156,"top":111,"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":100,"top":67,"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":187,"top":119,"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":{} }],"height":221,"width":600}
 
}}
 
}}
 
{{Notes}}
 
{{Notes}}
 
{{PageLang}}
 
{{PageLang}}
 
{{Tuto Status
 
{{Tuto Status
−
|Complete=Draft
+
|Complete=Published
 
}}
 
}}

Version actuelle datée du 22 février 2024 à 13:48

Dans ce tutoriel, vous apprendrez à trier des valeurs dans Excel 2026.

Auteur avatarMathieu Demanet | Dernière modification 22/02/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 des valeurs 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 - Trier

Si vos valeurs se trouvent dans un tableau, vous pouvez trier directement.

Retrouver le tutoriel pour créer des tableaux dans les prérequis juste au-dessus.




Étape 2 - Trier

Les entêtes de colonnes se retrouvent affectées d'une flèche qui va permettre de développer les menus de filtrage.


Cliquez sur la flèche


Selon le type de données contenues dans la colonne, vous pouvez trier :

  • de A à Z ou Trier de Z à A pour les champs de type texte ;
  • du plus ancien au plus récent ou Trier du plus récent au plus ancien pour les champs de type date ;
  • du plus petit au plus grand ou Trier du plus grand au plus petit pour les champs de type numérique.




Commentaires

Published

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