To do this, we need to highlight the cells that we want to copy and paste their contents. How to copy paste multiple cellsĪpart from copying and pasting entire column, we might also be required to copy and paste multiple cells without having to transfer the data of the whole column. This will paste the data into the column. After highlighting the column that we want to paste, we have to press Ctrl + V on the keyboard. Remember that the copied data is held in the Excel clipboard, so it can easily be pasted in another column. Step 3: Press Ctrl + V to pasteīefore we paste the data in a column, we first have to highlight it as well. After copying, we now have to paste the data in a different column. This shortcut will copy the cells in the column.

This will highlight the entire column.įigure 1: Highlighting the column to copy paste Step 2: Press Ctrl + C to copy columnĪfter highlighting the column we want to copy and paste, the next thing to do is to press Ctrl + C buttons on the keyboard. We highlight by simply clicking at the top of the column that we want to copy. If we are to transfer the data in an entire column, we have to first highlight it. We can copy and paste column data using the procedure below Step 1: highlight the column or cells you want to copy and paste Procedure of how to copy multiple cells using keyboard shortcut One among them is the use of keyboard shortcut to copy and paste a column. MS Excel has a number of ways through which we can transfer data from one column to another. Using keyboard shortcut to copy and paste

In this post, we shall learn how copy and paste columns. In some cases, we have to copy a column and paste its contents in another column. We are often required to copy and paste certain data from one cell to another. Working with spreadsheets has become part of our day-to-day office activities.

Copy cells down in excel for mac