For IndividualsFor Analysts & FinanceFor Students & LearnersFor Teams & Automation
MENU
=ARTICLES

20 Excel keyboard shortcuts that actually save time

KEY.A1 CTRL + SHIFT + ↓ · SELECT
20 Excel keyboard shortcuts that actually save time — Excel example preview

Jumping to the edge of a 10,000-row block with Ctrl + Arrow keys instead of scrolling with the mouse wheel.

=YOUTUBE

Watch alongside this article

Public YouTube resources matched to this article's topic, functions, and practice goal.

video / Beginner

Most Useful Excel Keyboard Shortcuts

Technology for Teachers and Students

Open on YouTube (opens in a new tab)
Technology for Teachers and Students

Loading preview…

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:

  1. Ctrl + Shift + arrow — you select ranges constantly, and this is the one that stops you dragging.
  2. Ctrl + 1 — one dialog instead of hunting the ribbon.
  3. 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.

=PRACTICE

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

  1. Pick five shortcuts that match work you do every week.
  2. Practice each shortcut in a real workflow, not in isolation.
  3. Combine navigation, selection, and formatting shortcuts into one repeated routine.
  4. 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.