Michal wrote:
Let's say that I have a formula in A1 cell and it refers to A2. I want to
copy it to B1 but I still want it to refer to A2.
So I want to create exact copy of a formula, so it does not change its
refernce cells.


Hi Michal,

Add the $ sign before what shouldn't change !

Copying A1 to B1 with ... will give ...
A2 - B2
$A2 - $A2
A$2 - B$2
$A$2 - $A$2

Regards
FxM