Home |
Search |
Today's Posts |
#1
|
|||
|
|||
apply a formula to multiple cells
hi,
a colleague of mine presented me with this problem and i've failed miserably. He has several hundred cells with a value in each. He wants to apply a single formula to all cells. Is there as easy way of adding the formula to each cell? - Without having to cut and past the formula into each cell. -- Cheers Stuart |
#2
|
|||
|
|||
You don't have to do that. Enter it in the first cell then cut and paste in
one operation to all the others. -- HTH Bob Phillips "FixitFrog" wrote in message ... hi, a colleague of mine presented me with this problem and i've failed miserably. He has several hundred cells with a value in each. He wants to apply a single formula to all cells. Is there as easy way of adding the formula to each cell? - Without having to cut and past the formula into each cell. -- Cheers Stuart |
#3
|
|||
|
|||
If you use Absolute References, then you could also "drag "n drop" the
formula to adjoining cells Vaya con Dios, Chuck, CABGx3 "FixitFrog" wrote in message ... hi, a colleague of mine presented me with this problem and i've failed miserably. He has several hundred cells with a value in each. He wants to apply a single formula to all cells. Is there as easy way of adding the formula to each cell? - Without having to cut and past the formula into each cell. -- Cheers Stuart |
#4
|
|||
|
|||
If you use Absolute References, then you could also "drag "n drop" the
formula to adjoining cells Vaya con Dios, Chuck, CABGx3 "FixitFrog" wrote in message ... hi, a colleague of mine presented me with this problem and i've failed miserably. He has several hundred cells with a value in each. He wants to apply a single formula to all cells. Is there as easy way of adding the formula to each cell? - Without having to cut and past the formula into each cell. -- Cheers Stuart |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect the cell's formula not be deleted | Excel Worksheet Functions | |||
How do I apply a formula to #s already typed in a series of cells | Excel Worksheet Functions | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Excel - formula to calculate colored fill cells within a range wi. | Excel Worksheet Functions | |||
to copy a formula in cell c1 (+b1/b11) to cells c2-10, how can i . | Excel Worksheet Functions |