difference between copy and cut in excel

jabed 

Why? It's a good question, and my answer would be this: It prevents you from making unintentional errors. If you play around a bit more with that scenario, I think you'll see that it will give you that same result if you cut and paste a formula (not just a value)

Play further, with copy and paste, when it's a formula you're copying and pasting, and you might see this error message, which is letting you do the copy/paste but alerting you to potential problems:

Bottom line: you should be grateful for that #REF! error message.  If in fact your goal was simply to move a value from one cell to another, as part of a desire to redesign the layout, use copy and paste, and then go back and delete the original cell.

Now, I'm saying that simply as a long time user of Excel, not as an official representative of Microsoft or as somebody with inside knowledge of the rules behind the scene....so there may well be a deeper reason. My main point would be not to chafe under what might appear to be an unreasonable barrier.

Or, as Obi-Wan-Kenobi so memorably said, "Trust the Force, Luke."

,