Copying functions

[albatross32]

For example;
A1=5
B1=A1+5

If I copy B1 to B2 it will read A2+5.

How do I copy B1 to B2 so that it will also read A1+5?

 

[njimack]

=$a$1+5

 

[VoG]

Try

B1=A$1+5