— Microsoft Excel: 30 shortcuts for faster data entry and analysis
Excel rewards keyboard use because the right shortcuts can navigate large ranges, fill formulas and format data with fewer interruptions.
| Shortcut | Action |
|---|---|
Ctrl + Arrow |
Move to the edge of a data region |
Ctrl + Shift + Arrow |
Select to the edge of a region |
Ctrl + Home / End |
Go to A1 / last used cell |
Ctrl + Page Up/Down |
Switch worksheets |
Ctrl + Space / Shift + Space |
Select column / row |
F2 |
Edit the active cell |
Alt + Enter |
Insert a line break in a cell |
Ctrl + D / R |
Fill down / right |
Ctrl + ; |
Insert today’s date |
Alt + = |
AutoSum |
F4 in a formula |
Cycle relative/absolute references |
Ctrl + T |
Convert a range to a table |
Ctrl + Shift + L |
Toggle filters |
Ctrl + 1 |
Open Format Cells |
Shift + F11 |
Add a worksheet |
Practise with a small table: convert it using Ctrl + T, toggle filters, total a column with Alt + =, and format the result with Ctrl + 1.
Source: Microsoft Support, “Keyboard shortcuts in Excel.”



