Question: how to copy and paste multiple ranges in excel?
Answer: Click Home > in the Clipboard group to display the Clipboard Pane.. ...  And then copy the selected ranges that you need one by one. ...  Select the first cell of destination range you will paste all copied ranges to, and click Paste All button in the Clipboard Pane.