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

Assuming that your data in column B is contiguous, you could just double
click on the grab handle in the lower right hand corner of the cell, when
cell C1 is activated. Alternatively, CTRL C to copy the formula, select
cells C2:C200 and then CTRL V to paste
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"claudia" wrote:

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

There are two ways:
1. copy and paste special choose fourmula.
2. simply drag the c1 by the wright down corner of the cell c1 when it
becomes a black plus sighn.

Kaveh

"claudia" wrote:

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

Hi

Enter
=A1*B1 in C1 and then select the cell and you'l see a small black box at the
bottom right of the cell.

Double click the black box and the formula will fill down as far as there
are data in column B

Mike

"claudia" wrote:

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

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

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

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