how to make a formula work for the whole column

  • Thread starter Thread starter claudia
  • Start date Start date
C

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
 
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
 
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
 
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
 
Please don't ask the same question in multiple threads. People don't like
wasting time answering questions which have already been answered.
 
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
 
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.
 
Back
Top