Getting started·Lesson 3 of 62Free
Rows, columns and ranges
Rows, columns and ranges
What you’ll do
Columns are letters and rows are numbers. A range is a block of cells, written first cell, colon, last cell. E2:E6 means E2 down to E6.
Your turn
Step 1 of 3- 1
Drag from E2 down to E6. The box above the sheet now says E2:E6.
- 2
Now with the keyboard: click F2, hold Shift and press ↓ four times.
- 3
Shift+click works too. Click B2, then hold Shift and click D4.
Stuck?