25 Excel Keyboard Shortcuts That Actually Save Time

Most shortcut lists are padded with Ctrl + C and Ctrl + V, which you already know. This is the 25 shortcuts that separate people who fight with Excel from people who fly through it, organized by the kind of work you’re actually doing — with notes on when each one pays off, because a shortcut you can’t connect to a real situation is one you’ll never use.

1. Jump to the edge of your data

Windows: Ctrl + Arrow key | Mac: Cmd + Arrow key

The single highest-value shortcut in Excel. From any cell, it jumps to the last filled cell in that direction. On a 50,000-row export, Ctrl + Down takes you to the bottom instantly. It’s also a data-quality check: if it stops at row 8,412 instead of the bottom, you just found a blank breaking your dataset.

2. Go to the start or end of the sheet

Windows: Ctrl + Home / Ctrl + End | Mac: Fn + Ctrl + Left Arrow / Fn + Ctrl + Right Arrow

Ctrl + Home snaps to A1 (or the top-left unfrozen cell, if you freeze panes in Excel). Ctrl + End jumps to the last used cell — also how you discover a “small” workbook secretly thinks its used range runs to row 1,048,576, the classic cause of bloated files.

3. Switch between sheets

Windows: Ctrl + Page Down / Ctrl + Page Up | Mac: Option + Right Arrow / Option + Left Arrow

In a workbook with a dozen tabs, clicking tiny tab names is a constant tax. This pays off most when cross-checking two adjacent sheets: tap back and forth without your eyes leaving the numbers.

4. Go To (and Go To Special)

Windows: F5 or Ctrl + G | Mac: Ctrl + G

Typing a cell reference beats scrolling, but the real prize is the Special button inside this dialog: select all blanks, all formulas, all constants, or visible cells only. Power move: Go To Special → Blanks, type 0, then Ctrl + Enter to fill every blank at once (see shortcut 19).

5. Find — and Find & Replace

Windows: Ctrl + F / Ctrl + H | Mac: Cmd + F / Ctrl + H

Obvious for finding a value; underrated for finding it across the whole workbook (set “Within” to Workbook). Find and replace in Excel also works inside formulas, making it the fastest way to repoint 200 formulas from Sheet1 to Sheet2.

Selection: grab exactly what you mean

6. Select to the edge of data

Windows: Ctrl + Shift + Arrow | Mac: Cmd + Shift + Arrow

Click the first cell of a column, press Ctrl + Shift + Down, and you’ve selected the entire column of data — not the whole worksheet column with a million empty cells trailing below. Essential when feeding a range into a chart or formula.

7. Select the current region

Windows: Ctrl + A | Mac: Cmd + A

Inside a block of data, this selects just that block; press it again for the whole sheet. It’s the two-keystroke setup for sorting, formatting, or copying a table without dragging across it.

8. Select the entire column

Windows: Ctrl + Space | Mac: Ctrl + Space

9. Select the entire row

Windows: Shift + Space | Mac: Shift + Space

These earn their keep in combos: Ctrl + Space then Ctrl + Minus deletes a column; Shift + Space then Ctrl + Shift + Plus inserts a row above. Once that’s in your fingers, restructuring a sheet stops involving the right-click menu entirely.

10. Select to the last used cell

Windows: Ctrl + Shift + End | Mac: Fn + Cmd + Shift + Right Arrow

From your current cell straight to the bottom-right of the data — the move when you need “everything from here down,” like clearing old data below a header before pasting a fresh export.

Formatting: skip the ribbon round-trip

11. Open the Format Cells dialog

Windows: Ctrl + 1 | Mac: Cmd + 1

Every formatting option in one dialog — number formats, borders, alignment, protection — including custom number formats the ribbon barely exposes. If you format anything more than once a day, this beats hunting through dropdowns every single time.

12. Apply currency or percentage format

Windows: Ctrl + Shift + $ / Ctrl + Shift + % | Mac: Ctrl + Shift + $ / Ctrl + Shift + %

Instant formatting for a whole selection. The percent one shines right after writing a ratio formula: you see 0.0734, hit Ctrl + Shift + %, and it reads 7%.

13. Line break inside a cell

Windows: Alt + Enter | Mac: Ctrl + Option + Return

Enter moves to the next cell, so people fake multi-line text with spaces or merged cells — both of which cause pain later. This puts a real new line inside an Excel cell, the right way to write multi-line headers and notes.

14. Repeat your last action

Windows: F4 | Mac: Cmd + Y

Apply a fill color to one cell, then walk through the sheet pressing F4 on every other cell that needs it. Insert a row, then F4, F4, F4 — three more rows. Anything you’d otherwise do with Format Painter repeatedly, F4 often does faster. (F4 has a second job inside formulas — see shortcut 17.)

15. Hide rows or columns

Windows: Ctrl + 9 (rows) / Ctrl + 0 (columns) | Mac: Cmd + 9 / Cmd + 0

When you’re presenting a model on a call and need helper columns out of sight right now, this beats right-clicking. There’s a full walkthrough of the hide rows shortcut in Excel, including the slightly fussier unhide combos.

Formulas: edit at speed

16. Edit the active cell

