Subtract one cell from every other cell in column?

[babag]

I have a column of numbers, c. I want to create another column, b, that progressively displays the difference between the selected cell and the first cell in the original column. That’s probably a poor description but this is what I want to do in column b:

=c3-c2
=c4-c2
=c5-c2
=c6-c2
etc

The original column, that would be c, is long so I’d like to be able to simply drag down in the new column and have it continue the pattern described above. I thought some version of OpenOffice or LibreOffice did this years ago but I can’t seem to get such an operation to properly continue the pattern with the current version. Tried holding shift or control, or alt but none did it.

Any help getting this sorted is much appreciated and sorry for the inarticulate descriptions.

babag

[robleyd]

Addresses and References, Absolute and Relative

[fpy]

@babag

drag down

= c3 - $c$2

[babag]

thanks for the reply. i’ll look at this.

[babag]

thanks for this, fpy. this solved my issue. substituting “$c$2” where i had “c2” allowed me to drag down, keeping the c2 as a constant.

thanks again,
babag