Global formula
 

How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another
currency value.

No need for a formula although it is probably better using one, for instance
you can
use a help column and put a formula like

=A2*rate

then just copy down

or you can put the conversion rate in a cell, copy it, select the range and
do editpaste special and select multiply


Regards,

Peo Sjoblom

"George_Papas" wrote:

How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another
currency value.