If your problem is that, although you have a formula in C2 saying =A2*B2
(and so on down the column), you are seeing in each cell the result of
=A1*B1, then you should check Tools/ Options/ Calculation, and make sure
it's set to Automatic, not Manual.
It's always better to keep the whole discussion in the same thread, then
everyone can see the whole story.
--
David Biddulph

"claudia" wrote in message
...
The information in c1 is being transfered to all c column each cell should
be
different as each cell in columns a and b are different was looking for an
alternative suggestion didn't mean to waste anyone's time ..sorry
--
claudia


"David Biddulph" wrote:

Please don't ask the same question in multiple threads. People don't
like
wasting time answering questions which have already been answered.
--
David Biddulph

"claudia" wrote in message
...
in column c1 the formula is =a1*b1 how to i follow that same formula so
that
is go the whole column in c200 is =a200*b200 with out having to enter
it
200
times

--
claudia