I have a number in cell A1 and a column of 20 numbers in the B column.
I'd like to put a formula in each of the cells in the C column next to each number in the B column. Let's say it's =B1-A1
, and then the next one would be =B2-A1
, then =B3-A1
, etc.
I could type all that in by hand, but it would take a long time. Is there a way I can copy the first formula, which is in cell C1, and paste it into the following cells in the C column?
I tried it, but I would get, say, =B5-A5
instead of =B5-A1
.
I'm trying to do this in OpenOffice, but I suspect the answer would be similar for Excel.