==================================== Excel for the web raccourcis clavier ==================================== Publié pour la première fois le 28/11/2019 sur https://defkey.com/fr/microsoft-excel-for-the-web-raccourcis-clavier Excel for the web a 137 raccourcis et nous les avons énumérés ci-dessous. All overriding shortcuts ------------------------ Ctrl + Alt + Flèche gauche Rotate a shape or a picture to the left Alt + Flèche gauche (only works when Override browser shortcuts is active) Rotate a shape or a picture to the left Ctrl + Alt + Flèche droite Rotate a shape or a picture to the right Alt + Flèche droite (only works when Override browser shortcuts is active) Rotate a shape or a picture to the right Ctrl + Maj + E Flash Fill Ctrl + E (only works when Override browser shortcuts is active) Flash Fill Ctrl + Alt + = Insert Cells Ctrl + = (only works when Override browser shortcuts is active) Insert Cells Ctrl + Alt + - Delete Cells Ctrl + - (only works when Override browser shortcuts is active) Delete Cells Ctrl + Alt + 0 Hide columns Ctrl + 0 (only works when Override browser shortcuts is active) Hide columns Ctrl + Alt + 9 Hide rows Ctrl + 9 (only works when Override browser shortcuts is active) Hide rows Ctrl + Alt + Maj + L Turn on filtering for the selected cell Ctrl + Maj + L (only works when Override browser shortcuts is active) Turn on filtering for the selected cell Accessibility ------------- Maj + F10 Open context menu Alt + Maj + A Open shortcuts dialog Ctrl + Alt + Maj + H Read column header Ctrl + Alt + Maj + T Read row header Ctrl + Alt + Maj + Pg Préc Read column until active cell Ctrl + Alt + Maj + Pg Suiv Read column from active cell Ctrl + Alt + Maj + Debut Read row until active cell Ctrl + Alt + Maj + End Read row from active cell Alt + Win puis Q Move to Tell me box Alt puis Q Move to Tell me box Alt + Win puis F Open the File tab Alt + Win puis H Open the Home tab Alt + Win puis N Open the Insert tab Alt + Win puis A Open the Data tab Alt + Win puis R Open the Review tab Alt + Win puis W Open the View tab Alt + Win puis O Open the file in the Excel app Alt + Win Display or hide Key Tips Ctrl + Alt + Espace Access a dialog menu to move or size it Flèche gauche Move Left one cell Maj + Tab Move Left one cell Ctrl + F6 Move between the cells, sheet tabs, status bar, list of services, and the ribbon Ctrl + Maj + F6 Move between the cells, sheet tabs, status bar, list of services, and the ribbon Editing ------- Alt + Maj + Flèche droite Group data Alt + Maj + Flèche gauche Ungroup data Ctrl + Maj + V Paste Plain Text Ctrl + Retour Arrière Move Viewport To Active Cell Maj + F11 Insert new sheet Alt + F5 Refresh Ctrl + Alt + F5 Refresh All Alt + = Apply Auto Sum Ctrl + Maj + . Increase font size Ctrl + Maj + , Decrease font size Ctrl + Alt + Maj + F9 Full calculate Ctrl + X Cut Ctrl + C Copy Ctrl + V Paste Ctrl + D Fill Down Ctrl + R Fill Right Maj + F3 Insert Function Ctrl + K Insert hyperlink Ctrl + Y Redo the last action or Repeat the last command, if possible Ctrl + Z Undo Alt + Entrée Start a line in the same cell Maj + Entrée Complete cell entry and select the cell above Ctrl + L Insert table Suppr Read row from active cell F2 Move to the Tell me box F9 Read row until active cell Échap Cancel cell entry Entrée Complete cell entry and select the cell below Retour Arrière Clear selected cell and start editing File commands ------------- Ctrl + O Open Alt + F2 Save as Ctrl + P Print Ctrl + Alt + Maj + F2 Print Formatting ---------- Ctrl + Maj + 7 Apply an outline border Ctrl + 5 Apply strikethrough Ctrl + I Italics Ctrl + U Underline Ctrl + B Bold % Kalın Navigation ---------- Ctrl + Touches directionnelles Move to the edge of the current data region Flèche gauche Move to the previous cell or command Maj + Tab Move to the previous cell or command Ctrl + End Go to the last cell of used range Ctrl + Debut Go to cell A1 Alt + Flèche vers le haut Drill up Alt + Maj + Flèche vers le bas Open a filter menu when a table cell is selected Alt + Flèche vers le bas Open a filter menu or drill down Ctrl + G Go to a specific cell Ctrl + Maj + F4 Repeat Find, upward Maj + F4 Repeat Find, downward Ctrl + F Find Maj + F5 Find Ctrl + H Find and Replace Ctrl + Alt + Pg Suiv Switch to next sheet Ctrl + Alt + Pg Préc Switch to previous sheet Flèche vers le bas Move down one cell Tab Move right one cell Flèche droite Move right one cell Flèche vers le haut Move up one cell Debut Go to the beginning of the cell line Pg Suiv Move down one screen (28 rows) Pg Préc Move up one screen (28 rows) Objects ------- Ctrl + Alt + Flèche gauche Rotate a shape or a picture to the left Alt + Flèche gauche (only works when Override browser shortcuts is active) Rotate a shape or a picture to the left Ctrl + Alt + Flèche droite Rotate a shape or a picture to the right Alt + Flèche droite (only works when Override browser shortcuts is active) Rotate a shape or a picture to the right Alt + F1 Insert Chart Ctrl + Entrée Follow Hyperlink Review ------ Maj + F2 Insert comment Ctrl + Maj + F2 Insert comment Ctrl + F7 Spell check Selection --------- Ctrl + Maj + Touches directionnelles Extend selection to the last nonblank cell in the same column or row as the active cell Maj + Espace Select an entire row Ctrl + A Select all cells in the current region or sheet Ctrl + Espace Select an entire column Maj + Pg Suiv Extend selection down one screen (28 rows) Maj + Pg Préc Extend selection up one screen (28 rows) Maj + Debut Extend selection to the beginning of the cell data Maj + Touches directionnelles Select a range of cells View ---- Ctrl + Maj + E Flash Fill Ctrl + E (only works when Override browser shortcuts is active) Flash Fill Ctrl + Alt + = Insert Cells Ctrl + = (only works when Override browser shortcuts is active) Insert Cells Ctrl + Alt + - Delete Cells Ctrl + - (only works when Override browser shortcuts is active) Delete Cells Ctrl + Alt + 0 Hide columns Ctrl + 0 (only works when Override browser shortcuts is active) Hide columns Ctrl + Alt + 9 Hide rows Ctrl + 9 (only works when Override browser shortcuts is active) Hide rows Ctrl + Alt + Maj + L Turn on filtering for the selected cell Ctrl + Maj + L (only works when Override browser shortcuts is active) Turn on filtering for the selected cell Alt + Maj + F10 Show the field list for a linked data type Ctrl + Maj + F5 Show the card for a linked data type Alt + Maj + = Expand a collapsed group of cells (Show detail) Alt + Maj + - Collapse a group of cells (Hide detail) Ctrl + Maj + 0 Unhide columns Ctrl + Maj + 9 Unhide rows Ctrl + F1 Show/hide ribbon Ctrl + Alt + L Reapply Filter Dernière mise à jour (UTC): lundi 15 mars 2021 Defkey © Tous les droits sont réservés.