30 Advanced Excel Tips for 2026

Excel Champs / Range / How to Copy and Paste a Column in Excel
By Puneet Gogia (Microsoft MVP)

How to Copy and Paste a Column in Excel

Copying the data is a very frequent task in our day-to-day lives while working in Excel or any other word processing software. Usually, we have to copy a single cell from one place to another, and sometimes to a different worksheet. It is very easy to do.

But when it comes to copying multiple continuous cells as well as non-adjacent cells, we can find ourselves in trouble.

In this tutorial, we will learn methods to copy the single or multiple (continuous, and non-continuous) columns. Now, let’s go through it step-by-step.

Steps to Copy and Paste the Single Column

  1. First, select the entire column that you want to copy by clicking its Column Header Letter at the top.
  2. Then, right-click and select the “Copy” option from the menu.
    copy-paste-single-column
  3. After this, select the column header (or the cell in row 1) of the column where you wish to “Paste” your data. When you copy an entire column, the paste area must be a whole column or its first cell; any other range gives the “copy area and paste area aren’t the same size” message.
  4. Once you have selected it, right-click and choose the Paste option from the menu.
    paste-single-column

Copying the Column by using a Keyboard Shortcut

Here’s an easier way to copy and paste the data by using the keyboard shortcut instead of doing it manually.

  1. First of all, click on any cell of the column that you want to copy.
  2. From here, select the entire column by pressing the shortcut key (Control + Spacebar).
  3. Next, you can copy the selected column by pressing the Control + C button on the keyboard.
  4. Now, you’ll see that the column is highlighted with a moving border. Select the first cell of the destination column and paste it by using Control + V.

Related ➜ Keyboard Shortcuts for Excel (PDF Cheatsheet)

Copy and Paste Multiple Adjacent Columns

If you want to copy multiple columns of the spreadsheet at the same time, you can do this. Here, below are the steps.

  1. Select the columns in a sequence by dragging across their column headers with the left button of your mouse.
  2. Next, right-click on the selected columns.
  3. Click on the “Copy” option from the menu to copy all the selected columns.
  4. Now, you’ll see that the columns are highlighted. Select the first cell of the destination and paste them by using Control + V.
    paste-multiple-adjacent-columns

Important Note: Make sure that you have enough blank columns where you would like to paste your data. If you already have something in that range of cells, it will be overwritten.

Copy Multiple Non-Adjacent Columns

The simplest way to copy multiple non-adjacent columns is by using the CTRL key. Let’s do it stepwise.

  1. In your worksheet, select the first column by clicking on its header.
  2. After that, hold down the Control key and click the headers of the other columns that you want to copy, one by one.
  3. Following this, right-click on any of the selected columns and choose “Copy” from the menu.
    copy-multiple-non-continuous-rows
  4. Now, you’ll see all the selected columns have been highlighted on the sheet.
  5. In the end, select the destination cell where you would like to paste your data and press Control + V to paste it. Excel pastes the non-adjacent columns next to each other, without the gaps between them.
    paste-multiple-non-continuous-rows

Copy and Paste the Column from the Ribbon

It is an interesting thing to know that you can also copy and paste the values from the ribbon. Let’s do it by the following steps:

  1. First, select all the columns that you wish to copy.
  2. Then, go to the Home tab and in the Clipboard group, choose Copy, or use (Ctrl + C) from the keyboard to copy the columns.
    copy-rows-through-ribbon
  3. Select the particular cell where you wish to paste your data.
  4. And then, click on Paste in the Ribbon, or use the shortcut (Ctrl + V).
    use-paste-option-through-ribbon

So, these are the ways by which you can copy and paste columns in Excel. Moreover, if you want to copy multiple non-adjacent columns, you can use the Control key method above.

Along with this, the above-given shortcut of copy and paste will help you to compile your data as quickly as possible.

Insert a Copied Column without Overwriting

When you paste with Control + V, Excel overwrites the data in the destination column. If you want to add the copied column between your existing columns instead, use Insert Copied Cells:

  1. First of all, copy the column (Control + C).
  2. After that, right-click the header of the column where you want to place the copy.
  3. In the end, choose Insert Copied Cells. Excel inserts the copied column there and shifts the existing columns to the right.

You can also do it with the mouse: select the column, hold down Control and Shift, and drag its border to the new place.

Paste Only Values or the Column Width

A normal paste copies the values, formulas and formatting, but not the column width when you paste into a single cell. Use Paste Special (Control + Alt + V) to choose what to paste:

  • Values: pastes only the results, without formulas and formatting.
  • Column widths: applies the width of the copied column to the destination column. You can also choose Keep Source Column Widths from the Paste options.
  • Formats: pastes only the formatting, without the data.

Copy a Column with VBA

If you copy the same column again and again, a one-line macro can do it for you. The following code copies column A to column D of the same sheet:

Sub copy_column()
Columns("A").Copy Destination:=Columns("D")
End Sub

Frequently Asked Questions

Why does Excel say the copy area and paste area aren’t the same size?

You copied an entire column and selected a smaller range to paste into. Select only the first cell of the destination column, or its column header, and paste again.

How do I copy only the visible cells of a column?

Select the cells, press Alt + ; to select only the visible cells, and then copy. In a filtered range, Excel copies only the visible cells by default.

Can I copy a column to another worksheet?

Yes. Copy the column, go to the other sheet, select the first cell of the destination column, and press Control + V. The steps are the same as on one sheet.

1 thought on “How to Copy and Paste a Column in Excel”

Leave a Comment