View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Henrik Henrik is offline
external usenet poster
 
Posts: 43
Default Decoupling cells and formulae

If a formula refers to a cell and the content of that cell is moved then the
formula updates to refer to the destination cell.

Is it possible to somehow decouple this functionality so that a formula does
not change if the content of precedent cells is moved?