View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Miss Kitty[_2_] Miss Kitty[_2_] is offline
external usenet poster
 
Posts: 14
Default How to put a formula in a column

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.
--
Miss Kitty


"David Biddulph" wrote:

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
--
David Biddulph

"claudia" wrote in message
...
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
--
claudia