View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susy Susy is offline
external usenet poster
 
Posts: 21
Default Lock cell as reference not value

Hi my name susy,

I'm working on a finacial structure("balance") which I will have to lock for
otheruser. but my formulas keep changing if a move, copy or paste a value in
the worksheet.

please tell me how do I keep the link to the cell A1 if I copy or move
values from A1 to B1? Without getting #REF!,....

because every time I add rows or move some data I have to fix most of my
formulas.