Fixed Reference
 

Hi,

Suppose that a cell contains the formula =A1.

When I cut A1 and paste into A2, the formula becomes =A2.
Is that possible to disable this automatic conversion?
Even using absolute reference (=$A$1), it still happens.

I would like that the formula remain the same (=A1) even if I cut A1
and paste elsewhere.

Thanks in advance!
Filipe.

Fixed Reference
 

Change the formula from =A1 to =INDIRECT("A1")
Bob Umlas
Excel MVP

"filipe" wrote in message
oups.com...
Hi,

Suppose that a cell contains the formula =A1.

When I cut A1 and paste into A2, the formula becomes =A2.
Is that possible to disable this automatic conversion?
Even using absolute reference (=$A$1), it still happens.

I would like that the formula remain the same (=A1) even if I cut A1
and paste elsewhere.

Thanks in advance!
Filipe.

Fixed Reference
 

Bob Umlas wrote:
Change the formula from =A1 to =INDIRECT("A1")

Thanks, it works!

Filipe.