This is for many very common knowledge. However I saw this question recently and thought I would put a post out there with an answer. The question was on how to hold a value when dragging a column or row. Sometimes you have a fixed value in your spreadsheet which you wish to use for every row, but not hardcode it.
Below I have made a small example of a spreadsheet where this has gone wrong. Not all the rows are subtracted by a hundred, only the first one:
I wish to use the value for S1
for every row. Subtracting it from the T
in the U
column. However it is only applied to the first one when dragging the U1
cell down. The trick to keep using the field S1
is to use the $
sign.
As it can be seen above - using a $
in a formula will hold that value. That is it!
Let me know in the comments, if this helped you :)