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.

How to Copy Columns in Excel Using VBA. Many small businesses use Microsoft Excel for day-to-day accounting and other spreadsheet tasks.

Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

That means you cannot copy an entire column by clicking a column header and copy it into an entire row; instead, you must precisely copy just the range of data.