Guide du cheat sheet
Excel raccourcis a apprendre en premier
Cette page rassemble 29 raccourcis clavier consultables pour Excel dans 5 categories. Commencez par les categories principales, puis imprimez la fiche si vous voulez la garder a portee de main.
- Changez d'onglet OS pour voir les raccourcis Windows, macOS ou Linux.
- Utilisez / pour lancer la recherche immediatement.
- Utilisez le mode comparaison entre plusieurs machines.
- Imprimez ou enregistrez la page en PDF compact.
Workbook & Files
5 shortcuts
Create new workbook
Ctrl+N
WinCtrl+N
Mac⌘N
Linux—
Open workbook
Ctrl+O
WinCtrl+O
Mac⌘O
Linux—
Save workbook
Ctrl+S
WinCtrl+S
Mac⌘S
Linux—
Imprimer workbook
Ctrl+P
WinCtrl+P
Mac⌘P
Linux—
Fermer workbook
Ctrl+W
WinCtrl+W
Mac⌘W
Linux—
Navigation
7 shortcuts
Move one cell up
↑
Win↑
Mac↑
Linux—
Move one cell down
↓
Win↓
Mac↓
Linux—
Move to edge of data region
Ctrl+Arrow
WinCtrl+Arrow
Mac⌘Arrow
Linux—
Go to cell A1
Ctrl+Home
WinCtrl+Home
MacFn+Ctrl+←
Linux—
Go to last used cell
Ctrl+End
WinCtrl+End
MacFn+Ctrl+→
Linux—
Next worksheet
Ctrl+PageDown
WinCtrl+PageDown
MacFn+Ctrl+↓
Linux—
Previous worksheet
Ctrl+PageUp
WinCtrl+PageUp
MacFn+Ctrl+↑
Linux—
Edition
7 shortcuts
Edition active cell
F2
WinF2
MacCtrl+U
Linux—
Fill down
Ctrl+D
WinCtrl+D
Mac⌘D
Linux—
Fill right
Ctrl+R
WinCtrl+R
Mac⌘R
Linux—
Insert current date
Ctrl+;
WinCtrl+;
MacCtrl+;
Linux—
Insert current time
Ctrl+Shift+;
WinCtrl+Shift+;
Mac⌘;
Linux—
Annuler
Ctrl+Z
WinCtrl+Z
Mac⌘Z
Linux—
Retablir
Ctrl+Y
WinCtrl+Y
Mac⌘Y
Linux—
Formules
5 shortcuts
Start formula
=
Win=
Mac=
Linux—
AutoSum
Alt+=
WinAlt+=
Mac⌘⇧T
Linux—
Show formulas
Ctrl+`
WinCtrl+`
MacCtrl+`
Linux—
Calculate worksheets
F9
WinF9
MacF9
Linux—
Insert function
Shift+F3
WinShift+F3
MacShift+F3
Linux—
Mise en forme
5 shortcuts
Gras
Ctrl+B
WinCtrl+B
Mac⌘B
Linux—
Italique
Ctrl+I
WinCtrl+I
Mac⌘I
Linux—
Souligner
Ctrl+U
WinCtrl+U
Mac⌘U
Linux—
Format cells dialog
Ctrl+1
WinCtrl+1
Mac⌘1
Linux—
Apply percent format
Ctrl+Shift+%
WinCtrl+Shift+%
Mac⌃⇧%
Linux—
Questions frequentes
What is the fastest way to find Excel shortcuts on this page?
Use the search box or press /, then type an action such as create new workbook.
Can I print this Excel shortcut cheat sheet?
Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.
Does this page include Windows and Mac shortcuts for Excel?
Yes. Use the OS tabs to switch between Windows and macOS shortcuts. For example, Create new workbook is Ctrl+N on Windows and ⌘N on macOS where available.
Advertisement