A reference where either the row or the column is locked, but not both.
Definition
Use $A1 to lock the column or A$1 to lock the row. Useful when copying a formula across both rows and columns, such as in multiplication tables.
Excel glossary definition
A reference where either the row or the column is locked, but not both.
Use $A1 to lock the column or A$1 to lock the row. Useful when copying a formula across both rows and columns, such as in multiplication tables.