How to put a formula in a column

[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

 

[David Biddulph]

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

 

[Gaurav]

Copy C1, Select C2 to C200 and Paste.

 

[Mike H]

Why don't you look at the responses in your first post?

 

[claudia]

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

 

[David Biddulph]

An answer is in the other thread. This is why you shouldn't split the
discussion between multiple threads.

 

[Miss Kitty]

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.