Copy and Paste Data from One Column to Another

How to copy and paste data from one column to another in Ms Excel 2013?

Steps To Follow

To paste the data from one column to an other column, follow the steps below.
Step 1: Click on the column header to select the entire column.
Step 2: Right click on the selected column header and select Copy.
copy paste column data ms excel 2013
Step 3: Now, Select the required column header where you want to copy the data. Right click on the selected column header and select required paste options. Data will be pasted, on the basis of the format you select in Paste options.
copy paste column data1 ms excel 2013
In the below image, data is copied from the column B to the column C.
copy paste column data2 ms excel 2013


Related Topics