Thanks, but what if I'd like to do this with more than one cell?
To copy formulas from A1, A2, A3 to B1, B2, B3.

Michal

"IlanR" wrote:

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.