Most Excel shortcut lists are useless because they contain 200 entries and no guidance about which ones matter. Nobody memorizes 200 shortcuts. People memorize about fifteen and use them constantly.
The difference between someone who’s fast in Excel and someone who isn’t usually comes down to a handful of navigation and selection keys. Not formulas. Not obscure features. The ability to move around a 40,000-row sheet without touching the mouse.
This cheat sheet is organized by what you’re trying to do, with the highest-value shortcuts flagged. Windows keys are listed first, with Mac equivalents covered further down.
Table of contents
- How to actually learn these
- The ten that matter most
- Navigation shortcuts
- Selection shortcuts
- Editing shortcuts
- Formatting shortcuts
- Formula and data shortcuts
- Workbook and worksheet shortcuts
- Mac equivalents
- Turn Excel speed into a data career
- FAQs about Excel shortcuts
How to actually learn these
Don’t print this and pin it to your wall. That doesn’t work, and you know it doesn’t because you’ve tried.
What works is picking five shortcuts on Monday and forcing yourself to use only those for a week, even when reaching for the mouse would be faster in the moment. It’ll slow you down for about three days. By Friday they’re automatic and you’ve permanently upgraded.
The ten that matter most
If you learn nothing else from this page, learn these.
| Shortcut | What it does |
|---|---|
| Ctrl + Arrow key | Jump to the edge of the current data block. The single biggest speed gain in Excel. |
| Ctrl + Shift + Arrow key | Select everything from here to the edge of the data. |
| Ctrl + Home | Jump straight back to cell A1. |
| Ctrl + Shift + L | Turn filters on or off. |
| Alt + = | AutoSum the range above or beside you. |
| Ctrl + D | Fill down from the cell above. |
| F2 | Edit the active cell without double-clicking. |
| F4 | Cycle a cell reference through absolute and relative forms. |
| Ctrl + 1 | Open the Format Cells dialog. |
| Ctrl + T | Convert a range to a proper table. |
Ctrl plus an arrow key is the one to start with. On a large sheet it replaces thirty seconds of scrolling with a single keystroke, and it’s the foundation for the selection shortcuts below.
Navigation shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + Arrow key | Jump to the edge of the data region |
| Ctrl + Home | Move to cell A1 |
| Ctrl + End | Move to the last used cell |
| Home | Move to the start of the row |
| Ctrl + Page Down | Go to the next worksheet |
| Ctrl + Page Up | Go to the previous worksheet |
| Alt + Page Down | Move one screen to the right |
| Alt + Page Up | Move one screen to the left |
| Ctrl + G or F5 | Open the Go To dialog |
| Ctrl + F | Find |
| Ctrl + H | Find and replace |
| Ctrl + Backspace | Scroll back to the active cell |
Ctrl + Backspace is the one nobody knows. When you’ve scrolled somewhere and lost track of your selection, it snaps the view back instantly.
Selection shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + A | Select the current region, then the whole sheet if pressed again |
| Ctrl + Shift + Arrow key | Extend the selection to the edge of the data |
| Shift + Arrow key | Extend the selection one cell at a time |
| Ctrl + Space | Select the entire column |
| Shift + Space | Select the entire row |
| Ctrl + Shift + End | Select from here to the last used cell |
| Ctrl + Shift + Home | Select from here back to A1 |
| Ctrl + click | Add non-adjacent cells to the selection |
| Alt + semicolon | Select visible cells only, skipping hidden rows |
| Ctrl + Shift + spacebar | Select the entire worksheet |
Alt + semicolon is worth knowing if you work with filtered data. Copying a filtered range normally grabs the hidden rows too, which is a classic way to paste data you didn’t mean to.
Editing shortcuts
| Shortcut | Action |
|---|---|
| F2 | Edit the active cell |
| Ctrl + C | Copy |
| Ctrl + X | Cut |
| Ctrl + V | Paste |
| Ctrl + Alt + V | Paste Special |
| Ctrl + Z | Undo |
| Ctrl + Y | Redo |
| Ctrl + D | Fill down from the cell above |
| Ctrl + R | Fill right from the cell to the left |
| Ctrl + Enter | Fill the whole selection with what you just typed |
| Alt + Enter | Insert a line break inside a cell |
| Ctrl + semicolon | Insert today’s date as a static value |
| Ctrl + Shift + semicolon | Insert the current time |
| Ctrl + Shift + plus | Insert cells, rows, or columns |
| Ctrl + minus | Delete cells, rows, or columns |
Ctrl + Enter deserves a mention. Select a range, type a value or formula, then press it instead of Enter, and the whole selection fills at once. It’s faster than typing once and dragging.
Formatting shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + 1 | Open the Format Cells dialog |
| Ctrl + B | Bold |
| Ctrl + I | Italic |
| Ctrl + U | Underline |
| Ctrl + 5 | Strikethrough |
| Ctrl + Shift + 1 | Number format with two decimal places |
| Ctrl + Shift + 3 | Date format |
| Ctrl + Shift + 4 | Currency format |
| Ctrl + Shift + 5 | Percentage format |
| Ctrl + Shift + ampersand | Apply an outline border |
| Ctrl + Shift + underscore | Remove all borders |
Ctrl + 1 is the workhorse. Rather than memorizing every individual format shortcut, learn this one and pick what you need from the dialog.
Formula and data shortcuts
| Shortcut | Action |
|---|---|
| Alt + = | Insert AutoSum for the adjacent range |
| F4 | Cycle a reference between relative and absolute |
| Shift + F3 | Open the Insert Function dialog |
| Ctrl + grave accent | Show all formulas instead of their results |
| F9 | Recalculate all open workbooks |
| Ctrl + Shift + L | Toggle filters on and off |
| Alt + Down Arrow | Open the filter dropdown on the selected header |
| Ctrl + T | Convert the range to a table |
| Ctrl + Q | Open Quick Analysis for the selection |
| Ctrl + Shift + U | Expand or collapse the formula bar |
Ctrl + grave accent, the key above Tab, is the fastest way to audit a spreadsheet someone else built. It reveals every formula at once so you can see the structure instead of guessing at it. That matters when you’re working with VLOOKUP formulas you inherited from someone who left the company.
F4 is the other one worth drilling. When you’re writing a formula to copy across a range, cycling a reference to absolute is what stops the range drifting.
Workbook and worksheet shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + N | New workbook |
| Ctrl + O | Open |
| Ctrl + S | Save |
| F12 | Save As |
| Ctrl + P | |
| Ctrl + W | Close the workbook |
| Shift + F11 | Insert a new worksheet |
| Ctrl + Tab | Switch between open workbooks |
| Ctrl + F1 | Collapse or expand the ribbon |
Mac equivalents
The general rule: Command replaces Ctrl, and Option replaces Alt. So Command + C copies, Command + 1 opens Format Cells, and Command + Down Arrow jumps to the edge of your data.
A few worth calling out:
- Fill down is Command + D, same idea as Windows.
- AutoSum is Command + Shift + T on most Mac versions.
- Line break in a cell is Control + Option + Enter rather than Alt + Enter.
- Toggle absolute references is Command + T while editing a formula, not F4.
- Function keys often need the fn key held down, depending on your keyboard settings.
Microsoft maintains a full cross-platform list in its Excel keyboard shortcuts documentation, which is the right reference when a shortcut behaves differently on your version.
Turn Excel speed into a data career
Being fast in Excel is a real advantage, and it has a ceiling. Speed helps you work through a spreadsheet quickly. It doesn’t help when the dataset is two million rows or lives in a database you can’t open.
That’s where analyst skills start. If shortcuts have made you curious about what else is possible, the natural next steps are pivot tables for summarizing data and SQL for working past the size limits of a spreadsheet.
Coding Temple’s data analytics bootcamp takes you through that whole progression, from Excel to SQL, Python, and visualization tools, using project work built on realistic messy data. Career services run alongside the curriculum rather than after it.
Want to test the waters? The free data analytics course costs nothing. When you’re ready, apply to Coding Temple.
FAQs about Excel shortcuts
What is the most useful Excel shortcut?
Ctrl plus an arrow key. It jumps to the edge of your data block instead of scrolling, which is the biggest single time saver on large sheets. Adding Shift selects everything in between, which makes it the foundation for most other selection work.
How do I select all data in Excel with the keyboard?
Press Ctrl + A to select the current data region, then again to select the whole sheet. To select from your current cell to the end of the data, use Ctrl + Shift + End.
What does F4 do in Excel?
Inside a formula, F4 cycles a cell reference between relative, absolute, and mixed forms by adding or removing dollar signs. Outside a formula, it repeats your last action, which is handy for applying the same formatting several times.
How do I add a line break inside an Excel cell?
Press Alt + Enter on Windows or Control + Option + Enter on Mac while editing the cell. Pressing Enter alone just moves to the next cell.
Are Excel shortcuts the same on Mac and Windows?
Mostly, with Command replacing Ctrl and Option replacing Alt. Some differ, including AutoSum and toggling absolute references, and function keys often need the fn key held on a Mac.
How many Excel shortcuts should I learn?
Around fifteen covers the vast majority of daily work. Learn five at a time and use only those for a week before adding more. Trying to memorize a full list at once is why most people learn none of them.