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.
|