preventing formulas from chaging cut and paste is used

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with protected formulas in it. When people use the cut and paste command to move data from one cell to another then the formuals referring to those cells change. how can I stop this from happening?
 
You want to learn more about absolute references in formulas or Paste special

(I am assuming that you want a formula to be moved, and not the value of the cell

by placing a $ before the column and $ before the row, the formula will not change if copied. With a relative formula, the column and row will change, taking into consideration it's new location
 
This is a very common question on the discussion board, whic
unfortunately is also commonly misunderstood by those trying to help
Absolute references ($) will not solve your problem.

Check out this thread from a previous discussion:

http://www.excelforum.com/showthread.php?s=&threadid=193702

Also, seaching the board for use of the INDIRECT fuction will likel
turn up additional threads on the solution to your issue.

Good luck!
 
thank

the use of the indirect function is solving my problem

it is a little tedious to enter in all the formulas but it solves the headache of a protected formula being changed if cut or copy and paste is used on cells the formula refers to
 
Back
Top