A complete, categorized reference for students, accountants, investors and business owners — with plain-English definitions, real workplace stories, visual diagrams, and a quiz to test what you've learned.
Microsoft Excel is the world's most widely used spreadsheet tool, and every action inside it — formatting a cell, inserting a row, building a formula — can be done in two ways: by reaching for the mouse and clicking through menus, or by pressing a combination of keys on the keyboard. That second method is what we call a keyboard shortcut.
An Excel keyboard shortcut is a predefined combination of keys — usually involving Ctrl, Alt, Shift, or a function key like F2 — that instantly triggers a command Excel would otherwise require several mouse clicks to reach. Shortcuts exist for almost everything: navigating a worksheet, formatting numbers, writing formulas, managing rows and columns, building charts, and auditing data.
On Windows, most shortcuts are built around the Ctrl key. On a Mac, the same shortcuts generally use Cmd (⌘) in place of Ctrl, and Option in place of Alt. Throughout this guide, shortcuts are shown in their Windows form; Mac users can substitute Cmd for Ctrl in almost every case, with a small number of exceptions noted along the way. This distinction matters for a global audience — a finance team split between London, Lagos, Mumbai and Toronto is very likely also split between Windows laptops and MacBooks, and the underlying logic of each shortcut stays identical even when the key label changes.
Why does this matter specifically for finance? Because finance work is repetitive by nature. An accountant closing the books, an equity analyst updating a valuation model, or a small business owner reconciling a cash flow sheet will touch the same handful of actions — formatting currency, jumping to the end of a data set, copying formulas down a column, auditing a cell reference — dozens or hundreds of times in a single day. Multiply a two-second saving by hundreds of repetitions and thousands of working days, and the shortcut stops being a convenience. It becomes a measurable productivity asset.
Three things make Excel speed disproportionately valuable in finance, investing and accounting work:
"The analysts who finish the model review early aren't smarter — they're just not fighting the mouse for two extra hours a day."
Fig. 1 — Even a single shortcut, applied at finance-department scale, produces a meaningful time saving.
Most Excel shortcuts follow a predictable grammar once you learn to read them. Here's how Ctrl+Shift+$ — the currency formatting shortcut — breaks down.
Fig. 2 — Once you recognize this pattern, dozens of other shortcuts become easy to predict and remember.
Most finance professionals learn shortcuts in roughly this order, moving from basic movement to full model-building fluency.
Fig. 3 — This guide is organized to follow the same progression, category by category.
All shortcuts below are shown in their Windows form. On a Mac, replace Ctrl with Cmd (⌘) and Alt with Option, unless a note says otherwise. These apply to modern desktop versions of Excel (365, 2016–2024); a few may differ slightly in older versions or Excel for the web.
The foundation. Before formatting or formula shortcuts are useful, you need to be able to move around a large workbook without ever touching the scroll bar.
| # | Shortcut | What it does |
|---|---|---|
| 1 | Ctrl+arrow key | Jumps to the edge of the current block of data in that direction — the single most-used navigation shortcut in financial modeling. |
| 2 | Ctrl+Home | Jumps straight to cell A1 from anywhere in the sheet. |
| 3 | Ctrl+End | Jumps to the last used cell in the worksheet — useful for finding stray data far outside the visible range. |
| 4 | Ctrl+Shift+End | Selects everything from the active cell to the last used cell. |
| 5 | Ctrl+Shift+Home | Selects everything from the active cell back to A1. |
| 6 | Page Up / Page Down | Scrolls one full screen up or down. |
| 7 | Alt+Page Up/Down | Scrolls one full screen left or right. |
| 8 | Ctrl+Page Up/Down | Moves to the previous or next worksheet tab. |
| 9 | F5 | Opens "Go To," letting you jump directly to any cell reference or named range. |
| 10 | Ctrl+F | Opens Find, to search for any value or text across the sheet. |
Finance work lives and dies by clean formatting — currency, percentages and dates that are instantly readable by whoever reviews the file next.
| # | Shortcut | What it does |
|---|---|---|
| 11 | Ctrl+1 | Opens the Format Cells dialog — the master control for number formats, borders, fonts and alignment. |
| 12 | Ctrl+B | Toggles bold text. |
| 13 | Ctrl+I | Toggles italics. |
| 14 | Ctrl+U | Toggles underline. |
| 15 | Ctrl+Shift+$ | Applies currency format with two decimal places. |
| 16 | Ctrl+Shift+% | Applies percentage format with no decimal places. |
| 17 | Ctrl+Shift+# | Applies a standard date format (day-month-year). |
| 18 | Ctrl+Shift+! | Applies "comma" number format with two decimals and a thousands separator. |
| 19 | Ctrl+Shift+~ | Resets a cell to General number format. |
| 20 | Ctrl+E | Flash Fill — automatically fills a column based on the pattern you started typing (e.g., splitting names or extracting codes). |
Where the real financial logic lives — from simple sums to fully audited, error-checked models.
| # | Shortcut | What it does |
|---|---|---|
| 21 | F2 | Edits the active cell directly, placing the cursor inside the formula. |
| 22 | F4 | Cycles a cell reference through relative, absolute, and mixed forms (A1 → $A$1 → A$1 → $A1) while editing a formula. |
| 23 | Alt+= | AutoSum — instantly inserts a SUM formula for the adjacent range. |
| 24 | Ctrl+` | Toggles between showing calculated values and showing the underlying formulas in every cell. |
| 25 | Ctrl+Shift+Enter | Confirms a formula as a legacy array formula (still useful for certain older array-based calculations). |
| 26 | Shift+F3 | Opens the Insert Function dialog to search for and build a function. |
| 27 | Ctrl+[ | Selects all cells directly referenced by the formula in the active cell (precedents) — a core auditing shortcut. |
| 28 | F9 | Recalculates all open workbooks; when part of a formula is highlighted in the edit bar, shows that part's evaluated result. |
| 29 | Shift+F9 | Recalculates only the active worksheet. |
| 30 | Ctrl+Alt+F9 | Forces a full recalculation of every open workbook, including cells Excel thinks are unchanged — useful when numbers look "stuck." |
Copying, filling and cleaning data — the everyday mechanics of keeping a workbook accurate.
| # | Shortcut | What it does |
|---|---|---|
| 31 | Ctrl+C / X / V | Copy, cut, and paste. |
| 32 | Ctrl+Alt+V | Opens Paste Special — paste only values, formats, or formulas without disturbing the rest. |
| 33 | Ctrl+D | Fills the selected cell(s) downward with the content from the cell above. |
| 34 | Ctrl+R | Fills the selected cell(s) to the right with the content from the cell on the left. |
| 35 | Ctrl+Z / Y | Undo / redo the last action. |
| 36 | Ctrl+- | Deletes the selected cell, row, or column (with a prompt to shift remaining cells). |
| 37 | Ctrl+Shift++ | Inserts a new cell, row, or column. |
| 38 | Delete | Clears the contents of the selected cells without removing formatting. |
| 39 | Ctrl+Shift+L | Toggles AutoFilter arrows on and off for the selected data range. |
| 40 | Alt+↓ | Opens a filter dropdown, or shows an autocomplete list of previously entered values in a column. |
Handling the workbook itself — opening, saving, and moving between files, which matters most when several models are open at once.
| # | Shortcut | What it does |
|---|---|---|
| 41 | Ctrl+N | Opens a new, blank workbook. |
| 42 | Ctrl+O | Opens the Open dialog to load an existing file. |
| 43 | Ctrl+S | Saves the current workbook. |
| 44 | F12 | Opens Save As, to save a copy under a new name or location. |
| 45 | Ctrl+P | Opens the Print dialog and preview. |
| 46 | Ctrl+W | Closes the current workbook without closing Excel itself. |
| 47 | Ctrl+Tab | Switches between multiple open Excel workbooks. |
| 48 | Ctrl+F4 | Closes the current workbook window. |
| 49 | Alt+F4 | Closes Excel entirely. |
| 50 | Ctrl+F1 | Collapses or expands the ribbon, giving more vertical space to see the sheet. |
Structural shortcuts for reshaping a sheet — hiding sensitive columns, resizing for print, or adding a clean audit border.
| # | Shortcut | What it does |
|---|---|---|
| 51 | Ctrl+Space | Selects the entire column of the active cell. |
| 52 | Shift+Space | Selects the entire row of the active cell. |
| 53 | Ctrl+9 | Hides the selected row(s) — often used to hide helper calculations before sharing a file. |
| 54 | Ctrl+Shift+9 | Unhides rows within the selection. |
| 55 | Ctrl+0 | Hides the selected column(s). |
| 56 | Ctrl+Shift+0 | Unhides columns within the selection. |
| 57 | Alt,H,O,I | Auto-fits column width to the widest entry (a sequential ribbon shortcut, pressed one key after another). |
| 58 | Ctrl+Shift+& | Adds an outline border around the selected cells. |
| 59 | Ctrl+Shift+_ | Removes all borders from the selected cells. |
| 60 | Alt+Enter | Starts a new line inside the same cell — useful for multi-line notes or assumptions. |
Turning raw numbers into something a manager, client or investor can actually understand at a glance.
| # | Shortcut | What it does |
|---|---|---|
| 61 | Alt+F1 | Inserts a default chart of the selected data on the current sheet. |
| 62 | F11 | Inserts a default chart of the selected data on a brand-new sheet. |
| 63 | Alt+N,V | Opens the Create PivotTable dialog for the selected data. |
| 64 | Ctrl+Alt+F5 | Refreshes all data connections and PivotTables in the workbook. |
| 65 | Alt+Shift+→ | Groups selected PivotTable fields (e.g., grouping dates into months or quarters). |
| 66 | Alt+Shift+← | Ungroups selected PivotTable fields. |
| 67 | Ctrl+F3 | Opens the Name Manager, to view, edit or create named ranges used across formulas. |
| 68 | Ctrl+Shift+F3 | Creates named ranges automatically from selected row/column labels. |
| 69 | Alt+A,W | Opens the What-If Analysis menu (Goal Seek, Data Tables, Scenario Manager) — a staple of financial forecasting. |
| 70 | Alt+R,P | Refreshes the data source for the active PivotTable only. |
Every finance model eventually gets reviewed by someone else. These shortcuts make that review — and your own error-checking — much faster.
| # | Shortcut | What it does |
|---|---|---|
| 71 | Ctrl+[ | Selects all precedent cells (cells feeding into the active formula). |
| 72 | Ctrl+] | Selects all dependent cells (cells that use the active cell in their own formula). |
| 73 | Shift+F2 | Inserts or edits a cell comment/note. |
| 74 | Ctrl+Shift+A | Toggles comment threads pane in newer Excel versions. |
| 75 | Alt+M,P | Opens Trace Precedents from the Formulas ribbon (draws arrows to source cells). |
| 76 | Alt+M,D | Opens Trace Dependents (draws arrows to cells that depend on this one). |
| 77 | Alt+M,A,A | Removes all trace arrows from the sheet. |
| 78 | Ctrl+~ | Displays formulas instead of results across the whole sheet, for a full audit pass. |
| 79 | Alt+R,C | Toggles Track Changes for shared or reviewed workbooks (in versions that support it). |
| 80 | Ctrl+Shift+O | Selects every cell in the sheet that contains a comment. |
The combinations investment banking analysts, FP&A teams and equity researchers rely on daily when building three-statement or valuation models.
| # | Shortcut | What it does |
|---|---|---|
| 81 | F4 (while typing formula) | Locks a reference absolute — critical when copying a formula that must always point to one assumption cell, like an interest rate. |
| 82 | Ctrl+Shift+Enter | Confirms legacy array formulas used in some older sensitivity tables. |
| 83 | Alt+A,W,G | Opens Goal Seek — reverse-engineers an input needed to hit a target output (e.g., "what growth rate gets me to $1M revenue?"). |
| 84 | Alt+A,W,T | Opens Data Table, for building one- or two-variable sensitivity tables common in valuation work. |
| 85 | Ctrl+Shift+U | Expands or collapses the formula bar for very long formulas. |
| 86 | Ctrl+Q | Opens Quick Analysis, offering instant totals, charts and formatting for a selected range. |
| 87 | Ctrl+T | Converts a selected range into a structured Excel Table, which auto-expands formulas and ranges as new rows are added. |
| 88 | Alt+= (across a selection) | Adds SUM formulas across every empty cell at the bottom of several columns at once — a fast way to total an entire model in one keystroke. |
| 89 | Ctrl+' | Copies the formula from the cell directly above into the active cell, adjusting references automatically. |
| 90 | Ctrl+Shift+" | Copies the value (not formula) from the cell directly above into the active cell. |
The odds and ends that don't fit neatly elsewhere but earn a permanent place in a power user's muscle memory.
| # | Shortcut | What it does |
|---|---|---|
| 91 | Ctrl+K | Inserts a hyperlink — useful for linking to source documents or other workbook tabs. |
| 92 | Ctrl+; | Inserts today's date as a static value. |
| 93 | Ctrl+Shift+: | Inserts the current time as a static value. |
| 94 | Ctrl+A | Selects the entire current data region, or the whole sheet if pressed again. |
| 95 | Ctrl+H | Opens Find & Replace, for correcting recurring labels or values across a workbook. |
| 96 | F7 | Runs the spelling checker on the active sheet. |
| 97 | Alt+H,D,S | Deletes the selected worksheet. |
| 98 | Shift+F11 | Inserts a brand-new worksheet tab. |
| 99 | Ctrl+Shift+F | Opens the Format Cells dialog directly on the Font tab. |
| 100 | Ctrl+Shift+P | Opens the Format Cells dialog directly on the Alignment/Font sizing options — the finishing touch before sending a model out. |
Names and companies below are illustrative composites drawn from common, everyday scenarios in finance roles — not real individuals — but the situations themselves are exactly the kind that repeat across offices worldwide.
A junior analyst building a leveraged buyout model used to rebuild every sensitivity table by hand, retyping formulas across a 20-column grid. After learning Data Table (Alt,A,W,T) and locking assumptions with F4, the same sensitivity analysis dropped from 40 minutes to under 5 — enough to consistently leave the office before the last train home.
An accountant closing the books for a mid-sized manufacturer used to click through the Format Cells menu for every currency and percentage column in a 40-tab trial balance workbook. Switching to Ctrl+Shift+$ and Ctrl+Shift+% across the whole close cut roughly two hours off every month-end cycle — time reinvested into actually reviewing figures for errors.
An individual investor tracking a personal portfolio of 30 stocks across several brokerage exports used to manually retype dividend and price data every week. Learning Ctrl+E (Flash Fill) to auto-extract ticker symbols from messy pasted text, plus Ctrl+T to convert the range into a self-expanding Table, turned a 90-minute weekly chore into a 10-minute one.
A café owner preparing a cash flow statement for a small business loan struggled to keep the sheet presentable for the loan officer. Using Ctrl+9 to hide messy helper rows and Ctrl+Shift+& to add clean borders around the summary table gave the final document a professional look in minutes rather than an afternoon spent fighting with cell borders manually.
Ten questions to check what you've picked up. Click "Show Answer" under each question to reveal the correct choice, or jump straight to the full answer key at the end.
1. Which shortcut jumps a selected cell straight to A1?
2. What does F4 do while you are typing a formula?
3. Which shortcut applies currency formatting instantly?
4. What does Ctrl + ` (grave accent) do?
5. On a Mac, what typically replaces Ctrl in most Excel shortcuts?
6. Which shortcut selects all cells that feed into the active cell's formula (precedents)?
7. What does Ctrl + T do to a selected range?
8. Which tool is opened with Alt + A, W, G, and reverse-engineers an input to hit a target output?
9. What is Flash Fill (Ctrl + E) most useful for?
10. Which shortcut hides selected rows — often used to tidy a workbook before sharing it externally?
This guide is part of Learn Edition's ongoing finance skills series. Bookmark this page and revisit each category as you build it into muscle memory.
Back to the full shortcut list