Another way
Go to A1, highlight the Edit line and press Ctrl + C, then press Esc
Now go to B1 and press Ctrl + V
Your formula in A1 is copyied to B1
Ilan
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.