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!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

HTH
Jason
Atlanta, GA

>-----Original Message-----
>
>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!
>
>
>------------------------------------------------
>~~ Message posted from http://www.ExcelTip.com/
>~~View and post usenet messages directly from
http://www.ExcelForum.com/
>
>.
>

THANKS

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com