How to Move Columns in Excel (6 Easy Methods)

๐Ÿ–‹๏ธ By Kasper Langmann, Certified Microsoft Office Specialist. ๐Ÿ“… Updated on February 13, 2024.

Knowing how to move columns in Excel is as important as knowing how to copy and paste – it’s essential.

This is something you’d have to do almost all the time while you work in Excel.

So what are you waiting for?

Dive into the guide below where we have listed all the possible ways (and shortcuts) to move columns in Excel๐Ÿš€

Also, to tag along with the guide, download our free sample workbook here.

Method # 1: Using the Shift key

The first (and the basic) method of moving columns in Excel is by using the Shift key.

How? Look into the example below to understand that.

Example data set to move columns in Excel.

The data above consists of three columns.

Let’s say we want to move column C between Columns A and B. Here’s how we will do that:

  1. Select column C by clicking on the column header.
Selecting the column to be moved.
  1. Hover over the edge of the column and a plus sign appears.
  2. Hold down the Shift key when you see the plus sign.
  3. Drag the selected column to the targeted location (before Column B).

Pro Tip!

To move the columns in Excel while keeping the original data intact, we need to use the Shift command all along. This helps you move the columns to the targeted place without disturbing other data.

However, if you try to move the selected column as above using the Control Key, the targeted column will be replaced ๐ŸŽฏ

The final result looks like this.

The column with right or left border has been moved.

Column C (Names) is now placed between the column for Order Number and Amount.

Also, note how the column letter has automatically adjusted here (Column C is now Column B). You can do the same for rows in Excel.

If we had tried to do the same without using the Shift key, Excel would have shown a warning prompt ๐Ÿšฉ

Excel showing warning pop up.

And the result would look something like this:

Data from column C replaces column B

The original column B (Amount) is overwritten as we pasted column C in its place.

Method # 2: Using the insert, cut, and paste hack

This method is usually used by Excel newbies. And honestly, it’s not a very sophisticated approach for moving columns. Nevertheless, it works well.

The process is simple. You just select, insert, cut, paste, and delete. Bounced over your head?

Don’t worry – we’ve got a detailed explanation below.

Let’s use the same dataset as in the example above.

We again want to move column C between columns A and B, but this time, with a new method.

  1. Select the destined column (where you want to move Column C).

In our case, it’s column B (Amount).

Selecting the column.
  1. Right-click column B and select the Insert option from the drop-down menu.
Inserting a new column
  1. A blank column will appear on the left side of the selected column:
New column added.
  1. Select column D or press Ctrl + X to cut or CTRL + C to copy the entire column.

Note that after we’ve inserted an additional column before Column B, all columns have moved an alphabet ahead.

The column for Names (previously Column C) has now become Column D ๐Ÿ‘€

Kasper Langmann, Microsoft Office Specialist

A moving, dotted enclosure will appear around the column. That’s when you’re ready to paste it to the new location.

Selecting column d.
  1. Select the header Column B.
  2. Press down the Control Key + V to paste the column.
Moving column d
  1. Column D moves between columns A and C (previously Column B) successfully.

Too many steps and a little longer process? That is why this is not the best or the primary method to move columns in Excel.

Method #3: Using the CTRL key

Just like we can move columns using the Shift key, we can use the Control key for the same purpose too๐Ÿ˜

There’s only one difference between both methods. When you copy columns using the CTRL key, the copied data is pasted into a new column. But, and that’s a big BUT – the data in the pasted column is replaced.

Didn’t get it? Let’s understand it through an example below.

We are using the same data as earlier, and we want to move Column C using the Control key this time.

  1. Select column C by right-clicking the Column C header.
Selecting column c
  1. Press down the Control key and hover over to the edge of the column until you see a plus sign.
  2. Hold and drag the column to the desired location.
  3. Column C replaces column B and appears right after the first column.
Moving column C in place of column B

What happened here was that when we pressed the Control key, Excel made a copy of column C in place of column B by overwriting column B.

You can now delete column C by clicking delete from the context menu.

Deleting column c.

Method 4: Moving multiple columns at the same time

Okay, so now you know how to move a column in Excel. But do you know how to move multiple columns simultaneously?

We bet you don’t, and we’re here to teach you just that๐Ÿ˜Ž

Let’s say we have this dataset where we want to move columns B and C and bring them before column A.

Column B and C to be moved.

So, how do we do that? Using the Shift key method as we did previously.

  1. Select column C by clicking on the header.
Selecting column C
  1. Press down the Shift key and select the header for column B.
