Excel for the web raccourcis clavier

Excel for the web

Zeynel Abidin Öztürk -
11 mois
- Raccourcis
Ctrl + Alt +

Rotate a shape or a picture to the left

Alt +

(only works when Override browser shortcuts is active) Rotate a shape or a picture to the left

Ctrl + Alt +

Rotate a shape or a picture to the right

Alt +

(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

↑   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

ou Alt puis Q
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

Move Left one cell

ou ↑   Maj + ⭾ Tab
Ctrl + F6

Move between the cells, sheet tabs, status bar, list of services, and the ribbon

ou Ctrl + ↑   Maj + F6
Alt + ↑   Maj +

Group data

Alt + ↑   Maj +

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

Ctrl + ↑   Maj + 7

Apply an outline border

Ctrl + 5

Apply strikethrough

Ctrl + I

Italics

Ctrl + U

Underline

Ctrl + B

Bold % Kalın

Ctrl + ← ↑ → ↓

Move to the edge of the current data region

Move to the previous cell or command

ou ↑   Maj + ⭾ Tab
Ctrl + End

Go to the last cell of used range

Ctrl + Debut

Go to cell A1

Alt +

Drill up

Alt + ↑   Maj +

Open a filter menu when a table cell is selected

Alt +

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

ou ↑   Maj + F5
Ctrl + H

Find and Replace

Ctrl + Alt + Pg Suiv

Switch to next sheet

Ctrl + Alt + Pg Préc

Switch to previous sheet

Move down one cell

⭾ Tab

Move right one cell

ou

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)

Ctrl + Alt +

Rotate a shape or a picture to the left

Alt +

(only works when Override browser shortcuts is active) Rotate a shape or a picture to the left

Ctrl + Alt +

Rotate a shape or a picture to the right

Alt +

(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

Ctrl + ↑   Maj + F2

Insert comment

ou ↑   Maj + F2
Ctrl + F7

Spell check

Ctrl + ↑   Maj + ← ↑ → ↓

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 + ← ↑ → ↓

Select a range of cells

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


Partager cette page sur:

Informations sur le programme

Nom du programme: Excel for the web Excel for the web (Productivité)

Page Web: office.com/launch/excel

Dernière mise à jour: 28 nov. 2019

Nombre de raccourcis: 137

Comment facile d'appuyer sur les raccourcis: 70%

Plateforme détectée: Windows ou Linux (Pas macOS)

Programmes similaires



Publicité

Abonnez-vous!

Votre email reste confidentiel et nous ñ'envoyons pas de spam.