Professional Excel users are fast because they use keyboard shortcuts. Every time you reach for the mouse, you lose a second or two. Multiply that by hundreds of actions per day, and shortcuts save you 30 minutes or more. Here are the 50 shortcuts that cover 95% of daily Excel work.
Navigation shortcuts
Ctrl+Home goes to cell A1. Ctrl+End goes to the last used cell. Ctrl+Arrow jumps to the edge of the current data region. Ctrl+G (or F5) opens Go To for navigating to specific cells or ranges. Ctrl+Page Up and Ctrl+Page Down switch between sheet tabs. These five shortcuts alone make navigating large workbooks dramatically faster.
Selection shortcuts
Shift+Arrow selects cells in a direction. Ctrl+Shift+Arrow selects to the edge of the data region. Ctrl+A selects the current region (press twice for entire sheet). Ctrl+Space selects the entire column. Shift+Space selects the entire row. Ctrl+Shift+L toggles AutoFilter on the current range.
Data entry and editing
F2 edits the active cell (puts cursor in the cell). Escape cancels editing. Tab moves to the next cell right (and confirms). Enter moves down (and confirms). Ctrl+Enter confirms and stays in the same cell. Alt+Enter adds a line break inside a cell. Ctrl+D fills down from the cell above. Ctrl+R fills right from the cell to the left.
Formatting shortcuts
Ctrl+B toggles bold. Ctrl+I toggles italic. Ctrl+U toggles underline. Ctrl+1 opens Format Cells dialog. Ctrl+Shift+$ applies currency format. Ctrl+Shift+% applies percentage format. Ctrl+Shift+# applies date format. Alt+H+O+I auto-fits column width. These formatting shortcuts mean you never need to hunt through the Ribbon for basic formatting.
Formula shortcuts
Alt+= inserts AutoSum for the selected range. F4 toggles absolute/relative references ($A$1, A$1, $A1, A1) while editing a formula. Ctrl+` (backtick) toggles formula view. Ctrl+Shift+Enter confirms an array formula (legacy). F9 evaluates the selected part of a formula in the formula bar (press Escape to undo). Tab accepts an autocomplete suggestion while typing a function.
Workbook management
Ctrl+N creates a new workbook. Ctrl+O opens a file. Ctrl+S saves. Ctrl+W closes the current workbook. Ctrl+Z undoes (up to 100 levels). Ctrl+Y redoes. Ctrl+P opens print preview. F12 opens Save As.
Data manipulation
Ctrl+T creates a table. Alt+A+T applies AutoFilter. Ctrl+Shift+L also toggles AutoFilter. Ctrl+H opens Find and Replace. Ctrl+K inserts a hyperlink. Ctrl+; inserts today's date. Ctrl+Shift+; inserts the current time.
PivotTable shortcuts
Alt+N+V inserts a PivotTable. Alt+JT opens PivotTable Analyze tab. Right-click, then E refreshes the PivotTable. Double-click a value cell to drill through to the underlying data. + and - expand and collapse grouped items.
Power user shortcuts
Ctrl+Shift+F opens the full font dialog. Alt+W+F+F freezes panes. Ctrl+Shift+U expands or collapses the formula bar. Alt+F11 opens the VBA editor. Ctrl+Shift+P opens the command palette in newer Excel versions.
How to memorize shortcuts
Do not try to learn all 50 at once. Pick five shortcuts that match your most common tasks. Use them for one week until they are automatic. Then add five more. In ten weeks, you will have internalized all 50 and your Excel speed will be noticeably faster. For structured training on both shortcuts and advanced Excel skills, check out our [Excel training](/courses/microsoft-excel/).