Excel Keyboard Shortcuts That Save Time Every Day
Last updated: November 2026 · Windows shortcuts for Excel for Microsoft 365, Excel 2021, Excel 2019 and Excel 2016. On a Mac, use Cmd for most Ctrl shortcuts.
Reaching for the mouse dozens of times an hour adds up. People who work quickly in Excel are rarely faster typists; they simply know a handful of shortcuts that move them around the sheet, select data and apply formatting without hunting through the ribbon. You do not need to learn hundreds. Start with one group below, use those shortcuts for a week until they become automatic, then add the next group.
Moving around the sheet
| Shortcut | What it does |
|---|---|
| Ctrl + Arrow key | Jump to the edge of the current block of data. The single most useful navigation shortcut. |
| Ctrl + Home | Go to cell A1 (or the top-left unfrozen cell). |
| Ctrl + End | Go to the last used cell on the sheet. |
| Ctrl + Page Down / Page Up | Move to the next or previous worksheet. |
| F5 or Ctrl + G | Go To a cell address or named range; click Special for blanks, formulas, errors and more. |
| Ctrl + Backspace | Scroll back to show the active cell after you have scrolled away. |
Selecting cells
| Shortcut | What it does |
|---|---|
| Shift + Arrow key | Extend the selection one cell at a time. |
| Ctrl + Shift + Arrow key | Extend the selection to the edge of the data. Select a whole column of figures in one move. |
| Ctrl + A | Select the current data region; press again to select the whole sheet. |
| Shift + Space | Select the entire row. |
| Ctrl + Space | Select the entire column. |
| Ctrl + click | Add separate cells or ranges to the selection. |
Entering and editing data
| Shortcut | What it does |
|---|---|
| F2 | Edit the active cell with the cursor at the end. |
| Ctrl + Enter | Enter the same value or formula into every selected cell at once. |
| Alt + Enter | Start a new line inside the same cell. |
| Ctrl + D / Ctrl + R | Fill down from the cell above / fill right from the cell to the left. |
| Ctrl + ; | Insert today's date as a fixed value. |
| Ctrl + Shift + ; | Insert the current time. |
| Ctrl + E | Flash Fill: complete a pattern from an example. |
| Ctrl + Alt + V | Paste Special, for pasting values, formats or transposing. |
| Ctrl + Z / Ctrl + Y | Undo / redo or repeat the last action. |
A favourite trick combines two of these: select a range, press F5, choose Special > Blanks, type = and press the Up arrow, then press Ctrl + Enter. Every blank cell is filled with the value above it, which is perfect for completing a report exported with gaps under each group heading.
Formatting
| Shortcut | What it does |
|---|---|
| Ctrl + 1 | Open Format Cells, where every number, alignment, border and fill option lives. |
| Ctrl + B / I / U | Bold, italic, underline. |
| Ctrl + Shift + 1 | Number format with thousands separator and two decimals. |
| Ctrl + Shift + 5 | Percentage format. |
| Ctrl + Shift + 3 | Date format. |
| Ctrl + Shift + & | Add an outline border. |
| Alt, H, O, I | Auto-fit the selected columns. |
For more on making sheets readable, see Use of Formatting.
Working with formulas
| Shortcut | What it does |
|---|---|
| Alt + = | AutoSum the cells above or to the left. |
| F4 | While editing a reference, cycle through $A$1, A$1, $A1 and A1. See absolute and relative references. |
| Shift + F3 | Open the Insert Function dialog with help for each argument. |
| Ctrl + ` (grave accent, left of 1) | Show all formulas instead of results; press again to switch back. |
| F9 | Recalculate, or evaluate a selected part of a formula while editing. |
| Ctrl + [ | Jump to the cells a formula refers to. |
Rows, columns and sheets
| Shortcut | What it does |
|---|---|
| Ctrl + + | Insert cells, rows or columns (select whole rows first to insert rows). |
| Ctrl + - | Delete the selected cells, rows or columns. |
| Ctrl + 9 / Ctrl + 0 | Hide selected rows / columns. |
| Shift + F11 | Insert a new worksheet. |
| Alt + Shift + Right Arrow | Group selected rows or columns into an outline. |
Working with data
| Shortcut | What it does |
|---|---|
| Ctrl + T | Convert a range into an Excel Table. |
| Ctrl + Shift + L | Turn filters on or off. |
| Alt + Down Arrow | Open a filter or drop-down list in the active cell. |
| Ctrl + F / Ctrl + H | Find / Find and Replace. |
| Alt + F1 | Create a chart from the selected data on the same sheet. |
| Alt, N, V, T | Insert a pivot table. |
The Alt key: a shortcut for every command
Press and release Alt and small letters appear on every ribbon tab and button. Press the letters in turn to run any command without the mouse. For example, Alt, A, M opens Remove Duplicates and Alt, W, F, F freezes panes. You do not need to memorise these; follow the letters on screen and after a few repetitions your fingers remember them.
You can also add your most-used commands to the Quick Access Toolbar. They then get the shortcuts Alt + 1, Alt + 2 and so on, in the order they appear.
How to make shortcuts stick
- Choose three shortcuts a week and force yourself to use them instead of the mouse.
- Start with Ctrl + Arrow, Ctrl + Shift + Arrow and Ctrl + 1, which give the biggest time savings.
- Hover over a ribbon button: the tooltip often shows its shortcut.
- Print this page and keep it next to your keyboard for the first month.
Back to: all Excel tutorials.