Thinkabara

📗 Excel for Beginners · Lesson 5 of 10

Drag and fill

Google Classroom

AutoFill in Excel: drag a formula with the fill handle, and use an absolute reference with the $ sign.

The tasks in this lesson

1. One formula, six rows

  1. D2: =B2*C2
  2. Click D2 and drag the small square in its corner down to D7
  3. On a phone: select D2 to D7 and tap "Fill down ⬇"

💡 Ctrl+D fills down whatever is in the first row of the selection.

2. A times table with $

  1. B3: =A3*$B$1
  2. Drag B3 down to B12
  3. The $ keeps B1 fixed in every row

💡 Pressing F4 while you type a formula adds the $ for you.

3. The table of 9

  1. Change B1 to 9

💡 Without the $, dragging would move B1 to B2, B3... and the results would be wrong.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet