Hi,

Your example isn't great.

Think you might be talking about Absolute And Relative References

Try this link.

If you want to move your formula from F2 to G1 you can highlight the formula in the formula bar and then select it and cut it. Hit the x to get out of the formula bar and paste into G1

http://www.cpearson.com/excel/relative.htm

VBA Noob