Question: how to do multiple copy and paste in excel?
Answer: Open the file that you want to copy items from. Select the first item that you want to copy, and press CTRL+C. Continue copying items from the same or other files until you have collected all of the items that you want. ...  Click where you want the items to be pasted.