DashCoreHubThe Excel keyboard shortcuts that save analysts the most time are the ones for moving through large data (Ctrl+Arrow), selecting ranges (Ctrl+Shift+Arrow), filling formulas (Ctrl+D, Ctrl+Enter), locking references (F4) and working with Tables and filters (Ctrl+T, Ctrl+Shift+L). Below are 50 shortcuts grouped by task, with notes on which ones to learn first and how to practice them until they become automatic.
All shortcuts are for Excel for Windows with an English keyboard layout. On a Mac, many use Cmd instead of Ctrl, and some differ completely; Microsoft's official keyboard shortcuts page lists both.
Navigation and selection (1–10)
When a sheet has 50,000 rows, scrolling with the mouse is the slowest part of the job. These ten shortcuts let you move and select without leaving the keyboard.
| # | Shortcut (Windows) | What it does |
|---|---|---|
| 1 | Ctrl+Arrow key | Jump to the edge of the data region |
| 2 | Ctrl+Shift+Arrow key | Select to the edge of the data region |
| 3 | Ctrl+Home | Go to cell A1 (or the top-left unfrozen cell) |
| 4 | Ctrl+End | Go to the last used cell on the sheet |
| 5 | Ctrl+Page Down / Ctrl+Page Up | Move to the next / previous sheet |
| 6 | F5 or Ctrl+G | Open Go To (then Special for blanks, formulas, constants) |
| 7 | Ctrl+Backspace | Scroll back to show the active cell |
| 8 | Shift+Space | Select the entire row |
| 9 | Ctrl+Space | Select the entire column |
| 10 | Ctrl+A | Select the current region; press again for the whole sheet |
Ctrl+Shift+Arrow stops at the first blank cell, which is a quick way to discover gaps in your data. If a selection stops halfway down a column, there is probably an empty cell worth investigating.
Editing and data entry (11–20)
These shortcuts remove the repetitive copy-paste work from building helper columns and fixing values.
| # | Shortcut (Windows) | What it does |
|---|---|---|
| 11 | F2 | Edit the active cell |
| 12 | Ctrl+Enter | Enter the same value or formula in every selected cell |
| 13 | Alt+Enter | Start a new line inside a cell |
| 14 | Ctrl+D | Fill down from the cell above |
| 15 | Ctrl+R | Fill right from the cell to the left |
| 16 | Ctrl+; | Insert today's date as a fixed value |
| 17 | Ctrl+Shift+; | Insert the current time as a fixed value |
| 18 | Ctrl+Z / Ctrl+Y | Undo / redo |
| 19 | Ctrl+E | Flash Fill based on the pattern you typed |
| 20 | Ctrl+Alt+V | Open Paste Special (then V for values) |
Two combinations deserve special attention. First, select a range, type a formula and press Ctrl+Enter: the formula goes into every selected cell, adjusting relative references. Second, Ctrl+Alt+V, then V, then Enter pastes values only, which is the standard way to freeze the results of a helper formula.
Formatting (21–30)
Good formatting makes numbers readable. These shortcuts apply the formats analysts use most without opening menus.
| # | Shortcut (Windows) | What it does |
|---|---|---|
| 21 | Ctrl+1 | Open Format Cells |
| 22 | Ctrl+B / Ctrl+I / Ctrl+U | Bold / italic / underline |
| 23 | Ctrl+Shift+$ | Currency format |
| 24 | Ctrl+Shift+% | Percent format with no decimals |
| 25 | Ctrl+Shift+! | Number format with thousands separator and two decimals |
| 26 | Ctrl+Shift+# | Date format |
| 27 | Ctrl+Shift+~ | General format |
| 28 | Ctrl+Shift+& | Add an outline border |
| 29 | Alt, H, O, I | AutoFit column width |
| 30 | Ctrl+9 | Hide selected rows |
Shortcut 29 is a KeyTip sequence: press and release Alt, then H, then O, then I, one at a time. KeyTips work for almost every ribbon command. Press Alt on its own to see the letters on the ribbon, then follow them. This is how you reach commands that have no classic Ctrl shortcut.
Formulas and auditing (31–40)
These are the shortcuts that separate fast analysts from everyone else, because they speed up writing and checking formulas.
| # | Shortcut (Windows) | What it does |
|---|---|---|
| 31 | Alt+= | AutoSum the cells above or to the left |
| 32 | F4 | Cycle a reference between relative and absolute ($A$1, A$1, $A1) |
| 33 | Ctrl+` | Show or hide formulas instead of results |
| 34 | Shift+F3 | Open Insert Function |
| 35 | F9 | Recalculate; inside the formula bar, evaluate the selected part |
| 36 | Ctrl+[ | Jump to the cells a formula refers to (precedents) |
| 37 | Ctrl+Shift+U | Expand or collapse the formula bar |
| 38 | Tab | Accept the function suggested by AutoComplete |
| 39 | F3 | Paste a defined name into a formula |
| 40 | Ctrl+F3 | Open Name Manager |
F4 is the one to learn first. While typing a formula, click a reference such as A1 and press F4 repeatedly to cycle through $A$1, A$1, $A1 and A1. Getting absolute references right is essential for formulas you will copy across a table, for example:
=SUMIFS($D$2:$D$5000, $B$2:$B$5000, $G2, $C$2:$C$5000, H$1)Here the data ranges are fully locked, the region in column G is locked by column, and the month in row 1 is locked by row, so one formula can be filled across an entire summary grid. F9 is also powerful: select part of a formula in the formula bar and press F9 to see what that piece returns. Press Esc afterward, or the result replaces the formula text.
Tables, filters, charts and data (41–50)
| # | Shortcut (Windows) | What it does |
|---|---|---|
| 41 | Ctrl+T | Convert the range into an Excel Table |
| 42 | Ctrl+Shift+L | Turn filters on or off |
| 43 | Alt+Down Arrow | Open the filter drop-down in a header cell |
| 44 | Ctrl+F | Find |
| 45 | Ctrl+H | Find and Replace |
| 46 | Alt+F1 | Insert a chart of the selected data on the same sheet |
| 47 | F11 | Insert a chart on a new chart sheet |
| 48 | Ctrl+Alt+F5 | Refresh all queries, connections and PivotTables |
| 49 | Ctrl+Shift+= (Ctrl+plus) | Insert rows, columns or cells |
| 50 | Ctrl+- (Ctrl+minus) | Delete rows, columns or cells |
Ctrl+T is the most underrated shortcut in Excel. Tables give you structured references, automatic expansion and banded rows, and they are the best starting point for PivotTables, Power Query and Copilot. Ctrl+Alt+F5 matters as soon as you use queries: one keystroke refreshes everything in the workbook. For more on Tables in analysis, see our Excel for data analysis beginner's guide.
Which shortcuts to learn first (and how to practice)
Fifty shortcuts is too many to memorize at once. Learn them in this order:
- Week 1: Ctrl+Arrow, Ctrl+Shift+Arrow, Ctrl+Space, Shift+Space, Ctrl+T.
- Week 2: F2, F4, Ctrl+D, Ctrl+Enter, Ctrl+Alt+V.
- Week 3: Ctrl+Shift+L, Alt+Down Arrow, Ctrl+1, Alt+=, Ctrl+`.
- Week 4: Pick five from the remaining list that match your daily work.
Practice by banning the mouse for one specific task. For example, build your next PivotTable source table using only the keyboard. It will feel slow for a few days and then noticeably faster. A full-size keyboard with a number pad and dedicated function keys also makes F2, F4 and F9 easier to reach than on a compact laptop layout.
Next steps
Print or save the four-week plan above and start with the navigation shortcuts today. Once you move around data quickly, apply that speed to cleaning it with our Excel data cleaning checklist, then to summarizing it with formulas and PivotTables. Speed matters most when it frees time for the part no shortcut can do: thinking about what the numbers mean.
Watch: video lessons
Frequently asked questions
What is the most useful Excel shortcut for analysts?
Ctrl+Shift+Arrow for selecting data and F4 for locking references are the two most analysts use constantly. Ctrl+T is a close third because Tables make every later step easier.
Do Excel shortcuts work on a Mac?
Many do with Cmd in place of Ctrl, but some are different, and function keys may require the Fn key. Check Microsoft's official Excel for Mac shortcut list.
Why doesn't F4 work on my laptop?
Many laptops map the top row to media controls. Press Fn+F4, or turn on the Fn Lock setting so function keys work directly.
How can I find shortcuts for ribbon commands?
Press and release Alt to show KeyTips, the letters on each ribbon tab and button, then press them in order. Almost every command can be reached this way.
Mark this lesson complete to track your rank progress.