How do I copy columns from one Excel spreadsheet to another? To copy columns from one Excel spreadsheet to another, you need to click on the column name first in the source file.