Getting started·Lesson 7 of 62Free
Copying a formula down
Fill a formula down
What you’ll do
You rarely type the same formula ten times. Write it once, then fill it down, and Sheets adjusts it for each row.
Your turn
Step 1 of 4- 1
K2 works out one order’s revenue: units times price. Click it and look at the formula bar.
- 2
Select K2 down to K11: hold Shift and click K11, or press Shift+↓ nine times.
- 3
Press Ctrl+D Mac ⌘+D to fill the formula down.
- 4
Click K5. Its formula reads =E5*F5: the row numbers moved with it. That’s called a relative reference.
Stuck?