How to create a formula for every row in a column in Google SpreadSheet?

Question

I use three columns. A, B and C. In column C I have a formula every row =A1*(1.6*B1) and then for the next row I have =A2*(1.6*B2) in C2.

How can I do so I don't have to type in the new formula in column C for every row?

I use it in both Google Docs SpreadSheet and OpenOffice SpreadSheet.

Answer 1

Using the Mouse

1. Click the cell whose formula you want to repeat
2. A dark square "handle" will appear in the lower right corner
3. Click and drag that handle, dragging down the column (or right across the row)
4. Stop at the last cell you wish to fill

Using the Keyboard

1. Move the cursor to the cell whose formula you want to repeat
2. Hold shift
3. While holding, press down repeatedly to select the rest of the range of cells you want to fill
4. When you reach the bottom, release shift then press CTRL+D (Use CTL+R if you're filling to the right)

---

In both cases what you're doing is called "filling." It is supported by every(?) spreadsheet program.

Answer 2

actually you there is a better way, go ahead and delete all the formulas that are in there right now, then type in the formula in C1 having it correspond to A1 and B1 and hit enter.
so now the correct formula is just in C1,
now click the C1 box, a bounding box will appear, the bottom right corner of this bounding box has a dark square,
double click this square and the formula will 'fill down'
you will notice C2 corresponds to A2 and B2 and so on.
if this is what you need and i am understanding correctly

Answer 3

P.S. I am working in OpenOffice, and now I see that it also works by simply copying the content of the cell and pasting it into the other ones. The formula is automatically adjusted to each row! (To avoid the automatic adjustment prefix the name of row number and column numbers with a $).

Answer 4

You could select the complete column C by selecting the header and paste the formula =A1*(1.6*B1) . it will apply to every row.

No need to select and drag to copy to every cell.

Answer 5

An even easier solution in Google Sheets would be the formula, entered in C1,

=arrayformula(if(A5:A,A5:A*(1.6*B5:B),""))

It will automatically replicate ("Continue") to succeeding rows if a value is entered in column A. No need to copy it to each row, In fact, if you copied it to C2 it would be automatically overwritten by the continuation of the formula in C1.