apply a formula to multiple cells

G

Guest

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.
 
B

Bob Phillips

You don't have to do that. Enter it in the first cell then cut and paste in
one operation to all the others.
 
C

CLR

If you use Absolute References, then you could also "drag "n drop" the
formula to adjoining cells

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

If you use Absolute References, then you could also "drag "n drop" the
formula to adjoining cells

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Applying a formula to multiple cells 2
How to... apply the same formula to every cell? 3
extending a horizontally calculated formula vertically 8
Converting a formula to data 3
Blank cells in a formula 2
Formula on a dynamic range of cells 1
Data visible in formula bar, but not in cells 1
Expanding a formula from a cell to a range 5

Top