Excel: absolute references with $
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: absolute references with $
When a formula is copied, its cell addresses shift. A $ locks part of an address: $F$1 always points to F1, so a tax rate or a total can be shared by every row.
Key words
- $F$1
- Locked column and row.
- F4 key
- Adds the $ signs for you in Excel.
🔎 What to look for: Lock the setting cells; leave the row-by-row cells unlocked.
