Excel Shortcuts: Learn Them in Layers Instead of Memorizing 48
Excel has more keyboard shortcuts than anyone remembers, and a long list is a poor way to learn them. A list of 48 asks you to memorize everything at once. I’d learn them in layers, where each layer builds on the one before it, and stop whenever the next layer stops paying for itself.
The free Excel shortcuts cheat sheet fits 48 shortcuts on one landscape page in eight cards of six, with Windows and Mac keys side by side. The cards happen to fall into a sensible learning order.
Layer one: the Essentials card
Start with six: Save, Copy, Cut, Paste, Undo and Paste Special. On Windows these are Ctrl+S, Ctrl+C, Ctrl+X, Ctrl+V and Ctrl+Z. On a Mac, Cmd takes the place of Ctrl. Most people know the first five already, so the useful new one is Paste Special, which is Ctrl+Alt+V on Windows and Cmd+Ctrl+V on Mac.
If you stop here for a week, you have still removed a lot of reaching for the mouse.
Layer two: the arrow keys and Shift
This layer is the biggest return for the effort, because it is a single idea applied twice.
Ctrl+Arrow jumps to the edge of your data. Ctrl+Home jumps to the start of the sheet, and Ctrl+End to the last cell you used. That is the Move around card. Add Shift to each of them and you get the Select card: Ctrl+Shift+Arrow selects up to the edge of your data, and Ctrl+Shift+Home and Ctrl+Shift+End select all the way to the start of the sheet or the last used cell. On a Mac the arrow versions are Cmd+Arrow and Shift+Cmd+Arrow.
Get Wakhid Wicaksono’s stories in your inbox
Join Medium for free to get updates from this writer.
The Select card also has Shift+Space for an entire row, Shift+Arrow to extend by one cell, and Ctrl+A (Cmd+A on Mac) for the whole sheet. Once you see that selecting is moving with Shift held down, ten shortcuts become one habit.
Layer three: editing, formatting and formulas
Now the keys that change cells instead of moving between them. Three of them are worth learning first:
- F2 edits the active cell.
- Ctrl+D runs Fill Down, which copies the top cell of a selection into the cells below it.
- Alt+Enter starts a new line inside a cell on Windows, and Option+Return does it on a Mac.
The Formulas card adds AutoSum (Alt+= on Windows, Shift+Cmd+T on Mac), a key that cycles the $ signs in a reference, and a toggle that shows formulas instead of results. The Format card and the card for rows, columns and tables cover inserting, deleting and hiding, and creating tables. I’d learn those only when you catch yourself clicking through the same menu twice in an afternoon.
The Windows and Mac differences
Of the 48 rows on the sheet, 24 have different keys on Windows and Mac. Some are close to what you would guess, such as Cmd for Ctrl. Others are not: collapsing the ribbon is Ctrl+F1 on Windows and Cmd+Option+R on Mac, and AutoSum moves from Alt+= to Shift+Cmd+T.
Microsoft notes that many Windows shortcuts that use Ctrl also work with the Control key in Excel for Mac, and that not all of them do. Where the Mac uses a different key, the sheet shows the Mac key. On a MacBook you also need the Fn key to reach Home, End and the Page keys, which affects layer two directly.
The last layer, Windows only
Pressing Alt and then a letter opens a ribbon tab: Alt+H for Home, Alt+N for Insert, Alt+P for Page Layout, Alt+M for Formulas, Alt+A for Data and Alt+W for View. The sheet lists these on the last card. There is no Mac equivalent, so that column reads None. It is the layer I’d leave for last, since each tab opens a second set of letters to learn.
Where the shortcuts come from
Every shortcut was checked against Microsoft’s support page Keyboard shortcuts in Excel, using its Windows tab and its macOS tab, on October 2, 2026. Keys can change between Excel versions and keyboard layouts, so a shortcut that does nothing on your machine is worth checking against that page.
Printing it
The free Excel shortcuts cheat sheet is a one-page PDF in US Letter and A4, with no email or account needed. The text prints at 8 points or larger at actual size, which is readable at arm’s length when it is taped next to the monitor.
Pick the layer you will use this week, and keep the printed sheet nearby for the others.
