Mixed References for Tables
Combine $A1 and A$1 to lock only a row or only a column.
Locking Just One Part
Absolute references lock both the column and row. But sometimes you need to lock only one of them. That is a mixed reference.
Mixed references are the key to filling a whole table from a single formula, because they let a reference slide in one direction while staying fixed in the other.
The Two Mixed Styles
There are exactly two mixed forms:
$A1the column is locked, the row is freeA$1the row is locked, the column is free
Remember the rule: the dollar sign locks whatever comes immediately after it.
All lessons in this course
- What the Dollar Sign Does
- Locking a Single Cell With Absolute References
- Mixed References for Tables
- Building a Multiplication Table