July 2026 · 6 min read

The 12 Excel Shortcuts That Actually Save Time (and 4 Everyone Recommends but Nobody Uses)

Every Excel shortcut list has the same problem: it treats Ctrl+C and some six-key ribbon sequence as equally important. They're not. Shortcut value is a simple equation — how often you'd use it, times how much slower the mouse version is. Sorted that way, the list gets short and surprisingly opinionated.

The twelve

1. Ctrl + Arrow keys. Jump to the edge of your data in any direction. If you currently scroll to the bottom of long spreadsheets, this one shortcut will save you more cumulative time than everything else on this page combined.

2. Ctrl + Shift + Arrow keys. The same jump, selecting everything on the way. "Select this whole column of data" becomes one keystroke instead of a click-and-drag marathon where you overshoot the end twice.

3. Ctrl + D. Fill down. Select a formula cell plus the empty cells below it (see #2), press Ctrl+D, done. The drag-the-tiny-fill-handle era of your life is over.

4. F4 while editing a formula. Cycles the current reference through absolute/mixed/relative ($A$1 → A$1 → $A1 → A1). Typing dollar signs by hand marks you as self-taught; F4 marks you as someone who suffered and learned.

5. F4 after an action. The same key's other job: repeat whatever you just did. Formatted a cell yellow? Select another cell, F4, it's yellow too. Works for inserting rows, deleting, most formatting.

6. Alt + = (AutoSum). Sums the obvious range in one keystroke. It even guesses the right range most of the time, and when it doesn't, you'll adjust with Ctrl+Shift+Arrows because you learned #2.

7. Ctrl + T. Turns a range into a proper Table: formulas auto-fill new rows, headers stay visible, and filtering is built in. Most "my spreadsheet is fragile" problems disappear inside Tables.

8. Alt + Enter. A line break inside a cell. Judging by search volume, half of humanity has wondered how to do this.

9. F2. Edit the active cell, and while editing, Excel color-codes every referenced cell. This is also the fastest way to audit a formula you didn't write.

10. Ctrl + Page Up / Page Down. Switch between sheet tabs. Weirdly unknown, instantly habit-forming in multi-sheet workbooks.

11. Ctrl + ; (semicolon). Insert today's date as a static value. Ctrl+Shift+; does the current time. Perfect for logs and "last updated" cells that shouldn't recalculate.

12. Ctrl + Alt + V. Paste Special. Press V again for Values — stripping formulas down to their results, the paste variant everyone needs weekly.

The four you can skip

Ctrl + Shift + $ / % / # (number formats). They exist, every list includes them, and you will never remember which symbol does what. The Home ribbon dropdown loses you two seconds; forgetting a symbol shortcut loses you ten.

Ctrl + 9 / Ctrl + 0 (hide row/column). Fine, but hiding via right-click is nearly as fast, and the unhide shortcuts are broken or blocked on many systems anyway.

Alt + H, O, I (auto-fit column). Beloved by finance professionals who do it two hundred times a day. If that's you, learn it. If you widen columns twice a week, double-clicking the column border does the same thing.

Shift + F11 (new sheet). The + button is right there and your hand is already on the mouse.

How to actually make these stick

Don't study the list. Pick numbers 1 through 3 — just those — and use them exclusively for one week, even when the mouse feels faster in the moment. They'll be automatic by Friday. Then add the next batch. Our full Excel cheat sheet has all of them organized by task when you're ready, plus a printable version for your desk.