apply a formula to multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
You don't have to do that. Enter it in the first cell then cut and paste in
one operation to all the others.
 
If you use Absolute References, then you could also "drag "n drop" the
formula to adjoining cells

Vaya con Dios,
Chuck, CABGx3
 
If you use Absolute References, then you could also "drag "n drop" the
formula to adjoining cells

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

Excel VBA 1
Applying a formula to multiple cells 2
extending a horizontally calculated formula vertically 8
How to... apply the same formula to every cell? 3
Conditional formatting in Excel 2010 2
Apply color of one cell to other 2
Converting a formula to data 3
formula 3

Back
Top