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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 05:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com