How can copy Formula Without Changing its Ref.

[syed_mushraf]

Dear Masters,

How can I copy and paste formula with out chaning its cells positions defined in the formula.

(Musharraf)

 

[maxflia10]

Instead of A1 use $A$1. Is this what you want? From the help file

When you move a formula, the cell references within the formula do not change. When you copy a formula, absolute cell references do not change; relative cell references will change

 

[Jack in the UK]

Hi

A different way might be to select the cell and highight the text in the formula bar [copy - ctrl nad hold press C] and past where you want [ctrl+V]

This will rubber stamp the copied cell [no changes}

Jack