LiveFlow raises $13.5 million Series A led by New York-based Valar Ventures and launches LiveFlow Next to revolutionize accounting!
Read More
Arrow
Back to guides
Excel Tips

How to Swap Columns in Excel (3 Easy Methods Explained)

In this article, we'll explore various methods to swap or interchange columns in Excel. This task might seem simple, but it can be tricky if you don't know the right steps. We'll cover three methods: Cut and Insert Cut Cells, Drag-and-Drop, and the use of a helper column.

Method 1: Using ‘Cut’ and ‘Insert Cut Cells’ to swap columns in Excel

Step 1: Select the entire column

Click on the letter of the column you want to move to select it.

Step 2: Cut the column

Right-click on the selected column, then click 'Cut' from the drop-down menu. Alternatively, you can use the keyboard shortcuts “Ctrl” (“Command” in case of Mac) + “X” keys.

Image displaying the steps described above to cut a column in Excel

Step 3: Insert cut cells

Right-click on the column to the left of which you want the cut column to appear. Click 'Insert Cut Cells' from the drop-down menu. Repeat the process for all the other columns you want to move in Excel.

Picture showing the ‘Insert Cut Cells’ option in Excel

Note: This method works best when you want to swap adjacent columns in Excel. You can move multiple adjacent columns by selecting all the columns in step 1. 

Learn How to Select Multiple Columns in Excel

Method 2: Drag-and-Drop to move columns in Excel

This method is quite simple and straightforward. Here's how you do it:

Step 1: Select the column

Click on the letter of the column you want to move to select it.

Step 2: Move the cursor

Move your cursor to the edge of the selected column in Excel. Your cursor should change to a symbol with four arrows.

Step 3: Drag and drop

Click and hold the left mouse button, then drag the column to where you want it to be. Release the mouse button to drop the column.

Image displaying the drag-and-drop method to swap columns in Excel

In case the destination column contains data, you will see the below message pop up. Click on ‘OK’ to replace the data in the destination column with the data from the column selected in step 1. 

Picture showing the message that pops up when the destination column contains data in Excel

Note 1: The Drag-and-Drop method is quick and intuitive, but it might be a bit clumsy if you're dealing with a large spreadsheet or if you need to move a column far from its original position in Excel.

Note 2: Keep in mind that this approach can be used when you intend to interchange neighboring columns within Excel. To move multiple adjacent columns, simply select all the columns in the first step.

Learn How to Select Multiple Columns in Excel

Method 3: Adding a helper column to move columns in Excel

This method involves creating an additional column (known as helper column) to help with the swap of columns in Excel. It's particularly useful if the other methods are not suitable. Here are the steps:

Step 1: Insert a new column

Right-click on the letter of the column (to the left of which you wish to move a column) and click on the ‘insert’ option. 

For example: if you wish to move column D to the left of column B, then insert a column to the left of column B.

Image showing steps to add a helper column while moving columns in Excel

Step 2: Copy and paste

Copy the data from the column you want to move, then paste it into the new helper column.

Continuing the above example, copy data from column D (now column E after the helper column was added) and paste it to the newly created column B.

Picture showing steps to copy the original column (which you wish to move) in Excel
Picture displaying steps to paste the original column into the helper column in Excel

Step 3: Delete the original column

Right-click on the letter of the original column (column D, which has now become column E after the addition of the holder column), then click 'Delete' from the drop-down menu.

Image displaying steps to delete the original column (which is copied to the helper column) in Excel

Step 4: Repeat for the other columns

Repeat these steps for the other columns you want to move.

Note: This method is a bit more time consuming, but it ensures that you won't accidentally overwrite or lose data in Excel.

Conclusion

Swapping columns in Excel is not a task you'll need to do every day, but it's certainly a handy skill to have. With these three easy methods, you should be able to move columns around in your spreadsheets with ease, whether they're adjacent or not, and whether you're dealing with small or large data sets.

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Cta Photo

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how!

Get personal help

We guarantee you personal help on chat or Zoom within maximum 6 hours between 9am and 10pm EST.
Blue Tick
Email us at: help@liveflow.io

Liked this article? Then you'll love the ones below

Supercharge your financial reporting today

See LiveFlow in action and discover how to streamline your workflows.