Excel shortcuts
Keyboard shortcuts for Excel on Windows, for daily work and for training. There are two kinds, and only one of them depends on the language of your Excel.
Key combinations: the same in English and Dutch Excel
Hold the first keys down and press the last one, for example Ctrl+Shift+L. They work the same whatever language your Excel is in.
Ribbon sequences: different per language
Press Alt, let go, then press the letters one at a time, for example Alt, H, A, C. The letters come from the ribbon labels, so Dutch Excel uses other letters than English Excel. Press Alt in Excel and the letters appear on the ribbon.
For Excel for Microsoft 365 on Windows. On a Mac many shortcuts use Cmd instead of Ctrl.
Most used
- Jump to the last filled cell in that direction, the edge of the data.CtrlArrow key
- Go to the next sheet.CtrlPage Down
- Select up to the last filled cell in that direction.CtrlShiftArrow key
- Select the block of data around the active cell; press again for the whole sheet.CtrlA
- Edit the active cell, with the cursor at the end.F2
- Start a new line inside the same cell.AltEnter
- Copy the top cell of the selection into the cells below it.CtrlD
- Undo the last action.CtrlZ
- Open Paste Special, for example to paste only the values.CtrlAltV
- Open Format Cells.Ctrl1
- While editing a formula, cycle a reference through $A$1, A$1, $A1 and A1.F4
- Insert SUM for the cells above or to the left.Alt=
- Turn filter buttons on or off for the data around the active cell.CtrlShiftL
- Open the filter list of the column header you are on.AltDown arrow
- Turn the data into a table.CtrlTorCtrlL
- Insert a PivotTable from the selected table or range.English ExcelAlt, N, V, TAltNVTNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it.
- Paste values only.English ExcelAlt, H, V, VAltHVVNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it.
- Freeze panes at the active cell.English ExcelAlt, W, F, FAltWFFNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it.
Move around
| What it does | Keys |
|---|---|
| Jump to the last filled cell in that direction, the edge of the data. | CtrlArrow key |
| Go to cell A1. | CtrlHome |
| Go to the last used cell of the sheet. | CtrlEnd |
| Go to the next sheet. | CtrlPage Down |
| Go to the previous sheet. | CtrlPage Up |
| Open Go To, to jump to a cell or a named range. Its Special button selects, for example, blank cells, formulas or constants. | F5orCtrlG |
| Move one screen down. | Page Down |
Select
| What it does | Keys |
|---|---|
| Select up to the last filled cell in that direction. | CtrlShiftArrow key |
| Select the block of data around the active cell; press again for the whole sheet. | CtrlA |
| Select the whole column. | CtrlSpacebar |
| Select the whole row. | ShiftSpacebar |
| Extend the selection by one cell. | ShiftArrow key |
| Extend the selection to the last used cell of the sheet. | CtrlShiftEnd |
| Select only the visible cells of the selection, skipping hidden and filtered rows. | Alt; |
| Add another cell or range to the selection with the arrow keys. | ShiftF8 |
Enter and edit
| What it does | Keys |
|---|---|
| Edit the active cell, with the cursor at the end. | F2 |
| Start a new line inside the same cell. | AltEnter |
| Put what you typed into every selected cell. | CtrlEnter |
| Copy the top cell of the selection into the cells below it. | CtrlD |
| Undo the last action. | CtrlZ |
| Redo, or repeat the last action. | CtrlY |
| Copy. | CtrlC |
| Cut. | CtrlX |
| Paste. | CtrlV |
| Open Paste Special, for example to paste only the values. | CtrlAltV |
| Enter today's date as a fixed value. | Ctrl; |
| Enter the current time as a fixed value. | CtrlShift: |
| Insert cells, rows or columns. | CtrlShift+ |
| Delete the selected cells, rows or columns. | Ctrl- |
| Find. | CtrlF |
| Find and replace. | CtrlH |
Format
| What it does | Keys |
|---|---|
| Open Format Cells. | Ctrl1 |
| Bold on or off. | CtrlBorCtrl2 |
| Italic on or off. | CtrlIorCtrl3 |
| Underline on or off. | CtrlUorCtrl4 |
| Strikethrough on or off. | Ctrl5 |
| Number format: two decimals and a thousands separator. | CtrlShift! |
| Percentage format without decimals. | CtrlShift% |
| Currency format with two decimals. | CtrlShift$ |
| Date format with day, month and year. | CtrlShift# |
| Back to the General format. | CtrlShift~ |
| Put a border around the selection. | CtrlShift& |
| Hide the selected rows. | Ctrl9 |
| Hide the selected columns. | Ctrl0 |
Formulas
| What it does | Keys |
|---|---|
| While editing a formula, cycle a reference through $A$1, A$1, $A1 and A1. | F4 |
| Insert SUM for the cells above or to the left. | Alt= |
| Open Insert Function. | ShiftF3 |
| With the cursor right after a function name, open its argument dialog. | CtrlA |
| Show formulas instead of results, and back. | Ctrl` |
| Calculate all open workbooks. | F9 |
| Calculate the active sheet. | ShiftF9 |
| Select the cells that the formula in the active cell refers to directly (its precedents). | Ctrl[ |
| Select the cells with formulas that refer directly to the active cell (its dependents). | Ctrl] |
| While editing a formula, select a part of it and press F9 to see its value. Press Esc to keep the formula as it was. | F9 |
| Expand or collapse the formula bar, to read a long formula. | CtrlShiftU |
| Paste a named range into the formula. | F3 |
Data, tables and filters
| What it does | Keys |
|---|---|
| Turn filter buttons on or off for the data around the active cell. | CtrlShiftL |
| Open the filter list of the column header you are on. | AltDown arrow |
| Apply the current filter again after the data changed. | CtrlAltL |
| Turn the data into a table. | CtrlTorCtrlL |
| Flash Fill: complete the column from the pattern you started. | CtrlE |
| Show Quick Analysis for the selection. | CtrlQ |
| Refresh all data connections in the workbook. | CtrlAltF5 |
| Insert a chart of the selected data. | AltF1 |
Workbooks and sheets
| What it does | Keys |
|---|---|
| Save. | CtrlS |
| Save as. | F12 |
| Open a workbook. | CtrlO |
| Close the workbook. | CtrlW |
| Print. | CtrlP |
| Insert a new sheet. | ShiftF11 |
| Show or hide the ribbon. | CtrlF1 |
| Open the right-click menu. | ShiftF10 |
Ribbon key sequences
These sequences are for English Excel. Those marked "Not yet checked in Excel" have not been checked yet, so try them before you rely on them. A Dutch sequence is shown here only once it has been checked in Dutch Excel; the letters there follow the Dutch ribbon labels, so press Alt in Excel to see them.
| What it does | English Excel |
|---|---|
| Go to the Home tab. | Alt, HAltH |
| Go to the Insert tab. | Alt, NAltN |
| Go to the Page Layout tab. | Alt, PAltP |
| Go to the Formulas tab. | Alt, MAltM |
| Go to the Data tab. | Alt, AAltA |
| Go to the Review tab. | Alt, RAltR |
| Go to the View tab. | Alt, WAltW |
| Insert a PivotTable from the selected table or range. | Alt, N, V, TAltNVTNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Choose a fill color. | Alt, H, HAltHH |
| Center the cell contents. | Alt, H, A, CAltHAC |
| Open the borders menu. | Alt, H, BAltHB |
| Delete the column. | Alt, H, D, CAltHDC |
| Define a name for the selection. | Alt, M, M, DAltMMD |
| Paste values only. | Alt, H, V, VAltHVVNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Fit the column width to the contents. | Alt, H, O, IAltHOINot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Freeze panes at the active cell. | Alt, W, F, FAltWFFNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Remove duplicates. | Alt, A, MAltAMNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Split text into columns. | Alt, A, EAltAENot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Open the Sort dialog. | Alt, A, S, SAltASSNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Clear all filters. | Alt, A, CAltACNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Wrap text on or off. | Alt, H, WAltHWNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Insert a row above. | Alt, H, I, RAltHIRNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Delete the row. | Alt, H, D, RAltHDRNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
| Open the conditional formatting menu. | Alt, H, LAltHLNot yet checked in ExcelNot checked in Excel yet. The sequence follows the English ribbon labels; try it before you rely on it. |
No shortcut matches that search.
Key combinations are checked against Microsoft's shortcut pages in English and Dutch. Ribbon sequences are for English Excel, and those marked "Not yet checked in Excel" have not been checked there. Dutch sequences are added when they have been checked in Excel.