How to copy multiple columns In Excel

You can watch a video tutorial here.

Copying and pasting data will always be a part when working with spreadsheets. This is a very basic command where you select a range in the spreadsheet, and place onto another section of the file.

Step 1 -Hold the CTRL button and select the columns you want to copy

Column C  and E have been selected as an example.

Step 2 – Copy the column

There are 2 options to copy the data:

-Right click on any of the selected columns and choose Copy
-Pressing CTRL + C simultaneously

As you press copy, it will show a jagged line along the border.

Step 3 – Click on the column where you want your data to be placed

For this example, column I has been selected as the destination of the copied data.

Step 4 – Right click and press Paste Special

By clicking on Paste Special, it will show several options on how you you want the data to be placed.

Step 5 – Choose a Paste option and click on it.

The following Paste options are as follows:
All using Source Theme
All except borders
Column widths
Formulas and number formats
Values and number formats

There is also another option to use CTRL + V to paste in the data.

Step 6 – Copied data will be shown on the specified column

In this case, the data was pasted using the All option, which means that all the contents in the cell from the formulas to its formatting has been copied.