Créer un tableau - 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 7 : Ligne 7 :
 
|Type de contenu=Fiche action
 
|Type de contenu=Fiche action
 
|Difficulty=Easy
 
|Difficulty=Easy
 +
|Licence=CC-BY
 
|Duration=5
 
|Duration=5
 
|Duration-type=minute(s)
 
|Duration-type=minute(s)
−
|Licence=CC-BY
 
 
}}
 
}}
 
{{Introduction}}
 
{{Introduction}}
 
{{Materials}}
 
{{Materials}}
 
{{Tuto Step
 
{{Tuto Step
−
|Step_Title=Cliquer sur une valeur
+
|Step_Title=Sélectionner les valeurs
 
|Step_Content=Une fois la saisie de vos valeurs finalisée :  
 
|Step_Content=Une fois la saisie de vos valeurs finalisée :  
  
  
−
Sélectionnez '''une cellule dans vos données'''.
+
Sélectionnez '''la plage de votre tableau''' en faisant glisser votre souris sur les valeurs. '''Vous pouvez également cliquer n’importe où sur les valeurs, puis appuyer sur Ctrl+A pour sélectionner toutes les données.'''
  
 
<br />
 
<br />
−
|Step_Picture_00=Cr_er_un_tableau_-_Excel_Capture_d_cran_2024-02-20_152605.png
+
|Step_Picture_00=Cr_er_un_tableau_-_Excel_Capture_d_cran_2024-10-22_140919.png
 
}}
 
}}
 
{{Tuto Step
 
{{Tuto Step
−
|Step_Title=Onglet Insertion - Tableau
+
|Step_Title=Mettre sous forme de tableau
−
|Step_Content=# Cliquez sur l'onglet '''Insertion'''
+
|Step_Content=1- Dans l'onglet Accueil
−
# Cliquez sur '''Tableau'''
+
|Step_Picture_00=Cr_er_un_tableau_-_Excel_Capture_d_cran_2024-10-22_141007.png
−
|Step_Picture_00=Cr_er_un_tableau_-_Excel_Capture_d_cran_2024-02-20_153038.png
+
|Step_Picture_00_annotation={"version":"3.5.0","objects":[{"type":"image","version":"3.5.0","originX":"left","originY":"top","left":0,"top":-0.15,"width":1914,"height":119,"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/5/52/Cr_er_un_tableau_-_Excel_Capture_d_cran_2024-10-22_141007.png","filters":[]}],"height":37,"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.19,"width":513,"height":356,"fill":"rgb(0,0,0)","stroke":null,"strokeWidth":0,"strokeDashArray":null,"strokeLineCap":"butt","strokeDashOffset":0,"strokeLineJoin":"miter","strokeMiterLimit":4,"scaleX":1.17,"scaleY":1.17,"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/7/7b/Cr_er_un_tableau_-_Excel_Capture_d_cran_2024-02-20_153038.png","filters":[]},{"type":"textbox","version":"3.5.0","originX":"center","originY":"center","left":361,"top":24,"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":"textbox","version":"3.5.0","originX":"center","originY":"center","left":278,"top":219,"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":187.14,"top":54.22,"width":78.76,"height":31.78,"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":281.5,"top":34.5,"width":101,"height":17,"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.5,"x2":-50.5,"y1":-8.5,"y2":8.5,"x2a":-29.44956802419557,"y2a":13.06938875912638,"x2b":-32.10528114915791,"y2b":-2.7086715715322285},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":332,"top":26,"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":231,"top":43,"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":221.03,"top":103.45,"width":57.14,"height":58.15,"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":241.5,"top":170,"width":23,"height":68,"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":11.5,"x2":-11.5,"y1":34,"y2":-34,"x2a":-12.670170687216629,"y2a":-12.491148320684829,"x2b":2.4863258329225593,"y2b":-17.6176103789672},{"type":"wfarrow2circle","version":"3.5.0","originX":"center","originY":"center","left":253,"top":204,"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":230,"top":136,"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":416,"width":600}
 
 
}}
 
}}
 
{{Tuto Step
 
{{Tuto Step

Version du 22 octobre 2024 à 13:18

Dans ce tutoriel, vous apprendrez créer des tableaux sur Excel 2016.

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

Difficulté
Facile
Durée
5 minute(s)
Public
Professionnels, Grand public, Médiateurs
Licence
CC-BY
Type de contenu
Fiche action
Dans ce tutoriel, vous apprendrez créer des tableaux sur Excel 2016.
Difficulté
Facile
Durée
5 minute(s)
Public
Professionnels, Grand public, Médiateurs
Licence
CC-BY
Type de contenu
Fiche action
<languages />

Étape 1 - Sélectionner les valeurs

Une fois la saisie de vos valeurs finalisée :


Sélectionnez la plage de votre tableau en faisant glisser votre souris sur les valeurs. Vous pouvez également cliquer n’importe où sur les valeurs, puis appuyer sur Ctrl+A pour sélectionner toutes les données.


Cr er un tableau - Excel Capture d cran 2024-10-22 140919.png




Étape 2 - Mettre sous forme de tableau

1- Dans l'onglet Accueil




Étape 3 - Créer un tableau

Vérifiez que l'ensemble des données a été inclus dans la sélection en surbrillance verte.

  1. Cochez cette option si votre tableau comporte des en-têtes.
  2. Pour valider, cliquez sur OK.





Étape 4 -

Cr er un tableau - Excel Capture d cran 2024-02-20 153508.png




Commentaires

Published

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