How to make Excel retain the contents of its clipboard [duplicate]
You can use the "Office Clipboard" manager to hold copied data for a longer period of time. Click the button in the lower-right of the Clipboard group to pull it up.
Whenever you copy data, it will be dumped into the manager. To paste the item, click on it. Subsequent Ctrl-V pastes will paste from the highlighted option in the clipboard.