20 Excel keyboard shortcuts that actually save time

Jumping to the edge of a 10,000-row block with Ctrl + Arrow keys instead of scrolling with the mouse wheel.
Watch alongside this article
Public YouTube resources matched to this article's topic, functions, and practice goal.

Excel Keyboard Shortcuts Pros Swear By to x10 PRODUCTIVITY
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)
25 AWESOME Excel Keyboard Shortcuts (You Should Know)!
TrumpExcel
Open on YouTube (opens in a new tab)
Most Useful Excel Keyboard Shortcuts
Technology for Teachers and Students
Open on YouTube (opens in a new tab)A shortcut list is only useful if you learn from it, and nobody learns thirty shortcuts at once. So: these are grouped by the job they do, and the last section tells you which three to start with and how to make them stick.
Shortcuts are Windows. Mac differences are noted where they are not simply
Ctrl → Cmd.
Getting around
Ctrl + arrow — jump to the edge of the current block of data. From the top
of a column this lands on the last filled row, which is how you check “how many
rows is this?” without scrolling. If it shoots to row 1,048,576, you have found
a gap in your data — that is diagnostic information, not a misfire.
Ctrl + Home goes to A1. Ctrl + End goes to the last cell Excel
thinks has ever been used. When Ctrl + End lands miles past your real data,
that phantom range is why your file is 14MB; delete the empty rows and columns,
save, and reopen.
Ctrl + Page Up / Page Down — previous/next worksheet. (Mac: Fn +
Ctrl + arrow.)
Ctrl + G then a reference — go anywhere directly. Faster than scrolling
for a known destination.
Selecting
Ctrl + Shift + arrow — extend the selection to the edge of the block.
This is the single highest-value selection shortcut: Ctrl + Shift + Down
from a header selects the whole column of data however long it is, which is what
you want before formatting, charting, or summing.
Ctrl + A — the current data region on the first press, the whole sheet
on the second.
Ctrl + Space selects the column, Shift + Space the row. Inside
an Excel Table Ctrl + Space selects just
the table column, pressing again adds the header — far more useful than it
sounds.
Ctrl + Shift + End — from the current cell to the end of the used
range. The standard “select everything from here down” move.
Editing
F2 — edit in place rather than retyping. (Mac: Ctrl + U.) Also the
fastest way to see which cells a formula references, since they highlight in
colour.
Ctrl + D — fill down from the cell above. Select a formula cell plus the
range beneath it, press it, done. Ctrl + R does the same rightwards.
Faster and safer than dragging a fill handle, which happily overshoots.
Alt + = — AutoSum. Guesses the range above or to the left and inserts
SUM. Check the guess; it is usually right and occasionally catches a
subtotal.
Ctrl + ; — today’s date as a static value. Not TODAY(), which
changes every day. For “when did I do this”, static is almost always what you
meant. (Ctrl + Shift + ; gives the time.)
Ctrl + Shift + V — Paste Values, directly, in current Excel versions.
On older builds use Alt, E, S, V, Enter. Either way this is the
antidote to pasting a formula somewhere it makes no sense.
Ctrl + Z / Ctrl + Y — undo / redo. Worth knowing Excel’s undo stack
does not cover running a macro: a VBA routine cannot be undone, which is why
error handling matters there.
Ctrl + Shift + + inserts cells; Ctrl + - deletes them.
Formatting
Ctrl + 1 — Format Cells. The most valuable formatting shortcut on the
list, because one dialog holds number formats, alignment, borders, fill and
protection. Learning this one replaces five ribbon journeys.
Ctrl + T — convert a range to a Table. Thirty keystrokes’ worth of
downstream benefit: structured references, auto-expanding ranges, pivot sources
that grow by themselves.
Ctrl + B / I / U — bold, italic, underline.
Ctrl + Shift + $ / % / # — currency, percentage, date
formats.
Formulas
F4 — cycles a reference through A1 → $A$1 → A$1 → $A1 while
editing. The alternative is typing dollar signs by hand and getting them wrong,
which is the root cause of a large share of “the formula broke when I copied it”
problems. (Mac: Cmd + T.)
Outside formula editing, F4 repeats your last action — insert row, insert
row, insert row.
Ctrl + ` (grave accent, above Tab) — show formulas instead of
results, across the whole sheet. The fastest way to audit a workbook somebody
else built: you see the structure, the hard-coded numbers, and anything
inconsistent in one glance. Press again to return. It is step one of
the formula audit checklist.
F9 — with part of a formula selected in the formula bar, evaluates just
that fragment and shows the result. For debugging a nested formula this is the
most useful key on the keyboard. Press Esc, not Enter, when you are done
— Enter replaces your formula with the calculated value.
Ctrl + Shift + Enter — the legacy array-formula entry. Modern dynamic
arrays (UNIQUE, FILTER, SORT) do not need it, but you will meet it in
inherited workbooks and should recognise the {} braces it produces.
The system that beats memorising
Press and release Alt. Letters appear over every ribbon tab; press one and
letters appear over every command on it. Alt, H, O, I is autofit column
width. Alt, A, T is filter.
This matters because the sequences are stable, so your fingers learn them without you memorising anything, and it reaches every command in Excel rather than the few dozen with dedicated shortcuts. If you only take one thing from this page, take this.
Mac has no equivalent; use Cmd + Shift + / to search the menus instead.
Where to start
Do not try to learn twenty. Take three, use them for a week until they are automatic, then take three more.
The first three, in order:
Ctrl+Shift+ arrow — you select ranges constantly, and this is the one that stops you dragging.Ctrl+1— one dialog instead of hunting the ribbon.F4— eliminates a whole category of broken-formula bug.
Then Alt + =, Ctrl + D, and F9.
The trick that makes it stick: when you catch yourself reaching for the mouse for something you do often, undo it and do it again with the keyboard, slowly. Ten seconds now, every time, and in a fortnight you will not be thinking about it. Trying to switch everything at once just slows you down enough that you give up and go back to the mouse by Wednesday.
FREE EXCEL UPDATES
Get practical Excel tips in your inbox
New tutorials, tools, templates, and worked examples a few times a month. Unsubscribe anytime.
Go deeper with this skill
Save time by making common Excel actions faster without sacrificing accuracy. For this article, the goal is to practice: Grouped by the job they do, with the Mac equivalents and the three that are worth learning before any of the others. Plus the Alt-key system that gives you every ribbon command without memorising anything.
Practice workbook setup
Open a practice workbook with at least one data table, formulas, and a report area.
Practice workflow
- Pick five shortcuts that match work you do every week.
- Practice each shortcut in a real workflow, not in isolation.
- Combine navigation, selection, and formatting shortcuts into one repeated routine.
- Write the shortcuts on a small reference sheet until they become muscle memory.
Quality checks
- Speed improvements do not create accidental edits.
- You can undo or review the result after each shortcut-heavy action.
- The shortcut works in your Excel version and operating system.
Common mistakes
- Trying to memorize too many shortcuts at once.
- Using shortcuts faster than you can verify the selected range.
- Assuming Windows and Mac shortcuts are identical.
Next actions
- Choose one weekly task and time it before and after practicing shortcuts.
- Build a personal top-10 shortcut list by workflow, not alphabetically.
Formula focus: even if this workflow is not formula-heavy, add one check cell that confirms the final output still matches the source data.







