How to add rows that include formula in spreadsheet?

Question

I am working with a spreadsheet in OpenOffice. This spreadsheet already has the formulas for each row. I need to add additional rows to this spreadsheet, but don't know how to do so in order that it copys the formula but applies it to that row.

For example, each row has 8 columns (A-H), and there are formulas in D,F,G,and H. The formulas apply to each row, for example the last row on the sheet is the 6th row, so the formulas read like: =+B6*C6, =+E6*B6, etc.

Lets say I need to add a 7th row that utilizes the same formulas, but don't want to have to manually enter it for each new row so that it applies (for example: =+B7*C7, etc) How would I accomplish this?

Answer 1

You can also select (click) the cell with the formula, then drag the little black square in the bottom right hand corner of your selection, down to repeat however many times you need it to.

Answer 2

I found a way. Select the entire row (clicking on the row number), hold Ctrl+Alt and drag the row to the line below. It will copy+insert the row.

You can also copy the entire row and "paste special" (Ctrl+Shift+V) selecting the option to shift the cells down

I just didn't find a way to insert many rows at once with the data.

(I now it´s an old post, but it´s to help people looking on Google)