Windows: F2 | Mac: Ctrl + U

Drops you into edit mode with the cursor at the end of the formula. Bonus almost nobody knows: pressing F2 while editing toggles between Edit and Enter modes, which controls whether arrow keys move within the formula text or select cell references. If arrow keys have ever mangled a formula mid-edit, this is the fix.

17. Toggle absolute/relative references

Windows: F4 (while editing a formula) | Mac: Cmd + T

Cycles a reference through A1 → $A$1 → A$1 → $A1. Typing dollar signs by hand is for tourists. If you’re shaky on when to lock a reference, start with how absolute references in Excel work — then make this toggle muscle memory. Mac users with keyboard quirks should see the notes on the F4 key on Mac in Excel.

18. AutoSum

Windows: Alt + = | Mac: Cmd + Shift + T

Sits below a column of numbers and writes the SUM for you. Select multiple total cells under multiple columns first and it sums them all in one press.

19. Fill the selection with one entry

Windows: Ctrl + Enter | Mac: Ctrl + Return

Select a range, type a value or formula, press Ctrl + Enter, and every selected cell gets it — with relative references adjusting per cell. Combined with Go To Special → Blanks (shortcut 4), this fills every gap in a column in seconds. One shortcut, a shocking amount of copy-paste replaced.

20. Fill down / fill right

Windows: Ctrl + D / Ctrl + R | Mac: Cmd + D / Cmd + R

Copies the cell above (or to the left) into the selection, formulas included. Faster than copy-paste for extending a formula down a block, and unlike dragging the fill handle, it won’t overshoot by 400 rows when your hand slips.

Data: the working-with-real-datasets tier

21. Toggle filters

Windows: Ctrl + Shift + L | Mac: Cmd + Shift + F

Toggling filters off and on is also the fastest way to clear every active filter at once when a colleague hands you a sheet filtered six different ways. If you live in exported data, this fires dozens of times a day.

22. Create a table

Windows: Ctrl + T | Mac: Cmd + T

Converts the current region into a proper Excel table: auto-filters, banded rows, structured references, and ranges that grow with your data. Tables are also the cleanest foundation for pivot tables in Excel.

23. Paste values / Paste Special

Windows: Ctrl + Shift + V (Microsoft 365), or Ctrl + Alt + V for the full dialog | Mac: Cmd + Ctrl + V for the dialog

The “I want the numbers, not the formulas” shortcut — essential when copying calculated results into a summary sheet. On older versions without Ctrl + Shift + V, the dialog route still beats the ribbon; full details in paste values without formulas in Excel. The dialog also hides gems like Transpose.

24. Flash Fill

Windows: Ctrl + E | Mac: no default shortcut — use Data → Flash Fill

Type one example of the pattern you want — “Smith, John” extracted from a full-name column — and Ctrl + E fills the rest by inferring the pattern. For one-off cleanup of names, emails, or codes, it beats writing a text formula you’ll use once. See Flash Fill in Excel for what it can and can’t infer.

25. Insert today’s date or current time

Windows: Ctrl + ; (date) / Ctrl + Shift + ; (time) | Mac: Ctrl + ; (date) / Cmd + ; (time)

This stamps a static date — unlike the TODAY() function, it won’t change tomorrow. Exactly what you want for log entries, “last reviewed” columns, and timestamping incoming data.

How to actually make these stick

Don’t try to learn 25 shortcuts this week. Pick the three that map to your most repetitive annoyance — for most people that’s Ctrl + Arrow, Ctrl + Shift + Arrow, and F4 — and force yourself to use them for five working days, even when the mouse feels faster in the moment. Once those are automatic, add the next three. The compounding is real.

FAQ

Why don’t my F-key shortcuts work on a laptop?

Most laptops assign media functions (brightness, volume) to F1–F12 by default, so F4 alone changes your volume instead of repeating an action. Either hold Fn (Fn + F4), or enable “Use F1, F2, etc. as standard function keys” in your OS keyboard settings. This is why Excel for Mac offers Cmd + T as the reference toggle.

Are these shortcuts the same in Excel for the web?

Mostly. The core set here — Ctrl + Arrow, Ctrl + Shift + L, Ctrl + 1, Ctrl + ; — works in the browser. The exceptions are shortcuts the browser itself claims (Ctrl + F may invoke the browser’s find) and the legacy Alt-key ribbon sequences. When a shortcut is intercepted, Excel for the web usually shows a tooltip with the alternative.

What’s the difference between F4 to repeat and F4 in a formula?

Same key, two contexts. When you’re not editing a cell, F4 repeats your last action. When you are editing a formula with the cursor on a cell reference, it cycles that reference through absolute and mixed forms. Excel decides by context, so there’s no conflict in practice — it just confuses people the first time the “repeat” key starts adding dollar signs.

Is it worth learning the old Alt-key sequences like Alt, E, S, V?

If you’re on Windows and spend hours a day in Excel, yes — Alt followed by a letter sequence reaches every ribbon command without the mouse, and legacy sequences like Alt, E, S, V (Paste Special) still work. Mac users and lighter users can skip them; the 25 above cover the high-frequency work, and Alt sequences have no Mac equivalent.