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
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
I'm trying to do this in OpenOffice, but I suspect the answer would be similar for Excel.