Autofill and copy - help!

[tirades]

I have a prob w Excel 2002,

EXAMPLE:
I have a whole set of values in column cells A....

i need to copy them to column cells C, HOWEVER, i need to use the
formula C1=A1 and then i drag down and autofill for the rest of the
column cells C.... heres the prob
when i click on C2, the formula bar shows =A2, click on C3, formula bar
shows =A3... same goes for all... thats what i want, BUT in the cell it
shows just the same numbers from cell C1 !!
Is that a bug? cos when i click individually in the formula bar for
each cell and enter,
it then shows the value i want... from column A.

Please tell me the way to do it.... anyone.. urgently.. thanks
alot!

 

[Jason Morin]

Check to make sure Excel is *not* set to manual
calculation under Tools > Options > Calculation tab.

HTH
Jason
Atlanta, GA

 

[tirades]

THANKS