Excel keyboard shortcuts
The shortcuts worth knowing, grouped by what you are trying to do. Free, no sign-up.
Download the PDF (Windows and Mac)Move around
| Jump to the edge of the data | Ctrl+Arrow key |
| Go to the first cell (A1) | Ctrl+Home |
| Go to the last used cell | Ctrl+End |
| Go to the first cell of the row | Home |
| Scroll one screen down / up | Page Down or Page Up |
| Scroll one screen right / left | Alt+Page Down or Alt+Page Up |
| Next / previous worksheet | Ctrl+Page Down or Ctrl+Page Up |
| Go to a cell or named range | Ctrl+G or F5 |
| Move to the next / previous cell in a selection | Tab or Shift+Tab |
| Search the sheet | Ctrl+F |
| Jump to the edge of the data | Cmd+Arrow key |
| Go to the first cell (A1) | Control+Home |
| Go to the last used cell | Control+End |
| Go to the first cell of the row | Home |
| Scroll one screen down / up | Page Down or Page Up |
| Scroll one screen right / left | Option+Page Down or Option+Page Up |
| Next / previous worksheet | Control+Page Down or Control+Page Up |
| Go to a cell or named range | Control+G |
| Move to the next / previous cell in a selection | Tab or Shift+Tab |
| Search the sheet | Cmd+F |
Select
| Select the whole column | Ctrl+Space |
| Select the whole row | Shift+Space |
| Select everything (press again for the whole sheet) | Ctrl+A |
| Extend the selection one cell | Shift+Arrow key |
| Extend the selection to the edge of the data | Ctrl+Shift+Arrow key |
| Select the current region | Ctrl+Shift+* |
| Extend the selection to the start of the sheet | Ctrl+Shift+Home |
| Extend the selection to the last used cell | Ctrl+Shift+End |
| Select only the visible cells | Alt+; |
| Select cells that differ in a row | Ctrl+\ |
| Select the whole column | Control+Space |
| Select the whole row | Shift+Space |
| Select everything (press again for the whole sheet) | Cmd+A |
| Extend the selection one cell | Shift+Arrow key |
| Extend the selection to the edge of the data | Cmd+Shift+Arrow key |
| Select the current region | Cmd+A |
| Extend the selection to the start of the sheet | Cmd+Shift+Home |
| Extend the selection to the last used cell | Cmd+Shift+End |
| Select only the visible cells | Cmd+Shift+* |
| Select cells that differ in a row | Control+\ |
Edit a cell
| Edit the active cell | F2 |
| Cancel what you are typing | Esc |
| Start a new line inside a cell | Alt+Enter |
| Delete the contents of the selection | Delete |
| Delete the character left of the cursor | Backspace |
| Undo | Ctrl+Z |
| Redo / repeat the last action | Ctrl+Y or F4 |
| Insert the current date | Ctrl+; |
| Insert the current time | Ctrl+Shift+; |
| Add a note to a cell | Shift+F2 |
| Edit the active cell | F2 |
| Cancel what you are typing | Esc |
| Start a new line inside a cell | Control+Option+Enter |
| Delete the contents of the selection | Delete |
| Delete the character left of the cursor | Delete |
| Undo | Cmd+Z |
| Redo / repeat the last action | Cmd+Y |
| Insert the current date | Control+; |
| Insert the current time | Cmd+; |
| Add a note to a cell | Shift+F2 |
Copy, paste and fill
| Copy | Ctrl+C |
| Cut | Ctrl+X |
| Paste | Ctrl+V |
| Open Paste Special | Ctrl+Alt+V |
| Fill down from the cell above | Ctrl+D |
| Fill right from the cell on the left | Ctrl+R |
| Fill the selected cells with the same entry | Ctrl+Enter |
| Flash Fill | Ctrl+E |
| Copy the formula from the cell above | Ctrl+' |
| Copy the value from the cell above | Ctrl+Shift+" |
| Copy | Cmd+C |
| Cut | Cmd+X |
| Paste | Cmd+V |
| Open Paste Special | Control+Cmd+V |
| Fill down from the cell above | Control+D |
| Fill right from the cell on the left | Control+R |
| Fill the selected cells with the same entry | Control+Enter |
| Flash Fill | Control+E |
| Copy the formula from the cell above | Control+' |
| Copy the value from the cell above | Control+Shift+" |
Format
| Open the Format Cells box | Ctrl+1 |
| Bold | Ctrl+B |
| Italic | Ctrl+I |
| Underline | Ctrl+U |
| Strikethrough | Ctrl+5 |
| Number format with two decimals | Ctrl+Shift+! |
| Currency format | Ctrl+Shift+$ |
| Percent format | Ctrl+Shift+% |
| Date format | Ctrl+Shift+# |
| Time format | Ctrl+Shift+@ |
| General number format | Ctrl+Shift+~ |
| Add an outline border | Ctrl+Shift+& |
| Remove borders | Ctrl+Shift+_ |
| Center the cell contents | Alt+H, A, C |
| Open the Format Cells box | Cmd+1 |
| Bold | Cmd+B |
| Italic | Cmd+I |
| Underline | Cmd+U |
| Strikethrough | Cmd+Shift+X |
| Number format with two decimals | Control+Shift+! |
| Currency format | Control+Shift+$ |
| Percent format | Control+Shift+% |
| Date format | Control+Shift+# |
| Time format | Control+Shift+@ |
| General number format | Control+Shift+~ |
| Add an outline border | Cmd+Option+0 |
| Remove borders | Cmd+Option+- |
Formulas
| Start a formula | = |
| AutoSum the selected cells | Alt+= |
| Cycle between absolute and relative references | F4 |
| Show formulas instead of results | Ctrl+` |
| Calculate all open workbooks | F9 |
| Calculate the active sheet | Shift+F9 |
| Open the function list while typing | Ctrl+A |
| Insert a function (Insert Function box) | Shift+F3 |
| Enter an array formula (older Excel) | Ctrl+Shift+Enter |
| Expand or collapse the formula bar | Ctrl+Shift+U |
| Start a formula | = |
| AutoSum the selected cells | Cmd+Shift+T |
| Cycle between absolute and relative references | Cmd+T |
| Show formulas instead of results | Control+` |
| Calculate all open workbooks | F9 |
| Calculate the active sheet | Shift+F9 |
| Open the function list while typing | Control+A |
| Insert a function (Insert Function box) | Shift+F3 |
| Enter an array formula (older Excel) | Cmd+Shift+Enter |
| Expand or collapse the formula bar | Control+Shift+U |
Rows and columns
| Insert cells, rows or columns | Ctrl+Shift++ |
| Delete cells, rows or columns | Ctrl+- |
| Hide the selected rows | Ctrl+9 |
| Hide the selected columns | Ctrl+0 |
| Show hidden rows | Ctrl+Shift+( |
| Show hidden columns | Ctrl+Shift+) |
| Group the selected rows or columns | Alt+Shift+Right arrow |
| Ungroup | Alt+Shift+Left arrow |
| Insert cells, rows or columns | Control+Shift+= |
| Delete cells, rows or columns | Cmd+- |
| Hide the selected rows | Cmd+( |
| Hide the selected columns | Cmd+) |
| Show hidden rows | Cmd+Shift+( |
| Show hidden columns | Cmd+Shift+) |
| Group the selected rows or columns | Cmd+Shift+K |
| Ungroup | Cmd+Shift+J |
Data and tables
| Turn filters on or off | Ctrl+Shift+L |
| Open a filter drop-down | Alt+Down arrow |
| Create a table | Ctrl+T or Ctrl+L |
| Insert a chart on a new sheet | F11 |
| Insert a chart on the current sheet | Alt+F1 |
| Open the Create Names from Selection box | Ctrl+Shift+F3 |
| Open the Name Manager | Ctrl+F3 |
| Open the Quick Analysis tool | Ctrl+Q |
| Open the Find and Replace box | Ctrl+H |
| Turn filters on or off | Cmd+Shift+F |
| Open a filter drop-down | Option+Down arrow |
| Create a table | Control+T |
| Insert a chart on a new sheet | F11 |
| Open the Create Names from Selection box | Cmd+Shift+F3 |
| Open the Find and Replace box | Control+H |
Workbook and window
| Create a new workbook | Ctrl+N |
| Open a workbook | Ctrl+O |
| Save | Ctrl+S |
| Save As | F12 |
| Ctrl+P | |
| Close the workbook | Ctrl+W |
| Insert a new worksheet | Shift+F11 |
| Switch to the next open workbook | Ctrl+Tab |
| Minimise the ribbon | Ctrl+F1 |
| Show the ribbon keys (Key Tips) | Alt |
| Check spelling | F7 |
| Create a new workbook | Cmd+N |
| Open a workbook | Cmd+O |
| Save | Cmd+S |
| Save As | Cmd+Shift+S |
| Cmd+P | |
| Close the workbook | Cmd+W |
| Insert a new worksheet | Shift+F11 |
| Switch to the next open workbook | Control+Tab |
| Minimise the ribbon | Cmd+Option+R |
| Check spelling | F7 |
Shortcuts are for current Excel for Microsoft 365. On a Mac, some keys also need the Fn key on laptops. Several of these are shown in our short videos on the Microsoft 365 Training channel.