Getting started·Lesson 8 of 62Free
Locking a cell with $
Absolute references with $ and F4
What you’ll do
Sometimes a formula should keep pointing at one cell, like a tax rate, however far you copy it. A $ in front of the column or row locks it.
Your turn
Step 1 of 5- 1
Every order pays the tax rate in M2. In K2, type =F2*M2 and press Enter.
- 2
Select K2 down to K11 and press Ctrl+D Mac ⌘+D to fill it down.
- 3
Most rows show 0. Click K3: it points at M3, which is empty. The rate’s address moved down too.
- 4
Lock it. Select K2, press Enter to edit, put the cursor on M2 and press F4 Mac Fn+F4 until it reads $M$2. Press Enter.
- 5
Fill down again: select K2:K11 and press Ctrl+D Mac ⌘+D.
Stuck?