How to put a formula in a column

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

claudia

the formula a1*b1 is in C1 and i need to place that same formula in every
cell in the c column example: a200*b200 in c200 (the information in each cell
is different) I just don't want to put the formula in each cell help
 
A number of options:
Click in the bottom right hand corner of C1 so that the cursor turns to a
fill handle (black square); drag that down through C2:C200
or
(if B1 to B200 is full of data), just double-click on the fill handle
or
Copy C1. Select C2:C200. Paste
 
It keeps putting the total from c1 into all c column, each one should be
different as each cell has different information ...was hoping for an
alternative suggestion. Didn't mean to waste anyones time
 
An answer is in the other thread. This is why you shouldn't split the
discussion between multiple threads.
 
Hoping Claudia got her answer.
But David is right. Click the formula cell you wish to fill down and it will
have a + in the bottom right corner, click, hold and drag down to the cell
you wish to copy to and release. It will have all zeros until there is
information in your A1 and B1 cells but the formula has now been copied to
all those previous cells.
Hope this helped.
 
Back
Top