Question: how to copy and paste a column in excel?
Answer: Step 1: highlight the column or cells you want to copy and paste. If we are to transfer the data in an entire column, we have to first highlight it. ... 
Step 2: Press Ctrl + C to copy column. ... 
Step 3: Press Ctrl + V to paste.