Last answered:

07 Oct 2021

Posted on:

23 Sept 2021

0

Fix row and column reference

Can you tell me more about what is fix row and column reference?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

07 Oct 2021

1

Hi Erumpent!

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.
Best,
Martin

Submit an answer