| [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 14 : | Ligne 14 : | ||
{{Materials}} | {{Materials}} | ||
{{Tuto Step | {{Tuto Step | ||
| + | |Step_Title=Trier | ||
| + | |Step_Content=1- Sélectionnez une cellule de la colonne à trier. | ||
| + | |||
| + | 2- Cliquez sur l’onglet '''Accueil'''. | ||
| + | |||
| + | 3- Dans le groupe '''Édition''', cliquez sur l’icône '''Trier et filtrer'''. | ||
| + | |||
| + | 4- Cliquez sur filtrer | ||
|Step_Picture_00=Le_tri_simple_-_Excel_excel25.png | |Step_Picture_00=Le_tri_simple_-_Excel_excel25.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} | ||
| + | }} | ||
| + | {{Tuto Step | ||
| + | |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. | ||
| + | |||
| + | |||
| + | 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. | ||
| + | |Step_Picture_00=Le_tri_simple_-_Excel_excel27.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} | ||
}} | }} | ||
{{Notes}} | {{Notes}} | ||
Version du 15 janvier 2024 à 16:25
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
Étape 1 - Trier
1- Sélectionnez une cellule de la colonne à trier.
2- Cliquez sur l’onglet Accueil.
3- Dans le groupe Édition, cliquez sur l’icône Trier et filtrer.
4- Cliquez sur filtrer
É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.
Draft