Microsoft Excel is one of the most widely used applications in the world, and keyboard shortcuts are the fastest way to get more done in it. Whether you are navigating large spreadsheets, formatting data, editing formulas, or managing worksheets, the right shortcuts can save you hours of work every week.
This guide covers the most practical Excel keyboard shortcuts organised by the tasks you perform most, so you can find what you need quickly and start using them immediately.
Navigation Shortcuts
Moving around spreadsheets efficiently is the foundation of working faster in Excel:
| Shortcut | Action |
|---|---|
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to the last cell with data |
| Ctrl + → / ← / ↑ / ↓ | Jump to the edge of the data region |
| Ctrl + G (or F5) | Open the Go To dialog |
| Ctrl + Page Down | Move to the next worksheet tab |
| Ctrl + Page Up | Move to the previous worksheet tab |
| Ctrl + F | Find |
| Ctrl + H | Find and Replace |
Tip: Ctrl + Arrow keys is one of the most powerful navigation shortcuts. In a column with thousands of rows of data, pressing Ctrl + ↓ instantly jumps to the last row of data instead of scrolling manually.
Selection Shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + A | Select the entire worksheet (or current data region first) |
| Ctrl + Shift + End | Select from the current cell to the last used cell |
| Ctrl + Shift + Home | Select from the current cell to cell A1 |
| Ctrl + Shift + Arrow | Select to the edge of the data region |
| Shift + Space | Select the entire row |
| Ctrl + Space | Select the entire column |
| Ctrl + Shift + L | Toggle AutoFilter on the selection |
Tip: Ctrl + Shift + Arrow is the selection version of Ctrl + Arrow. Use it to quickly select entire columns or rows of data without dragging the mouse.
Editing and Data Entry Shortcuts
| Shortcut | Action |
|---|---|
| F2 | Edit the active cell (enter edit mode) |
| Enter | Confirm entry and move down |
| Tab | Confirm entry and move right |
| Esc | Cancel the current entry |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + D | Fill down (copy the cell above into the current cell) |
| Ctrl + R | Fill right (copy the cell to the left) |
| Ctrl + Enter | Enter the same value into all selected cells simultaneously |
| Delete | Clear cell contents |
| Ctrl + ; (semicolon) | Insert today’s date |
| Ctrl + Shift + ; (semicolon) | Insert the current time |
Tip: Ctrl + Enter is incredibly useful. Select a range of cells, type a value, then press Ctrl + Enter. The value is entered into every selected cell at once. This is much faster than copying and pasting.
Formatting Shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 1 | Open Format Cells dialog |
| Ctrl + Shift + $ | Apply currency format |
| Ctrl + Shift + % | Apply percentage format |
| Ctrl + Shift + # | Apply date format |
| Ctrl + Shift + ~ | Apply general number format |
| Alt + H, O, I | AutoFit column width |
| Alt + H, O, A | AutoFit row height |
Tip: Ctrl + 1 opens the Format Cells dialog, which gives you full control over number formats, alignment, fonts, borders, and fills. It is the fastest way to access detailed formatting options.
Row, Column, and Sheet Management
| Shortcut | Action |
|---|---|
| Ctrl + Shift + + (plus) | Insert cells, rows, or columns |
| Ctrl + – (minus) | Delete cells, rows, or columns |
| Ctrl + Shift + Page Down | Select multiple worksheets |
| Shift + F11 | Insert a new worksheet |
| Alt + H, D, S | Delete the current worksheet |
| Ctrl + 9 | Hide selected rows |
| Ctrl + Shift + 9 | Unhide selected rows |
| Ctrl + 0 | Hide selected columns |
| Ctrl + Shift + 0 | Unhide selected columns |
Formula Shortcuts
| Shortcut | Action |
|---|---|
| = | Start a formula |
| Alt + = | AutoSum (instantly sums the adjacent column or row) |
| F4 | Toggle absolute/relative cell references ($A$1, A$1, $A1, A1) |
| Ctrl + ` | Show/hide formulas in all cells |
| Ctrl + Shift + Enter | Enter an array formula (legacy CSE arrays) |
| F9 | Recalculate all formulas |
| Ctrl + [ | Select all cells referenced by the current formula (trace precedents) |
| Ctrl + ] | Select all cells that reference the current cell (trace dependents) |
Tip: Alt + = (AutoSum) is a huge time-saver. Click below a column of numbers and press Alt + =. Excel automatically creates a SUM formula for the column above. Press Enter to confirm.
Tip: F4 is essential when building formulas. Instead of manually typing dollar signs to lock cell references, press F4 while the cursor is on a cell reference to cycle through absolute and relative reference options.
Workbook and File Shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + N | Create a new workbook |
| Ctrl + O | Open a workbook |
| Ctrl + S | Save |
| F12 | Save As |
| Ctrl + W | Close the current workbook |
| Ctrl + P | |
| Ctrl + F4 | Close Excel |
Useful Miscellaneous Shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + T | Convert data range to a Table |
| Alt + F1 | Insert a chart from the selected data |
| Ctrl + K | Insert a hyperlink |
| Ctrl + Shift + L | Toggle filters on/off |
| Alt + Enter | Start a new line within a cell |
| Ctrl + Shift + U | Expand or collapse the formula bar |
Tip: Ctrl + T converts a data range into a formatted Excel Table. Tables automatically expand when you add new data, include built-in filtering, and make formulas with structured references much easier to read.
How to Learn Shortcuts Faster
You do not need to memorise every shortcut at once. Here is a practical approach:
- Start with five — Pick the five shortcuts you think will save you the most time based on what you do daily in Excel.
- Force yourself to use them — Every time you reach for the mouse to do one of those tasks, stop and use the shortcut instead.
- Add more gradually — Once the first five become automatic, add another five.
- Use the Alt key — Pressing Alt by itself in Excel reveals key tips on the Ribbon, showing you the keyboard sequence for every button.
The most impactful shortcuts for everyday users are Ctrl + Arrow (navigation), Ctrl + Shift + Arrow (selection), Alt + = (AutoSum), Ctrl + 1 (Format Cells), and F4 (toggle absolute references). Master these five and you will immediately notice a difference in how quickly you work.