Selecting both columns
  1. Hover over the edge of Column B until the plus sign appears.
  2. Hold and drag the columns and drop them before column A.
  3. The result will look something like this:
Moving columns

Note that this hack works for contiguous columns or contiguous rows only. You cannot use it to move non-contiguous rows and columns in Excel.

Kasper Langmann, Microsoft Office Specialist

Method 5: Move columns to other worksheets

Now that we know how to work with columns in a single worksheet, it’s time we see how to move them to another sheet in the same workbook.

There’s a small but common hack for moving columns from one sheet to another. Let’s see it here๐Ÿ‘€

Using the same example as above, we are moving Column A from Sheet 1 to Sheet 3. To do so:

  1. Create a new sheet from the sheet tab at the bottom by clicking on the + sign shown below.
Adding new sheets
  1. Navigate back to Sheet 1.
  2. Select column A and press CTRL + C if you want to keep a copy of the column in Sheet 1. Otherwise, press CTRL + X to cut the column.
Selecting column A
  1. Go to Sheet 3.
  2. Paste the contents in any column of Sheet 3 by selecting it and pressing CTRL + V.

For example, we’ve pasted it in Column A of Sheet 3 as shown below.

Pasting column A in new sheet

Method 6: Rearrange columns with horizontal sorting

You have probably heard about the Data Sort feature in Excel which allows you to sort your Excel tables. Usually, you vertically sort data in Excel.

But have you wondered if you can horizontally sort data too? ๐Ÿค”

Yes, you can! More than that, you can use the Sort feature to rearrange your columns with horizontal sorting.

If you have a large spreadsheet and you want to change the order of numerous columns, horizontal sorting data could be a major time saver ๐Ÿ‘

To start, you need to add a new row to the very top of your Excel spreadsheet. So…

  1. Right-click row header 1.
  2. Select Insert from the right-click menu.
insert single row

A new row is inserted in your worksheet.

This row must be at the top of the page, above all other header rows or labels.

new entire row
  1. Number the existing columns in the order you want them to appear in the spreadsheet. Enter the numbers in the new top row.
number adjacent columns
  1. Select all the data in the table that you want to rearrange.
selected columns
  1. Go to the Data Tab.
  2. In the Sort & Filter Group, click Sort.
sort multiple rows

The Sort Dialog box appears on your screen.

  1. Click the Options button.
sort pop up menu
  1. Select Sort left to right.
  2. Click OK.
option key

This returns you to the Sort dialog box.

  1. In the Sort By drop-down menu, select Row 1.
  2. Finally, click OK.
moving columns by sort

This is now the result โœ…

The columns are now rearranged according to the order in which you wanted them to appear.

original columns in new position

Now that the columns are rearranged, you can delete the very first row.

And voila! ๐Ÿ˜€

Excel columns

When moving columns, Excel copies the content in cells and moves them to the new location you want them.

This includes text values, numeric values, formulas, and cell formats.

However, cell references are not adjusted. You need to manually adjust the column references. If not, you may see a #REF! error in your cells. So, be careful!

Kasper Langmann, Microsoft Office Specialist

Thatโ€™s it โ€“ Now what?

In this article, you’ve learned the 6 ways to move columns in Excel – this should accommodate any situation you encounter๐Ÿ”ฐ

But there is so much more you can do with columns in Excel. And this article doesn’t do justice in covering even 5% of that information.

There are tons of other things to Excel that you’d want to learn. You can start by practicing with core Excel functions like the VLOOKUP, IF, and SUMIF functions.

Enroll in my 30-minute free email course today to learn these functions (and more!).

Other resources

Curious about the SORT feature in Excel? Click this link to find out how it can powerfully change your data and columns in Excel.

Do you need to turn the rows of your Excel table into columns instead?

You don’t need to recreate your table when you can just transpose data in Excel. Click here to learn how ๐Ÿ˜Š

Frequently asked questions

If you don’t like to move columns by dragging your mouse, you can use the Cut and Paste method. Here’s how:

  1. Click the column header to select the column you want to move.
  2. Press the keyboard shortcut for the Cut command (Ctrl + X).
  3. Right-click the column letter of your desired location.
  4. Select Insert Cut Cells from the right-click menu.

If you can’t move a column in Excel, it may be that this column is a Frozen column.

To unfreeze columns or rows, go to the View Tab. In the Window group, click the Freeze panes dropdown, and select Unfreeze Panes.

You can move your columns in Excel using keyboard shortcuts.

  1. Select the column you want to move.
  2. Press the Ctrl + X to copy columns.
  3. Select the desired destination column letter that will highlight the whole column.
  4. Now, press Ctrl + V to paste.