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:

			2	3
1	10		=A4*B4*D2	=A4*B4*D3
2	20		=A5*B5*D2	=A5*B5*D3
3	30		=A6*B6*D2	=A6*B6*D3

<colgroup><col span="3"><col span="2"></colgroup><tbody>
</tbody>

<colgroup><col span="3"><col span="2"></colgroup><tbody></tbody>

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.