Free Excel shortcut drills
If you have ever watched a senior analyst move through a spreadsheet, you already know the tell. They do not click. The cursor jumps, cells light up, formats appear, and the model takes shape faster than you can explain what just happened. All of that is keyboard shortcuts.
This page gives you a timed sprint to practice them. It captures real key presses in your browser, so pressing Ctrl+S here is the same muscle movement as pressing it in Excel. Set your keyboard (Windows or Mac), pick the categories you want to work on, and go.
Free practice. No signup.
Pick a track and start drilling
Real key capture in your browser. Pick a track, press the combo you think is right, and watch the spreadsheet react.
Tip: press Escape any time to drop back to this screen. The drill stops intercepting your keys as soon as you do.
Why Excel speed matters for consulting
A consulting model is rarely complicated math. It is usually an enormous amount of light formatting, cross-referencing, pivoting, and manual checks done under a tight deadline. Speed in Excel is what lets you finish the analysis and still have time to think about what it means.
Analysts who rely on the mouse do the same work as fast analysts, but about twice as slowly. That gap is invisible on any single task, and obvious by the end of a project. Partners do not evaluate you on shortcuts, but they do notice who gets things done in time and who is still moving cells around at 11pm.
None of this is about showing off. The point is that thinking and typing should not compete for your attention. Shortcuts free up the part of your brain that should be on the problem.
The shortcuts that actually come up
This is the set we put into the drill. Nothing obscure. These are the combos you will use dozens of times a day in any real modeling work.
Navigation
| Action | Windows | Mac |
|---|---|---|
| Jump to the last cell of data in this row. | Ctrl + → | ⌘ + → |
| Jump to cell A1 from anywhere. | Ctrl + Home | Ctrl + Fn + ← |
| Jump to the last used cell in the sheet. | Ctrl + End | Ctrl + Fn + → |
| Open the Go To dialog. | Ctrl + G | Ctrl + G |
| Scroll down one full screen. | PageDown | Fn + ↓ |
| Cycle to the next open workbook. | Ctrl + Tab | ⌘ + ` |
| Move to the next worksheet tab. | Ctrl + PageDown | ⌥ + → |
| Move to the previous worksheet tab. | Ctrl + PageUp | ⌥ + ← |
Selection
| Action | Windows | Mac |
|---|---|---|
| Select the entire current column. | Ctrl + Space | Ctrl + Space |
| Select the entire current row. | Shift + Space | Shift + Space |
| Extend the selection down to the last cell of data. | Ctrl + Shift + ↓ | ⌘ + Shift + ↓ |
| Select the current region (or the whole sheet). | Ctrl + A | ⌘ + A |
| Select the contiguous region of data around the active cell. | Ctrl + Shift + 8 | ⌘ + Shift + 8 |
Editing
| Action | Windows | Mac |
|---|---|---|
| Copy the selected cell. | Ctrl + C | ⌘ + C |
| Paste the copied cell into the active cell. | Ctrl + V | ⌘ + V |
| Cut the selected cell. | Ctrl + X | ⌘ + X |
| Undo your last action. | Ctrl + Z | ⌘ + Z |
| Redo the action you just undid. | Ctrl + Y | ⌘ + Shift + Z |
| Fill the formula from the cell above into the cells below. | Ctrl + D | ⌘ + D |
| Fill the value from the cell on the left across the selection. | Ctrl + R | ⌘ + R |
| Start a new line inside the current cell. | Alt + Enter | Ctrl + ⌥ + Enter |
| Fill every cell of the selection with the value just typed. | Ctrl + Enter | Ctrl + Enter |
| Edit the active cell in place. | F2 | Ctrl + U |
| Insert today's date as a static value. | Ctrl + ; | Ctrl + ; |
| Insert a new blank row above the current one. | Ctrl + Shift + + | ⌘ + Shift + + |
| Delete the selected row. | Ctrl + - | ⌘ + - |
| Repeat your last formatting or action. | F4 | ⌘ + Y |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Bold the selected cell. | Ctrl + B | ⌘ + B |
| Italicize the selected cell. | Ctrl + I | ⌘ + I |
| Underline the selected cell. | Ctrl + U | ⌘ + U |
| Open the Format Cells dialog. | Ctrl + 1 | ⌘ + 1 |
| Apply currency format with two decimals. | Ctrl + Shift + 4 | Ctrl + Shift + 4 |
| Apply percentage format to the selected number. | Ctrl + Shift + 5 | Ctrl + Shift + 5 |
| Format a number with two decimals and a thousands separator. | Ctrl + Shift + 1 | Ctrl + Shift + 1 |
| Apply the default date format. | Ctrl + Shift + 3 | Ctrl + Shift + 3 |
| Apply strikethrough to the selected cell. | Ctrl + 5 | ⌘ + Shift + X |
Formulas
| Action | Windows | Mac |
|---|---|---|
| Insert a SUM formula summing the values above. | Alt + = | ⌘ + Shift + T |
| Toggle between formulas and their calculated results. | Ctrl + ` | Ctrl + ` |
| Convert the selected range into a table. | Ctrl + T | Ctrl + T |
| Create a default chart from the selected range. | F11 | Fn + F11 |
| Toggle filters on the header row. | Ctrl + Shift + L | ⌘ + Shift + F |
| Open the Name Manager. | Ctrl + F3 | ⌘ + Fn + F3 |
| Force the workbook to recalculate. | F9 | Fn + F9 |
Workbook
| Action | Windows | Mac |
|---|---|---|
| Save the workbook to disk. | Ctrl + S | ⌘ + S |
| Open a brand new blank workbook. | Ctrl + N | ⌘ + N |
| Close the active workbook. | Ctrl + W | ⌘ + W |
| Open the print preview dialog. | Ctrl + P | ⌘ + P |
| Find text somewhere in the sheet. | Ctrl + F | ⌘ + F |
| Open Find and Replace. | Ctrl + H | Ctrl + H |
| Insert a new worksheet into this workbook. | Shift + F11 | Shift + Fn + F11 |
How to drill them so they stick
Make the mouse annoying to reach
Push it out of arm's reach while you are drilling. You will hate it for an hour. After that, you will stop reaching for it without thinking. That is the whole game.
Short sprints, daily
Ten minutes a day beats a 90-minute weekend binge. The drill is designed for this. One sprint, check your score, go back to work.
Use them the same day in a real sheet
Drilling a combo and never using it in real work is like flashcards for words you never say. Open any spreadsheet and force yourself to use what you just practiced. If you catch yourself reaching for the mouse, undo and try again.
Drill your weakest category
Most people are fine at copy/paste and lost on formatting and formula combos. Turn off what you already know and stay in the uncomfortable categories. That is where the time savings are.
Learn the platform you actually use
Windows and Mac Excel have meaningfully different shortcuts. The drill lets you switch, but pick the one that matches your work laptop and stay there. Context-switching between them slows you down more than either alone.
Frequently asked questions
Do consulting firms actually care about Excel speed?
They care about whether you can produce a clean model on deadline. That is mostly a function of Excel speed. Partners will not grade you on your Ctrl+Arrow game directly, but staffers notice analysts who spend twice as long building the same sheet.
What are the most important Excel shortcuts to learn first?
Ctrl+Arrow (jump to data edge), Ctrl+Shift+Arrow (select to edge), F2 (edit cell), F4 (repeat or toggle reference), Alt+= (autosum), Ctrl+1 (format cells), Ctrl+D (fill down), and Ctrl+Z (undo). If you only learn eight, learn these.
How long does it take to get fast?
About two weeks of daily 15-minute practice, assuming you also use the shortcuts in real work. Drilling alone plateaus fast. Drilling plus live application is what builds muscle memory that survives interview pressure.
Does this work on Mac?
Yes. Switch the keyboard toggle to Mac and the prompts will match Command, Option, and Control combos. The drill captures real key presses in your browser, so whatever your keyboard sends is what gets matched.
Will this page trigger browser shortcuts like Ctrl+S or Ctrl+P?
No. While the drill is listening, it intercepts keystrokes with modifier keys and stops the browser from handling them. Press Escape or click Pause to hand control back to the browser.
From fast Excel to full case prep
Excel speed is table stakes for consulting work. The harder part is the interview itself: structuring a problem, running the math out loud, and driving the case forward under time pressure.
CaseXcel is built for that. Daily mental math drills, consulting frameworks, timed case practice, all on your phone. 15 minutes a day for two weeks is enough to walk into a McKinsey, BCG, or Bain first round and feel ready.