Excel Keyboard Shortcuts
Keyboard shortcuts are key combinations you press instead of clicking menus with your mouse. In Excel, they save you time on tasks you repeat dozens of times each day — copying cells, moving between sheets, selecting ranges, and more. Learning even ten shortcuts changes how fast you work.
Think of shortcuts as a remote control for your TV. You could walk up and press the buttons on the TV every time, but using the remote from your couch is faster. Shortcuts work the same way — same result, less effort.
How Shortcuts Work
Most Excel shortcuts use the Ctrl key combined with a letter or number. You press and hold Ctrl, tap the other key, then release both. On a Mac, use the Command (⌘) key instead of Ctrl for most shortcuts.
Essential Shortcuts for Everyday Use
File Operations
| Shortcut | What It Does |
|---|---|
| Ctrl + N | Open a new blank workbook |
| Ctrl + O | Open an existing file |
| Ctrl + S | Save the current workbook |
| Ctrl + W | Close the current workbook |
| Ctrl + P | Open the Print dialog |
| Ctrl + Z | Undo the last action |
| Ctrl + Y | Redo the last undone action |
Selecting Cells and Ranges
| Shortcut | What It Does |
|---|---|
| Ctrl + A | Select all cells in the sheet |
| Ctrl + Shift + End | Select from current cell to the last used cell |
| Ctrl + Shift + Home | Select from current cell to cell A1 |
| Shift + Arrow keys | Extend the selection one cell at a time |
| Ctrl + Spacebar | Select the entire column |
| Shift + Spacebar | Select the entire row |
Moving Around the Sheet
| Shortcut | What It Does |
|---|---|
| Ctrl + Arrow key | Jump to the edge of a data region in that direction |
| Ctrl + Home | Go to cell A1 |
| Ctrl + End | Go to the last used cell in the sheet |
| Ctrl + Page Down | Move to the next worksheet tab |
| Ctrl + Page Up | Move to the previous worksheet tab |
| F5 or Ctrl + G | Open the Go To dialog to jump to any cell |
Editing and Formatting
| Shortcut | What It Does |
|---|---|
| Ctrl + C | Copy selected cells |
| Ctrl + X | Cut selected cells |
| Ctrl + V | Paste copied or cut content |
| Ctrl + D | Fill down — copies the top cell into cells below |
| Ctrl + R | Fill right — copies the left cell into cells to the right |
| Ctrl + B | Bold the selected text or cells |
| Ctrl + I | Italicise the selected text or cells |
| Ctrl + U | Underline the selected text or cells |
| Ctrl + 1 | Open the Format Cells dialog |
| Alt + Enter | Insert a line break inside a cell |
| Delete | Clear the contents of selected cells |
| F2 | Edit the active cell directly |
Formula Shortcuts
| Shortcut | What It Does |
|---|---|
| Alt + = | Insert a SUM formula automatically |
| F4 | Toggle absolute/relative cell references ($A$1 → A$1 → $A1 → A1) |
| Ctrl + ` | Show all formulas in cells instead of their results |
| Ctrl + Shift + Enter | Enter an array formula (older Excel versions) |
| Shift + F3 | Open the Insert Function dialog |
A Real-World Shortcut Diagram
Imagine you have a table with 200 rows of sales data. You want to copy column B to column D. Without shortcuts:
Click column B header → Right-click → Copy → Click cell D1 → Right-click → Paste (5 mouse clicks, menu navigation)
With shortcuts:
Click column B header → Ctrl+C → Click D1 → Ctrl+V (2 mouse clicks + 2 key presses)
Multiply this across 50 similar tasks in a workday, and shortcuts save you 20–30 minutes every day.
Shortcuts for Working with Rows and Columns
| Shortcut | What It Does |
|---|---|
| Ctrl + Shift + + | Insert a new row or column |
| Ctrl + – | Delete the selected row or column |
| Alt + H + O + I | AutoFit column width |
| Alt + H + O + A | AutoFit row height |
Tips for Learning Shortcuts Faster
Start with just five shortcuts and use them every day for a week before adding more. Print a shortcut reference card and stick it near your monitor. The moment a shortcut becomes muscle memory, add the next one. Most experienced Excel users know 30–40 shortcuts and rarely touch menus for routine tasks.
Pay attention to the underlined letters in Excel menus. When you press Alt, Excel highlights letters in the Ribbon. Pressing those letters activates the command, which is another form of keyboard navigation without needing to memorise anything.
Quick Reference: Top 10 Must-Know Shortcuts
| Rank | Shortcut | Action |
|---|---|---|
| 1 | Ctrl + S | Save your work — use it constantly |
| 2 | Ctrl + Z | Undo a mistake instantly |
| 3 | Ctrl + C / V | Copy and paste |
| 4 | Ctrl + Arrow | Jump to data edges fast |
| 5 | Ctrl + Home | Go back to cell A1 |
| 6 | Alt + = | Auto-SUM selected range |
| 7 | F2 | Edit a cell without double-clicking |
| 8 | F4 | Lock cell references in formulas |
| 9 | Ctrl + 1 | Open Format Cells dialog |
| 10 | Ctrl + Page Down/Up | Switch between worksheets |
Keyboard shortcuts in Excel work across versions — Excel 2016, 2019, 2021, and Microsoft 365 all support the shortcuts listed here. A few differences exist on Mac, where Command replaces Ctrl, but the logic stays the same.