Keyboard shortcuts reduce context switching between keyboard and mouse. Below is a practical reference organized by task. Shortcuts follow common Windows / Excel desktop conventions (Microsoft 365 and recent Excel versions).
Navigation
| Shortcut |
Action |
| Ctrl + Arrow key |
Jump to the edge of the current data region |
| Ctrl + Page Up / Page Down |
Move to the previous / next worksheet |
| Ctrl + A |
Select all (press again to select the whole sheet) |
| Ctrl + Space |
Select the entire column of the active cell |
| Ctrl + G or F5 |
Open Go To |
| Ctrl + End |
Move to the last used cell on the sheet |
| Ctrl + Home |
Go to cell A1 |
| F4 |
Repeat the last command (when supported) |
| F6 |
Cycle focus between worksheet, ribbon, task pane, and status bar |
| F7 |
Spell check |
Data entry and editing
| Shortcut |
Action |
| Ctrl + D |
Fill down from the top cell of the selection |
| Ctrl + R |
Fill right from the left cell of the selection |
| Ctrl + ; |
Insert today’s date |
| Ctrl + Shift + : |
Insert the current time |
| Ctrl + Shift + + |
Insert cells, rows, or columns (context-dependent) |
| Ctrl + - |
Delete cells, rows, or columns |
| Ctrl + F3 |
Open Name Manager |
| Ctrl + E |
Flash Fill (when Excel detects a pattern) |
| F2 |
Edit the active cell |
| F3 |
Paste a name into a formula (when a dialog is open) |
| Shortcut |
Action |
| Ctrl + 1 |
Open Format Cells |
| Ctrl + Shift + $ |
Apply currency format |
| Ctrl + Shift + # |
Apply date format |
| Ctrl + Shift + @ |
Apply time format |
| Ctrl + 9 |
Hide selected rows |
| Ctrl + 0 (zero) |
Hide selected columns |
Data analysis
| Shortcut |
Action |
| Alt + = |
AutoSum for the adjacent range |
| Ctrl + T or Ctrl + L |
Create an Excel Table from the selection |
| Ctrl + Shift + L |
Toggle filter drop-downs on a range |
| Ctrl + ` |
Show formulas instead of values (toggle) |
Protection and sharing
| Shortcut |
Action |
| Alt + R, P, S |
Share / collaboration options (ribbon path) |
| Alt + R, P, R |
Workbook protection options (ribbon path) |
Next steps
Pair shortcuts with a formatted report pack instead of rebuilding structure from scratch. See the product overview for scheduled Excel delivery from live data.