Thread: Fixed Reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
filipe filipe is offline
external usenet poster
 
Posts: 2
Default 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.