Speed in Excel comes from the keyboard. Mastering movement and selection early saves hours later.
Hands on a keyboard working through rows of data on screen
| Key | Action |
|---|---|
| Arrow Keys | Move one cell |
| CtrlArrow | Jump to the edge of the data |
| CtrlHome | Go to A1 |
| CtrlEnd | Go to the last used cell |
| Page Down | Move one screen down |
| CtrlPage Down | Next worksheet |
| Action | How |
|---|---|
| A range | Click and drag, or ShiftArrow |
| Whole column | Click the column letter, or CtrlSpace |
| Whole row | Click the row number, or ShiftSpace |
| Everything | CtrlA |
| To edge of data | CtrlShiftArrow |
| Non-adjacent cells | Hold Ctrl and click each |
A range is a rectangle of cells, written TopLeft:BottomRight:
A1:A10 → ten cells down column A
B2:D5 → a 3-column × 4-row block
A:A → the entire column A
1:1 → the entire row 1
You'll use range notation constantly in formulas — =SUM(B2:B13) adds everything from B2 down to B13.
Select a range of numbers and glance at the status bar (bottom-right). Excel shows the Sum, Average, and Count instantly — no formula needed for a quick check.