Fix row and column reference
Can you tell me more about what is fix row and column reference?
1 answers ( 0 marked as helpful)
Thanks for reaching out.
Fixing a row or column reference happens with the help of the $ key. This is used if you want to apply the reference you've used in a certain cell to other cells.
If you fix a column reference, then the column reference won't change once you paste the reference to a different cell. Analogously, the row reference won't change if you fix that one.
Please note that you can fix both the row and column reference at the same time.
Hope this helps.
Submit an answer
Why doesn't the Index+Match example in this lesson need a column number for the Index function?
Resolved: Exercise Solution - Column array seems wrong but still returns correct number?