how to make a formula work for the whole column

[claudia]

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

 

[M Kan]

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

 

[kaveh]

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

 

[Mike H]

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

 

[David Biddulph]

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

 

[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

 

[David Biddulph]

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.