See below screenshots: (2) Copy and paste multiple non adjacent rows (or columns) which contain the same columns (or rows) 1. Press the Ctrl+ Ckeys simultaneously to copy these nonadjacent cells select the first cell of destination range, and press the Ctrl+ V keys simultaneously to paste these nonadjacent cells. How to copy and paste multiple non adjacent cells/rows/columns in, rows (or columns) which contain the same columns (or rows). How to copy and paste non adjacent cells in excel
