0 of 46 lessons complete.
Module 1: Spreadsheet Basics · Lesson 2 of 46
Selecting Cells
Select single cells and ranges of cells.
Step 1 of 20%
A group of cells is called a range. B2:B6 means every cell from B2 down to B6. Click B2, then drag down to B6 (or click B2, hold Shift, and click B6).
Select: B2:B6
A1
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Time | Temp (°F) | ||||
| 2 | 8:00 | 68 | ||||
| 3 | 9:00 | 71 | ||||
| 4 | 10:00 | 74 | ||||
| 5 | 11:00 | 77 | ||||
| 6 | 12:00 | 79 | ||||
| 7 | ||||||
| 8 |
Arrow keys move · drag or shift-click to select a range · Ctrl/Cmd+D fill down · Ctrl/Cmd+R fill right · Alt+= AutoSum · F4 toggles $