formulas
 

Hello,
Can you tell me how to copy formulas and paste to another location
without them changing?


Thanks

Colin

Hi
you may use absolute references such as
$A$1
instead of
A1

--
Regards
Frank Kabel
Frankfurt, Germany
"Colin McLure" schrieb im Newsbeitrag
...
Hello,
Can you tell me how to copy formulas and paste to another location
without them changing?


Thanks

Colin

Change to absolute by adding $ where desired.
=$a$1*3


--
Don Guillett
SalesAid Software

"Colin McLure" wrote in message
...
Hello,
Can you tell me how to copy formulas and paste to another location
without them changing?


Thanks

Colin