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.

Zero2Hero — Zéro2Héros