Excel Keyboard Shortcuts That Actually Save Time

A handful of keyboard shortcuts — navigation, selection, formatting, and a few editing ones — cover the vast majority of what slows people down clicking through menus. Learning roughly fifteen of them properly will save far more time than memorising fifty obscure ones you'll never actually use.

About fifteen years into using Excel daily, I watched a newer hire jump straight to the bottom of a several-thousand-row spreadsheet with Ctrl+End, then back to the top with Ctrl+Home, in about half a second each way, while I was still manually scrolling with the mouse wheel like I'd been doing the entire time I'd worked there. I distinctly remember feeling a bit foolish watching that happen, given how many years I'd spent doing it the slow way without ever once wondering if there was a better one.

What are the navigation shortcuts actually worth learning?

These move you around a large spreadsheet instantly, instead of scrolling.

Shortcut	What it does
Ctrl+Home	Jump to cell A1
Ctrl+End	Jump to the last used cell in the sheet
Ctrl+Arrow key	Jump to the edge of the current data block in that direction
Ctrl+Page Up/Down	Switch between worksheet tabs
Ctrl+G (or F5)	Open "Go To," to jump straight to a specific cell reference

Ctrl+Arrow is probably the single most useful one here. Pressing Ctrl+Down from the top of a column jumps straight to the last filled cell in that column, skipping instantly past hundreds or thousands of rows rather than scrolling through them.

What are the selection shortcuts that save the most clicking?

Shortcut	What it does
Ctrl+Shift+Arrow key	Select from the current cell to the edge of the data block
Ctrl+A	Select the entire data region (or whole sheet, pressed again)
Ctrl+Space	Select the entire column
Shift+Space	Select the entire row
Ctrl+Shift+End	Select from the current cell to the last used cell

Combine Ctrl+Shift+Arrow with the navigation shortcuts above and you can select a huge block of data — say, an entire column of 5,000 rows — in under a second, rather than dragging the mouse down and hoping you don't overshoot or stop short.

What's the quickest way to format cells without touching the ribbon?

Ctrl+1 opens the Format Cells dialog directly, which is genuinely one of the most underused shortcuts out there, since it jumps straight past several ribbon clicks to the exact dialog most formatting changes actually need — number formats, borders, alignment, all in one place.

A few other formatting shortcuts worth knowing:

• Ctrl+B / Ctrl+I / Ctrl+U — bold, italic, underline
• Ctrl+Shift+$ — apply currency formatting instantly
• Ctrl+Shift+% — apply percentage formatting instantly
• Ctrl+Shift+1 — apply a standard number format with two decimal places

Are there shortcuts for working with formulas specifically?

Yes, and a few of these pair well with other posts in this series.

• F4 — cycles through absolute and relative reference types in a formula, covered properly in my post on "absolute vs relative references" 
• Ctrl+` (the grave accent key, usually above Tab) — toggles between showing formula results and showing the actual formulas in every cell at once, which is handy for quickly auditing a sheet full of formulas
• Ctrl+Shift+Enter — used historically for legacy array formulas, though most of this is handled automatically now with dynamic arrays
• F2 — edits the currently selected cell directly, rather than having to double-click into it with the mouse
• Ctrl+T — instantly converts a selected range into an Excel Table, which I covered properly in my post on "Excel Tables" 

What about shortcuts for inserting or editing data quickly?

• Ctrl+; — inserts today's date as a static value into the current cell
• Ctrl+Shift+; — inserts the current time
• Alt+Enter — starts a new line within the same cell, instead of moving to the next one
• Ctrl+D — fills the selected cell(s) downward with the content of the cell above
• Ctrl+Z / Ctrl+Y — undo and redo, which most people know, but worth including since they're genuinely the most-used shortcuts in any spreadsheet session

Should I bother memorising all of these at once?

Honestly, no — trying to learn fifteen new shortcuts in one sitting rarely sticks. A better approach is picking two or three that solve whatever's currently slowing you down most (navigation if you're scrolling a lot, formatting if you're constantly in the ribbon) and using just those deliberately for a week or two until they become automatic, then adding a couple more. That's roughly how I eventually picked most of these up myself, a handful at a time rather than all at once.

FAQ

Do these shortcuts work the same way on Mac? Mostly, but Ctrl is generally replaced with Cmd on Mac, with a few exceptions — worth checking Excel's own shortcut reference if something doesn't behave as expected, since a handful genuinely differ rather than just swapping the key name.

Why doesn't Ctrl+Arrow jump where I expect it to? It jumps to the edge of a contiguous block of filled cells, so a single blank cell or row in the middle of your data will stop it short. This is actually a handy way to spot gaps in your data, since it tends to reveal exactly where the blank cells are.

Is there a shortcut to repeat my last action? Yes — F4 does this too, though only when you're not actively editing a formula (where it instead cycles reference types, as above). Pressed right after an action like applying formatting to one cell, F4 repeats that same action on the next cell you select.

Can I create my own custom shortcuts for things Excel doesn't have one for? Not directly through standard settings, though this is one of the places a simple macro can help, assigned to a custom keyboard shortcut — worth exploring once you're comfortable with the basics covered here.

What's the fastest way to see all of Excel's shortcuts in one place? Press and hold Alt on Windows, which overlays small letter badges on every ribbon command showing exactly which key combination triggers it — a genuinely useful way to discover shortcuts for things you didn't know had one.