The first tab in the Home ribbon contains controls that copy, cut and paste spreadsheet data. Alternatively, you can write a macro to copy columns.

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.