0 of 46 lessons complete.
Module 1: Spreadsheet Basics · Lesson 7 of 46
Fill Down
Copy a formula down a column with Fill Down.
Step 1 of 20%
Weight equals mass times gravity (9.81 m/s²). In B2, type =A2*9.81.
Target: B2
B2
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Mass (kg) | Weight (N) | ||||
| 2 | 10 | |||||
| 3 | 25 | |||||
| 4 | 40 | |||||
| 5 | 55 | |||||
| 6 | 70 | |||||
| 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 $