How can I insert an Excel row & copy the formulas

[Anonymous]

I need to add some rows on an excel sheet to enter additional data. The excel sheet has been set with formulas for the columns. How can I insert a row and keep the formula? Every time I insert a row, the formula does not seem to apply for that row.

[Anonymous]

Do the formulas have the '$' to keep the column and/or row data the same?

Ex:

=$A1*B2

[Anonymous]

Anonymous wrote:Do the formulas have the '$' to keep the column and/or row data the same?

Ex:

=$A1*B2

I don't have that computer with me right now but I don't remember seeing the $ sign in the formulas.

[Anonymous]

After inserting the rows, copy a previous row of formulas and paste it into the new rows. You might have to adjust the formulas so the data input is from the correct cell.

[Anonymous]

Anonymous wrote:After inserting the rows, copy a previous row of formulas and paste it into the new rows. You might have to adjust the formulas so the data input is from the correct cell.

How do I copy the previous row of formulas and paste int into the new rows?

Yikes, I'm really struggling with this.

[Anonymous]

Does the formula stay the same in each column (i.e. the entire length of the column)?
If it does:
1. Click and drag to select the cells above the new row that contain the formulas you want to continue below. (don't highlight the entire row by clicking on numbers on the far left side)
2. Once the cells are selected, you should notice a dark square at the bottom right-hand corner of the last cell you selected
3. Center your mouse/cursor over the dark square so that it looks like a bolded "+" sign
4. Click and drag down to the new row. The cells in the new row should have copied the formula from the row above

[Anonymous]

Anonymous wrote:Does the formula stay the same in each column (i.e. the entire length of the column)?
If it does:
1. Click and drag to select the cells above the new row that contain the formulas you want to continue below. (don't highlight the entire row by clicking on numbers on the far left side)
2. Once the cells are selected, you should notice a dark square at the bottom right-hand corner of the last cell you selected
3. Center your mouse/cursor over the dark square so that it looks like a bolded "+" sign
4. Click and drag down to the new row. The cells in the new row should have copied the formula from the row above

The columns do not have the same formula

[Anonymous]

Anonymous wrote:

Anonymous wrote:Do the formulas have the '$' to keep the column and/or row data the same?

Ex:

=$A1*B2

I don't have that computer with me right now but I don't remember seeing the $ sign in the formulas.

?

[Anonymous]

[Anonymous]

Anonymous wrote:

Anonymous wrote:After inserting the rows, copy a previous row of formulas and paste it into the new rows. You might have to adjust the formulas so the data input is from the correct cell.

How do I copy the previous row of formulas and paste int into the new rows?

Yikes, I'm really struggling with this.

1. Highlight the cells you want to copy

2. Right click and select 'Copy'

3. Move the cursor to the row where you want to insert the copied formulas, right click and select "Paste'

Check to make sure the formulas are correct.

[Anonymous]

Did the tips help, OP?

[Anonymous]

Insert some rows then copy a cell with the formula in it. Then do a "Paste Special" on the target row/s and select "Formula Only". It should auto-adjust the formula.