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. Substracting 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
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 :)