[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 | + | |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= | + | |Complete=Published |
}} | }} |
Auteur Mathieu Demanet | Dernière modification 22/10/2024 par M.demanet en cours de rédaction ⧼frevu-button-review-label⧽
Manual-Les_bases_du_tableur_-_Excel_Microsoft_Excel_2013-2019_logo.svg.png
Si vous souhaitez trier vos valeurs sur plusieurs colonnes alors il faut ajouter des niveaux :
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.
Pour Ordre, sélectionnez une option (par exemple, De A à Z, Du plus petit au plus grand ou Du plus grand au plus petit).
Published
Vous avez entré un nom de page invalide, avec un ou plusieurs caractères suivants :
< > @ ~ : * € £ ` + = / \ | [ ] { } ; ? #