How to copy and paste a column in excel

You can watch a video tutorial here.

So you need to copy a column to another column in Excel.

There’s an easy way to achieve this.

Step 1 – Select your Column

– Select the column you would like to copy by clicking on the column letter.

Step 2 – Copy the Column

– Copy the selected column by either pressing Ctrl C, or
– Right-clicking the selected column letter and selecting Copy in the pop-up menu.

Step 3 – Paste the Column

– Click on the Column name you would like to paste the column to
– Paste the information by either pressing Ctrl V, or
– Right-clicking the selected column letter and selecting Paste in the pop-up menu.

This is an easy way to copy a column to another column and no VBA is needed.