Excel cell copying problem 1

[EvolMonster]

Hi All

I have a spreadsheet that i'm trying to keep as dynamic as possible, so I can generate scripts from user entered data.

I have a column that I wish to populate with the same formula all the way down :

Column 1
=C3
=C3
=C3

At the moment, if i drag the top cell down, it populates as below :

Column 1
=C3
=C4
=C5

How do I just copy exactly what is in one cell all the way down?

Thanks in advance
EM

 

[BlueHorizon]

Hi,
To keep the exact same cell references when you copy, you have to make them absolute. You can use the F4 shortcut while clicked in the cell reference in the formula bar.
HTH,

Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[EvolMonster]

Excellent! Thanks for that!
you're a star.