Forum Discussion
difference between copy and cut in excel
Suppose like I have a function in a cell C1: A1-B1 ; If I cut a value (not a function, a numerical value) from another cell to A1, then function in C1 is not working, showing #REF!, function showing ...
If you know how to use defined Names to reference cells and their contents, the behaviour is more intuitive. If you have two cells named 'newCell' and 'oldCell', then copying the value from 'newCell' to 'oldCell' changes the value in 'oldCell' but a formula
= 100 * oldCell
will still evaluate, albeit to a different value.
If, on the other hand, you cut and paste 'newCell' to 'oldCell', the range name 'newCell' is moved so that it overwrites the 'oldCell' which is destroyed in the process. Any formula involving 'oldCell' will error, but a formula
= 200 * newCell
will remain unchanged; it just happens to be picking up its value from a different location on the worksheet.