Formula Won't Copy As I Need

[alancyoung]

I hope someone can help with what is probably a very simple problem. I am trying to copy formula as follows:
[TABLE="width: 342"]
<colgroup><col span="3"><col span="2"></colgroup><tbody>[TR]
[TD]


[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD] [/TD]
[TD]=A4*B4*D2[/TD]
[TD]=A4*B4*D3[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]20[/TD]
[TD] [/TD]
[TD]=A5*B5*D2[/TD]
[TD]=A5*B5*D3[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]30[/TD]
[TD] [/TD]
[TD]=A6*B6*D2[/TD]
[TD]=A6*B6*D3[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 342"]
<colgroup><col span="3"><col span="2"></colgroup><tbody></tbody>[/TABLE]

I hope this makes sense. I'm trying to copy the formula bothh down and across but I'm guessing both issues are the same.

 

[Dryver14]

Hae a look here it should explain things a little.

Formulas | Formula Referencing | Absolute and Relative Formulas

 

[alancyoung]

Thanks. I knew it would be a simple answer!

 

[Dryver14]

Your welcome,

None of this is easy till we know it, the exercise on the page for making a 12* table is a very good learn.