| [version en cours de rédaction] | [version en cours de rédaction] |
| (Une révision intermédiaire par le même utilisateur non affichée) | |||
| Ligne 44 : | Ligne 44 : | ||
}} | }} | ||
{{Tuto Step | {{Tuto Step | ||
| − | + | |Step_Content=1-La flèche d’en-tête colonne se transforme en forme "d'entonnoir" '''icône Filtrer.''' | |
| − | |Step_Content= | ||
| − | La flèche d’en-tête colonne se transforme en forme "d'entonnoir" '''icône Filtrer.''' | ||
| − | Sélectionnez cette icône pour '''modifier''' ou '''supprimer''' le filtre. | + | 2-Sélectionnez cette icône pour '''modifier''' ou '''supprimer''' le filtre. |
| − | + | |Step_Picture_00=Filtrer_-_Excel_Filtrer_-_Excel_Capture_d_cran_2024-02-21_114518.png | |
| − | |Step_Picture_00=Filtrer_-_Excel_Capture_d_cran_2024-02-21_114518.png | + | |Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":-0.13,"width":1207,"height":427,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.5,"scaleY":0.5,"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/3/3a/Filtrer_-_Excel_Filtrer_-_Excel_Capture_d_cran_2024-02-21_114518.png","filters":[]},{"type":"wfarrow2line","version":"3.5.0","originX":"center","originY":"center","left":537,"top":9,"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":487,"top":9,"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":587,"top":9,"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":527.04,"top":57.45,"width":127.56,"height":18.38,"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":212,"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.13,"width":1207,"height":427,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":0.5,"scaleY":0.5,"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/ | ||
}} | }} | ||
{{Notes}} | {{Notes}} | ||
Version actuelle datée du 22 octobre 2024 à 13:42
Dans ce tutoriel, vous apprendrez à filtrer 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
- Tutoriels prérequis
Tutoriels prérequis
Étape 1 - Tableau
Si vos valeurs se trouvent dans un tableau, vous pouvez filtrer directement.
Retrouver le tutoriel pour créer des tableaux dans les prérequis juste au-dessus.
Étape 2 - En-tête
- Cliquez sur la flèche d’en-tête de colonne
Étape 3 - Déselectionner
Décochez (Sélectionner tout) afin de tout désélectionner.
Étape 4 - Sélectionner
- Cochez les cases que vous voulez afficher dans le liste déroulante.
- Cliquez sur Ok pour valider.
Étape 5 -
1-La flèche d’en-tête colonne se transforme en forme "d'entonnoir" icône Filtrer.
2-Sélectionnez cette icône pour modifier ou supprimer le filtre.
Published