| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to put a formula in a column
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to put a formula in a column
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to put a formula in a column
Copy C1, Select C2 to C200 and Paste.
"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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to put a formula in a column
Why don't you look at the responses in your first post?
"claudia" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to put a formula in a column
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 -- claudia "Mike H" wrote: Why don't you look at the responses in your first post? "claudia" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to put a formula in a column
An answer is in the other thread. This is why you shouldn't split the
discussion between multiple threads. -- David Biddulph "claudia" wrote in message ... 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 -- claudia "Mike H" wrote: Why don't you look at the responses in your first post? "claudia" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| highest # in a column A & returns answer from column B Formula | Excel Discussion (Misc queries) | |||
| formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) | |||
| Compare one Column to a Second Column Formula Help Needed | Excel Worksheet Functions | |||
| column to column conditional formatting won't work, need formula | Excel Worksheet Functions | |||
| what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
Linear Mode
