0 of 46 lessons complete.
Module 3: References · Lesson 18 of 46
Mixed References
Lock only the row or only the column to build a table.
Step 1 of 20%
Build a conversion table. In B3, type =$A3*B$2. $A3 locks the column (always use feet from column A). B$2 locks the row (always use the factor from row 2).
Target: B3
B3
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Feet ↓ | Meters | Centimeters | Inches | ||
| 2 | Factor → | 0.3048 | 30.48 | 12 | ||
| 3 | 1 | |||||
| 4 | 5 | |||||
| 5 | 10 | |||||
| 6 | 25 | |||||
| 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 $