How to copy multiple columns In Excel
By
SpreadCheaters
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
Formulas
Values
Formats
Comments
Validation
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.
