How do I take a selected column and paste it into a new workbook?

Answer by  Roger70 (107)

Highlight the oolumn to be copied, by clicking the letter at the top. Copy the data by pressing the right mouse button and "copy" from the pop-up menu. Open another worksheet, select, in same way, where the copied data will go, and use paste from the menu.

Answer by  exceluser (18)

First of all select the entire column that you want to copy, then click on edit -> copy. Then goto a new workbook, select the column to the right of where you want the column pasted and then click on edit -> paste.