Lesson 5: Drag and fill
- D2:
=B2*C2 - Click D2 and drag the small square in its corner down to D7
- On a phone: select D2 to D7 and tap "Fill down ⬇"
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | Price | Amount | Total |
| 2 | Notebook | 6 | 5 | |
| 3 | Pen | 3 | 10 | |
| 4 | Backpack | 120 | 1 | |
| 5 | Ruler | 4 | 2 | |
| 6 | Eraser | 2 | 3 | |
| 7 | Crayons | 25 | 1 |
- D2 to D7 are calculated with a formula
All lessons
✍️ 1. Typing in cells
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
Cells, typing, fixing and deleting🎨 2. Format a table
Select a range, bold and dollar format🧮 3. Your first formula
Multiply, add and subtract between cells➕ 4. SUM and AVERAGE
The total and the average of a column⬇️ 5. Drag and fill
The fill handle, and $ to lock a cell🔢 6. MAX, MIN and COUNT
The most, the least, and how many filled in🔀 7. IF: if... then...
Pass or fail, and COUNTIF↕️ 8. Sort a table
High to low, and alphabetical📊 9. Your first chart
A bar chart and a pie chart🏠 10. Project: a family budget
Everything we learned in one sheet
AutoFill in Excel: drag a formula with the fill handle, and use an absolute reference with the $ sign. Ctrl+D fills down whatever is in the first row of the selection. Pressing F4 while you type a formula adds the $ for you. Without the $, dragging would move B1 to B2, B3... and the results would be wrong.
Explore more: Excel course: all lessons, and MAX, MIN and COUNT.