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.