Select a range
Step 1 of 5
A range is a block of cells. It's written as its first and last cell with a colon between them: B2:B4 means B2, B3 and B4.
Click Continue when you're ready.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Month | Sales | ||||
| 2 | January | 120 | ||||
| 3 | February | 95 | ||||
| 4 | March | 140 | ||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
A range is named by two corners: the top-left cell and the bottom-right cell, joined by a colon. B2:B4 is part of one column, A1:B4 is a block two columns wide.
Common mistake: Writing a range with a dash or a comma, like B2-B4. Excel only reads it as a range with a colon, B2:B4.
It's a range, the cells from B2 down to B4. The colon means "through".
- Extend the selection by one cellShift+Right
- Select to the last filled cellCtrl+Shift+Down
+5 points