To copy multiple rows and columns to another sheet in Excel, you do not need to do anything special. That said, you can open the source spreadsheet first, select the rows and columns, and press ...

To copy columns from one Excel spreadsheet to another, you need to click on the column name first in the source file. Then, open the destination file and press Ctrl+V.