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