How to drag and drop columns in Excel

This is a quick little tip that makes it really easy to move columns of data around in Excel. It’s basically a drag and drop operation – basically.

In the example below, we’ll just move the data in column C over to column B. When done, the column headings will be in order: First Column; Second Column; Third Column.

Drag columns in Excel
Sample worksheet

First, select the entire column. To select a column, click the column heading (one of the letters or double-letters). Don’t select a cell and try and highlight everything – just click the column heading. In this example, click the “C” so that we can move column C.

Drag columns in Excel
Select the column to move

Next, hover your cursor over one of the green vertical bars that border column C. It will look like this: Drag columns in Excel

While your cursor is over one of the vertical bars, press and hold the SHIFT key and press your left mouse button. Now move the cursor to where you want to move the column. In this example, we’ll move the cursor between column A and column B (“First Column” and “Third Column”).

You’ll see a new green vertical bar appear. This is showing you where the column selected will be moved. Release the mouse button when the new vertical bar is where you want to move the column of data.

Drag columns to Excel
Grab green vertical bar and drag

Excel will move the column you selected and insert the column to the new location.

colstep4
Drop when insert bar between columns

See, it’s basically drag and drop to move columns of data in Excel.

Animation of dragging a column in Excel
Dragging a column in Excel

There you go.

Leave a Reply

Your email address will not be published. Required fields are marked *