Question: how do you copy a column from one excel sheet 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)