Excel Tutorials · Free Download
One page, over 200 shortcuts, laid out by modifier key so every Ctrl combination sits together, every Alt combination sits together, and the function keys have their own row along the bottom. Print it, pin it next to your monitor, and stop reaching for the mouse.
The full one page reference, print ready in landscape. No login, no email required.
The sheet is laid out by modifier key. Every Alt combination sits in one block, every Ctrl combination in the next, then the Ctrl Shift combinations, the Alt sequences that walk the ribbon, and a row of all twelve function keys along the bottom. Your hands already know which modifier they are holding, so that is the fastest thing to scan for.
It covers over 200 shortcuts, which is deliberately more than anyone needs. The point is not to memorize the sheet, it is that when you wonder whether there is a faster way to do something, the answer is on the wall rather than three search results deep.
Keys are color coded the same way throughout, so Ctrl, Alt, Shift and the function keys are instantly distinguishable at a glance rather than blurring into a wall of text. Multi key ribbon sequences, like Alt W F R to freeze the top row, are written out in the order you press them.
It fits on a single sheet of letter paper in landscape, which is the entire point. A cheat sheet you have to scroll is a webpage, and a webpage means leaving the spreadsheet you were working in, which is exactly the interruption a shortcut was supposed to save you.
Five steps, and the second one is the one people skip.
Print at 100% scale in landscape rather than Fit to Page, which shrinks the keycaps until they are hard to read from arm's length. Tape it to the wall beside your monitor, not inside a drawer.
Nobody learns a hundred shortcuts at once, and attempting it is how people end up learning none of them. Choose the three actions you repeat most in a normal working day. For most people that is selecting a column of data, summing it, and pasting values.
For one week, refuse to use the ribbon or the right click menu for those three actions. The two second pause while you glance at the sheet is not wasted time, it is the repetition that builds the habit.
On Windows, tapping Alt puts a letter badge on every ribbon tab, and tapping that letter labels everything inside it. This means you can reach any command in Excel from the keyboard without memorizing it first, and the sequences you repeat start sticking on their own.
When your hands do the first three without you thinking about it, cross them off and pick three more from the sheet. Most people stop needing the paper within about a month.
| Shortcut | What It Does |
|---|---|
| Ctrl + Shift + Arrow | Select to the edge of the data |
| Alt + = | AutoSum, with the range guessed for you |
| F4 | Lock a reference to $A$1, or repeat the last action |
| Ctrl + Alt + V | Paste Special, including values only |
| Ctrl + Shift + L | Turn filters on and off |
| Ctrl + T | Convert a range into a real table |
| Ctrl + E | Flash Fill from one typed example |
| Ctrl + D | Fill down into every selected cell |
| Alt + Enter | Line break inside a cell |
| Ctrl + 1 | Format Cells dialog, every option in one box |
If you only ever learn ten shortcuts, learn these. Each one replaces something most people currently do with several mouse clicks, a menu hunt, or a lot of scrolling. Everything here is on the printable sheet, alongside roughly two hundred more.
Moving around a large sheet without touching the scroll bar.
Moves to the last filled cell in that direction, or to the next block of data if there is a gap. This is the single most useful navigation shortcut in Excel and the foundation of the selection shortcut below it.
Home jumps to cell A1, End jumps to the last used cell on the sheet. Ctrl + End is also a quick diagnostic, since a sheet that jumps to row 40,000 usually has stray formatting inflating the file size.
Moves to the next or previous worksheet. Faster than clicking tabs in a workbook with a dozen sheets, and it works even when tabs are scrolled out of view.
Type any cell address or named range to jump straight there. Its real power sits behind the Special button, which selects only blanks, only formulas, or only visible cells, and turns several manual cleanup tasks into one step.
Getting the right range highlighted before you do anything to it.
Extends the selection all the way to the edge of the data in that direction. Combining it in two directions, down then right, selects an entire rectangular data block in two keystrokes regardless of how many rows it holds.
Selects the entire column or the entire row containing the active cell. Both work with the insert and delete shortcuts, so Shift + Space followed by Ctrl + minus deletes a whole row without ever leaving the keyboard.
Selects the contiguous block of data around the active cell rather than the whole sheet, which is usually what you actually wanted. Press it a second time to expand to everything.
After filtering or hiding rows, this restricts the selection to what you can see, so copying does not silently drag hidden rows along with it. One of the most common causes of a paste that contains rows nobody expected.
Writing and auditing formulas without the mouse.
Inserts a SUM formula and guesses the range above or to the left, correctly the large majority of the time. Select a whole row and column of empty cells beneath a data block first and it fills in every total at once.
With the cursor on a reference inside a formula, F4 cycles A1 to $A$1 to A$1 to $A1 and back. Getting this right is the difference between a formula that copies down correctly and one that quietly drifts.
Switches the sheet from displaying results to displaying the formulas themselves, which is the fastest way to audit a spreadsheet somebody else built. Press it again to switch back.
Highlight a section of a long formula in the formula bar and press F9 to see what that fragment alone returns. Press Escape rather than Enter afterwards, or the fragment is replaced with its hardcoded value.
| Shortcut | Result |
|---|---|
| Ctrl + 1 | Format Cells dialog |
| Ctrl + Shift + $ | Currency format |
| Ctrl + Shift + % | Percent format |
| Ctrl + Shift + # | Date format |
| Ctrl + Shift + ! | Comma format, two decimals |
| Ctrl + Shift + ~ | General format, strips formatting |
| Ctrl + Shift + & | Border around the selection |
Number formatting is where the most clicking happens in a normal day and where these save the most time. Ctrl + Shift + tilde is the quiet useful one, since it strips a cell back to General when a stray date or currency format has been applied to something that should be a plain number.
Further down the sheet, past the ones everybody already uses.
| Shortcut | What It Does |
|---|---|
| Ctrl + Shift + } | Selects every cell whose formula refers to the active cell |
| Ctrl + Shift + | | Highlights the cells in a row that do not match the rest |
| Alt + ; | Selects visible cells only, so hidden rows stay behind |
| Ctrl + \ | Finds the odd value out across a selected row |
| Ctrl + Shift + O | Jumps to every cell containing a comment |
| Alt + Down Arrow | Opens a dropdown or data validation list from the keyboard |
| Ctrl + Shift + U | Expands the formula bar for long nested formulas |
| Ctrl + Alt + V then T | Pastes formatting only, leaving the values alone |
| Shift + F10 | Opens the right click menu without a mouse |
| Ctrl + Shift + Enter | Confirms a legacy array formula in older Excel versions |
These are the ones that make a room go quiet in a live class. Ctrl + backslash and Ctrl + Shift + pipe in particular do in one keystroke what most people build a helper column and an IF statement to check, which makes them worth knowing before the next time you are reconciling two lists that should match.
The specific problem of inheriting a file you did not build.
Jumps to the last used cell. If a small table sends you to row 40,000, there is stray formatting or leftover data bloating the file, and deleting those empty rows and saving usually shrinks it dramatically.
Switches the whole sheet from results to formulas, which reveals hardcoded numbers sitting where a calculation should be. This is the fastest way to find the one cell somebody typed over.
Go To Special selects only the blank cells, only the formulas, or only the typed constants in a range. Selecting all blanks and filling them in one action replaces a lot of manual scrolling and clicking.
Shows every cell that refers to the one you are about to remove. Checking this first is the difference between tidying a spreadsheet and quietly breaking a total three tabs away.
A hundred shortcuts read in one sitting produces zero retained shortcuts. Three at a time, used exclusively for a week, is slower on paper and vastly faster in practice.
Checking a bookmark means leaving the spreadsheet, which is the exact interruption the shortcut was meant to prevent. Paper on the wall gets glanced at, a browser tab gets forgotten.
Most shortcuts act on whatever is currently selected, so a fast keystroke applied to the wrong range is just a faster mistake. Get Ctrl + Shift + Arrow automatic before anything else.
A normal copy over a filtered range grabs the hidden rows too, so the paste contains records nobody expected. Selecting visible cells only first prevents it.
Enter replaces the highlighted piece of the formula with its hardcoded result, permanently. Escape backs out and leaves the formula intact, which is what you wanted.
Sequences like Alt W F R are pressed in order after a single Alt tap, not held down together. Holding all four at once does nothing and makes the shortcut look broken.
Faster keystrokes still leave you asking which copy of the file is current.
Free 14-day trial. No credit card required.
Yes. There is no login, no email and no credit card. Click the download button and the PDF opens, and you are welcome to print copies for a whole team or class.
Over 200, laid out by modifier key. Alt combinations, Ctrl combinations, Ctrl Shift combinations, the Alt sequences that walk the ribbon, and all twelve function keys along the bottom.
Microsoft 365, Excel 2021, 2019 and 2016 share the same core shortcuts. A few newer items such as Flash Fill with Ctrl E need Microsoft 365 or a recent perpetual version.
Yes. It is built for a single sheet of letter paper in landscape orientation. Print at 100 percent scale rather than Fit to Page for the sharpest result.
Ctrl Shift and an arrow key. It selects from the current cell to the edge of the data in that direction, replacing a long scroll and drag with one keystroke.
Many common ones do, including Ctrl C, Ctrl Z and Ctrl Shift with an arrow key. The Alt key ribbon sequences and most function key shortcuts do not carry over. There is a separate free Google Sheets help page for those.
Start with three that match what you repeat most in a normal day, use only the keyboard for those until they are automatic, then add three more. Trying to learn all of them at once is why most people learn none.
Inside a formula it cycles a cell reference between relative and absolute, turning A1 into $A$1. Outside a formula it repeats your last action, such as applying a fill color to another cell.
It switches the sheet from showing formula results to showing the formulas themselves, which is the fastest way to audit a spreadsheet somebody else built. Press it again to switch back.
Tapping Alt on Windows puts a letter badge on every ribbon tab, and tapping that letter labels everything inside the tab. It lets you reach any command from the keyboard without memorizing the sequence first.
Yes. Share the page link or the file itself, print it for a training session, or hand it out in a classroom. The only ask is that the XecuteTheVision branding stays on it.
Most people stop reaching for it within about a month if it is taped next to the monitor where it can be checked without leaving the spreadsheet.
Every business starts with a spreadsheet. Updoot is where you scale past it, with one live system instead of a folder of files nobody can version.
Start Your Free Trial →