formulas

[Colin McLure]

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


Thanks

Colin

 

[Frank Kabel]

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

 

[Don Guillett]

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