Using Excel without keyboard shortcuts is a bit like driving a car in first gear without shifting: you end up getting out of breath. Key combinations offer a considerable time saving, whether it’s navigating large tables, quickly entering a formula, or formatting a report. Here you will discover twenty tips to tame your workflow and turn your actions into automatic habits.
🚀 Ultra-fast navigation: with Ctrl + arrow and Ctrl + Page Up/Down, instantly reach the edge of your workspace or switch sheets without touching the mouse.
🎨 Express formatting: a few keys are enough to apply bold (Ctrl + B), set the Currency format (Ctrl + Shift + $), or reopen the cell dialog box with Ctrl + 1.
🧮 Formula mastery: edit in place (F2), recalculate an entire workbook (F9), or display all formulas at once (Ctrl + `).
🔧 Advanced tools: create a macro (Alt + F8), repeat your last action (F4), and switch to the VBA editor in seconds (Alt + F11).
Somaire
Why adopt keyboard shortcuts in Excel?
Beyond just saving clicks, shortcuts transform how you think about a task. Instead of searching for a button in the ribbon, your gaze stays focused on the worksheet. This continuous flow reduces the risk of errors and maintains your pace, whether you’re building a quick frequency histogram or experimenting with dynamic sequences using the SEQUENCE function.
The 20 essential keyboard shortcuts
Navigation and selection
- Ctrl + ↑/↓/←/→: jump to the edge of the active data region or toggle between filled and empty areas.
- Ctrl + Page Up / Page Down: switch sheets without leaving your keyboard.
- Ctrl + End / Home: instantly reach the last used cell or the starting point of your document.
- Shift + Arrow: extend the selection from one cell to another, ideal for highlighting a block before copying.
- Ctrl + Shift + *: instantly select the current region (contiguous data).
- Ctrl + G then enter the reference: go directly to any cell or range (faster than the ribbon).
Editing and Formatting
- Ctrl + C / Ctrl + V / Ctrl + X: classic, but indispensable for copying, pasting, and cutting.
- Ctrl + Z / Ctrl + Y: undo or redo your last action, valuable when testing a complex format.
- Ctrl + B / Ctrl + I / Ctrl + U: make text bold, italic, or underlined.
- Ctrl + Alt + L: create a structured table in a flash to then enjoy filters and automatic styles.
- Ctrl + Shift + $: apply the Currency format directly, a time saver for your financial statements.
- Ctrl + 1: open the Format Cells dialog box and set number, alignment, font, border, or fill without searching the ribbon.
Formulas and Calculations
Between entering and verifying your results, a few shortcuts can triple your speed. For example, when working on debugging a ROUNDUP formula, F2 allows you to edit the cell directly without having to double-click on the sheet.
- F2: switch from navigation mode to in-cell editing.
- Ctrl + D: propagate the formula or data from the cell above to the entire selection.
- Ctrl + `: toggle formula display to quickly detect an incorrect reference.
- F9: manual recalculation of the workbook.
- Ctrl + Alt + Enter: create a legacy array formula (useful with RAND or RANDBETWEEN).
- Ctrl + Shift + Enter: confirm an array with the old syntax (up to Excel 2019).
Sheet and File Management
- Ctrl + N: new workbook.
- Ctrl + S: save your changes immediately.
- Ctrl + Shift + S: open “Save As” to duplicate or move your file.
- Ctrl + P: access print preview.
- Ctrl + W or Ctrl + F4: close the active workbook.
- Ctrl + Tab: switch from one workbook to another when multiple documents are open.
Macros and Advanced Tools
- Alt + F8: run or manage your macros, essential for automating recurring tasks.
- Alt + F11: open the VBA editor to code your custom functions directly.
- F4: repeat the last action (whether formatting or special paste), an underrated shortcut to save precious seconds.
- Ctrl + Shift + U: expand or collapse the formula bar to better view a complex calculation.
- Ctrl + Shift + L: quickly toggle automatic filters on or off.
Summary Table
| Shortcut | Function |
|---|---|
| Ctrl + Arrow | Edge navigation |
| Ctrl + Page Up/Down | Sheet switching |
| Ctrl + B | Bold |
| Ctrl + 1 | Cell format |
| F2 | In-cell editing |
| Ctrl + D | Fill down |
| Alt + F8 | Macro management |
| F4 | Repeat last action |
| Ctrl + C / V / X | Copy / Paste / Cut |
| Ctrl + Z / Y | Undo / Redo |
| Ctrl + P | Print preview |
| Ctrl + Alt + L | Convert to table |
| Ctrl + Shift + $ | Currency format |
| Ctrl + ` | Show formulas |
| F9 | Manual recalculation |
| Ctrl + N | New workbook |
| Ctrl + S / Shift + S | Save / Save As |
| Alt + F11 | VBA editor |
| Ctrl + Tab | Switch workbook |
| Ctrl + Shift + L | Auto filters |
FAQ
- How do I customize my own shortcuts in Excel?
Go to File > Options > Customize Ribbon, then click Customize at the bottom. You can assign your keys to frequently used commands. - Do these shortcuts work on Mac?
Most are similar, but replace Ctrl with Cmd and Alt with Option. Some combinations are Windows-specific and have no direct equivalent. - How can I memorize all these shortcuts?
You can print the summary table, cut the shortcuts by theme, then gradually integrate them into your habits. The “Format Painter” tool (F4) is an excellent starting point.
