Question: how to copy a column from one excel spreadsheet to another?
Answer: Select the whole column of the first sheet ( call as Sheet 1) by mouse click or by pressing Ctrl + Space.
Now copy the selected column by pressing Ctrl + C.
Go to the sheet where you want to copy the whole column (Let's say Sheet 2)